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