Assignment Definition:

Use the Conceptual Data Model you designed in Week $1.$ This data model will be reviewed and taken from the conceptual model to logical model status.

Conceptual data modeling is about understanding the organization $$ getting the right requirements built into the database design.

Logical data modeling is about creating stable database structures $$ expressing the organizational requirements correctly in a technical language so that the resulting database operates on a specific type of database technology.

Make sure you define the following:

Specify all attributes for each relation.

Specify the primary key for each relation$/$table$.$

Specify Foreign keys $($keys identifying the relationship between different relations$).$

Review data model to make sure data model is in at least $3$rd normal form $($as defined by the normalization process$).$

Create a logical data model of your week $2$ conceptual data model.