INFO6001: Database Management

Faculty of Engineering & Built Environment, School of Electrical Engineering and Computing Assignment 2: Gourmet Pizzas Project - Logical Database Design 1. Revise requirements and EER diagram in Assignment 1, based on:   i. Either the EER Model submitted for your Assignment 1. Revise it based on feedback provided by your marker, or   ii. Alternatively, complete the partial EER model given at the end of this file, to meet the systems 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.