INFO6001 Database Management 1 - Assignment 2

Assignment 2: Supertaste Pizza Project - Logical Database Design

In this assignment, steps in the logical database design are conducted (as described below) as well as revising the requirement analysis and conceptual design of assignment 1, and a report is written.

This assignment has 3 parts as specified below.
1. Revise requirements and EER diagram in Assignment 1, based on:

1. Either the EER Model submitted for your Assignment 1. Revise it based on feedback provided by your marker, or
2. Or, complete the partial EER model given at the end of this file, to meet the system requirements.

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.