Reel Entertainment Database | School Project

Entity-Relationship Diagram

A school project intended to teach students the full cycle of database development. The first section of the assignment was to design an ER diagram based on a conceptual schema provided by the professor. From there students had to code a series of SQL create table statements to implement the ER diagram on McMaster's DB2 server. Lastly, students were required to create a number of complex SQL queries to retrieve specific information from the newly created database.