University of Greenwich: COMP1639 Database Engineering Project, Term 1

This document presents a comprehensive solution for a database engineering project, specifically for the COMP1639 course at the University of Greenwich. The project requires the design and development of a relational database for a sport information system, including the creation of an Entity Relationship (ER) model using Chen's or Crow's Foot notation, mapping the ER model to a relational data model normalized to at least 3rd Normal Form, and implementing the database using SQL commands in an RDBMS (excluding Microsoft Access). The solution includes creating and populating at least six tables, along with a view, a trigger, and an index. Furthermore, the project demands the creation of 10 sample SQL queries to demonstrate the expressiveness of the database system, covering various aspects like ordering, joins, aggregate functions, subqueries, and partial matching. The final report comprises a brief description of the database, the ERD, the relational schema, SQL statements for table creation, indexes, triggers, and views, the 10 queries with explanations, and a self-assessment component. The document also provides a URL to the web interface for testing the database queries. The project aims to assess the student's ability to design, implement, and query a relational database system effectively.