Should the designs for the databse must match the final database itself?
Yes. The designs should match the final database. AO1 is graded according to the quality and scope of the designs. AO2 assesses how closely the functional databse matched the design. If the design has to be changed because the database created from the original design was not functional then it would be best to also include an updated design as well as the original. It’s best if an explanation is given as to how and why the design has been updated.