COMP1556 Database Applications: University of Greenwich Assignment

This document presents a comprehensive solution for a database applications assignment, likely for a course like COMP1556 at the University of Greenwich. The solution covers various aspects of database design and implementation, starting with the initial assumptions and progressing through conceptual and physical models. It includes detailed SQL code for creating tables (Teacher, Courses, Student, Enrollment, and Content) and inserting data. The assignment also involves completing SQL coding tasks, including SELECT queries with joins, ORDER BY clauses, runtime input, GROUP BY, and subqueries. Screenshots of the results are provided. The solution concludes with a self-evaluation section where the student reflects on what went well, areas for improvement, and lessons learned. Finally, a self-marking section is included, likely based on the assignment brief, to assess the work against specific criteria such as assumptions, conceptual and physical models, database implementation, coursework queries, and overall evaluation. The assignment demonstrates a practical understanding of relational database concepts and SQL programming.