INFO6001 -2017 T1 - School of EEC, University of Newcastle, Callaghan, Australia

1. Revised content of assignment 1: Requirement Specification, EER Diagram and Data Dictionary, Transaction Requirements, Business Rules * Requirements Specification (Clarity and completeness) * EER Diagram and Data Dictionary 15 marks +Rightness & Completeness of EER model +Data dictionary and documentation * Transaction Requirements * Business Rules   2. Mapping of the EER model to the relational model in DBDL +Mapping of each relation & attributes +Mapping of each relationship   3. Normalizing the relational schema to Boyce-Codd Normal Form +Discussion of functional dependencies, and process of normalising up to BCNF for all relations (e.g., if a relation is in 2nd normal form, give your reason why it is in 2 nd form, then show all the process to normalise it up to BCNF).   4. Report Writing +style, grammar, etc.