Gourmet Garden: Restaurant Database Management System
This project was developed as part of CIS 9340 – Principles of Database Management Systems at Baruch College.
​
Overview
This presents a fully relational database for a fine-dining restaurant to manage real-world operations like reservations, orders, staff scheduling, billing, and customer feedback.
Developed using Microsoft Access and SQL, the system transforms manual processes into a digital framework with a strong relational structure and integrity. It features an end-to-end design — from ER modeling and normalization to SQL implementation — ensuring reliability, scalability, and ease of data retrieval.
​
What we built
-
Designed ER diagrams and relational schemas based on business logic
-
Applied 1NF to 3NF normalization to remove redundancy and improve structure
-
Wrote SQL DDL/DML scripts to create tables, insert sample data, and run analytical queries
-
Implemented billing integration with support for cash and card payments
-
Enforced data consistency using primary and foreign key constraints
​
Outcome
The system enhances restaurant efficiency by automating key workflows and enabling fast, accurate access to operational data. It also supports better decision-making through reliable reporting and a clean data structure
​
​​