INFO6001: Logical Database Design- Database Management- Report Writing Assignment

Internal Code: MAS7282

Report Writing Assignment:

Task: In this assignment, steps in the logical database design are conducted (as described below) as well revising  the  equirement analysis and conceptual design of assignment 1, and a report is written. This assignment has 3 parts as specified below. 1. Revise requirements (data requirements, transaction requirements & business rules), EER diagram and Data Dictionary submitted for your Assignment 1 based on feedback provided. 2. Map the EER model to the relational model. Document the relational schema in DBDL (Sample format is given below) ISBN (id, number, itemNo) Primary Key id Alternate Key number Foreign Key itemNo references Book(itemNo) ON UPDATE CASCADE, ON DELETE CASCADE 3. Normalize the schema to Boyce-Codd Normal Form (if any relation is not already in BCNF). The final normalised schema must be documented in DBDL. The final report should include the following 1. Requirement Specification (including data requirements, transaction requirements and business rules) 2. EER Diagram and Data Dictionary 3. Normalized Relational Schema in DBDL. Ensure that normalization steps are shown if any.