Task 1: Conceptual design (all students)
List your assumptions if you have.
Draw an EER or ER diagram for the conceptual design of the database.
(If your ERD is well-done and your translation is correct, your tables should be in 3NF in most cases).
Task 2: ERD to table translation (all students)
Translate your EERD or ERD to tables. Clearly show the primary key, foreign keys, and alternate keys.
In this task, you need to list the tables obtained directly from your ERD or EERD, including all attributes, PKs and FKs.
This task should not be mixed together with the next task.
Task 3: Schema refinement and documentation (all students)
Check your tables are at least in 3NF. If not, modify your ERD or do normalization here.
If you choose to use non-3NF tables, provide reasons why.
Assign appropriate data types and lengths to all attributes.
Refine the schema to include necessary constraints such as domain constraints and null value constraints.
Attachment:- 354508_1_DatabaseDesignAssignment-S213-2.pdf