You will also produce a document where you will include:

$$ Challenges you faced in the development process and your strategies to overcome them.

$$ The rationale for your design decisions.

$$ Database conceptual design using CHEN notation. You can use tools such as draw.io to achieve this. In the diagram, you need to identify entities, attributes and relationships.

$$ Logical design. Transform the conceptual representation from above to the logical structure in the Relational Model.

$$ Validate the Relational Model and determine if Normalisation is necessary Include a short paragraph to explain that design is in $1$NF$,2$NF$,3$NF$.$

$$ Physical design: Produce the SQL create statements for each relation including INSERT statements $($dummy data$).$

$$ Appendix with your database file.