Faculty of CEM: Database Design and Implementation Project (IMAT5103)

This document presents a comprehensive solution to a database design and implementation project, addressing the requirements outlined in the Faculty of Computing, Engineering and Media (CEM) coursework specification for the IMAT5103 module. The solution begins with an Entity-Relationship (ER) diagram representing the database schema, followed by the creation of tables using SQL, including defining primary and foreign keys to ensure data integrity. The project also includes the creation of indexes to optimize database performance. The document then populates the tables with sample data and provides SQL queries for data selection, inner and outer joins, count expressions, sorting, conditional filtering (using operators like , LIKE, and IN), and subqueries to demonstrate the database's functionality. References to external resources are also included. The project covers various aspects of database design, implementation, and querying, providing a practical understanding of database systems and design principles.