Your Task
Your task is to complete a database design for the Assignment 1 case study.
Model the system described in the case study by drawing a physical data model (ER diagram) using MySQL Workbench. Your ER diagram must conform to the notation used in this subject (object notation = ‘Workbench Simplified’, relationships notation = ‘Crows Foot’, show data types). Your model should be in at least 3rd normal form.
Create also a data dictionary which includes short explanations of the purpose and structure of your 3 largest entities (“largest” means having the most columns). Follow the format in the example Data Dictionary provided.
Create also a work breakdown which identifies the work performed by each group member. This should take about half a page of text.
If you are uncertain about any detail, seek clarification via LMS or at a Student Consultation.
