The following must be included: •Initial ER diagram •Normalisation •Mapping to tables •Documentation Initial ER diagram Draw an ER diagram which must indicate the following: •Optionality of relationships (may or must) •Cardinality of relationships (one or many) •Optionality of attributes (* or o) •Clear indication of PKs and FKs •Named relationships and entities Use normalisation •List the attributes from the scenario. •Place the attributes in zero normal form. •Normalise the attributes to third normal form. Show each of the intermediate normal forms. •Draw an ER diagram from the third normal form. •Alter the ERD (or create a new ERD) to show relationship naming and optionality. Mapping to tables •Create an initial database design from the ER diagram created from 3NF and provide at least two rows of sample data. Documentation •Describe the purpose of the project. •Describe each attribute and its function in the system. •Describe possible changes when mapping to an actual database.
