Assignment title: Management
Question
ITECH1006/5006 Database Management Systems
Q
Write on this topic Development of an ER Diagram and Database Implementation. 1. How clear and well-presented your submission is.
2. E-R diagram: adherence to our standard, assumptions made, inclusion of correct primary
CRICOS Provider No. 00103D Assignment 1 Specification Page 3 of 4
and foreign keys, appropriate entities, relationships, and attributes.
3. Normalisation: appropriate interpretation of each normal form, arguments for leaving the
schema in the normal form you consider optimal.
4. Conversion of E-R diagram to relational schema: schema is a correct translation of the E-R
submitted with appropriate tables, columns, and primary keys.