ISYS224 S2 2019 Assignment 1: Database Design and Implementation

This document presents a comprehensive solution to ISYS224 Assignment 1, focusing on database design and implementation. The solution encompasses a conceptual data model (EER model), a logical data model, and a discussion of the transformation process. It includes the creation of DDL scripts to define database tables, followed by the population of these tables with sample data. The assignment concludes with the execution of various SQL queries to retrieve and manipulate the data, demonstrating a complete understanding of database design principles, relational database concepts, and SQL syntax. The solution covers key aspects of database design, including the creation of tables, defining primary and foreign keys, and writing SQL queries to retrieve specific information from the database. This assignment addresses the key concepts of database design, including data modeling, data definition, and data manipulation. The solution demonstrates the student's ability to create a well-structured database and execute SQL queries for data retrieval and analysis.