Draw an EER or ER diagram for the conceptual design of the database. List all of your assumptions. Task 2: ERD to table translation (20 marks) Map your EERD or ERD to tables, using the rules in text...

Draw an EER or ER diagram for the conceptual design of the database.  List all of your assumptions.
Task 2: ERD to table translation (20 marks)  Map your EERD or ERD to tables, using the rules in text or lecture slides.  Clearly show the primary key, foreign keys, and alternate keys.
Task 3: Schema refinement and documentation (10 marks)  Check your tables are at least in 3NF. If not, modify your ERD or do normalization.  If you choose to use non-3NF tables, provide the reasons why.  Assign appropriate data types and lengths to all attributes.   Refine the schema to include necessary integrity constraints such as domain constraints, null value constraints and possibly more complex business rules.    Document your final database schema clearly, e.g., you may use a form similar to the following one.