ISYS224: Database Design and Implementation Assignment 1

This document presents a comprehensive solution for ISYS224 Assignment 1, focusing on database design and implementation. It begins with a conceptual data model presented as an enhanced ER (EER) model, identifying generalizations, specializations, and weak entities, along with assumptions. The solution then transitions to a logical data model, detailing table structures, primary and foreign keys, and a discussion of the translation process from the conceptual model. The assignment continues by listing functional dependencies for each relation, identifying the normal form of each relation, and providing justifications. Finally, the solution includes DDL scripts to implement the relational data model in MySQL, along with snapshots of the tables populated with data, demonstrating the practical application of the database design principles discussed throughout the assignment. The solution also contains the SQL scripts for the database tables and data population.