ISYS224 S2 2019 Assignment 1: Database Design and Queries

This assignment solution for ISYS224, a database design and implementation course, covers conceptual and logical data modeling, DDL scripting, and SQL queries. The solution begins with a conceptual data model in the form of an enhanced ER (EER) model, identifying generalizations, specializations, and potential weak entities. The model is then translated into a logical data model, with foreign keys introduced to represent relationships. The assignment includes a detailed explanation of the translation process. Furthermore, the solution provides the DDL script to create the database tables, along with sample data insertion queries. Finally, the assignment presents five DML queries demonstrating data retrieval and manipulation, including queries that use subqueries, joins, and aggregation functions. This comprehensive solution provides a valuable resource for students studying database design principles and SQL query writing.