warningThis project was completed for coursework and is no longer maintained. Names and details have been modified for academic integrity. Below is a summary of the university’s main requirements.
Requirements link h2
Design a normalized physical database model for an ordering system (Bagel Corner)
Create a database for another business (Mister Coffee) using a provided design document
Load tables with sample data and create a view and an index to enhance query performance
Develop SQL queries, including a simple query and a more complex query involving table joins