dchandak99/restaurant-management

Restaurant Management System

This project was done as part of the Database Systems Lab (CS387) in the third year of our undergrad.

Highlights

• Created a GUI website application for a Restaurant Management System with cookie based login authentication
• The application creates an ordering pipeline (placing an order, alloting to a chef, then served by a waiter) that simulates a real-world restaurant system
• A customer can view his order history, recommended dishes, filter dishes based on cuisine and budget and place an order, chef/waiter can view profile and complete orders alloted
• The owner can view and update inventory and employee information, allot orders to chef/waiters and can view analytics and graphs on top dishes, top employees and statistics on profits, expenditure and wastage (Analytics filterable on date ranges)
• Used MVC architecture in NodeJS (Express), PostgreSQL, Bootstrap, ChartJS, html2pdf.js

Deliverables

The project was spread out over several deliverables which can be found here:

• Deliverable 1: Scope Document: Google Doc or pdf
• Deliverable 2: Analysis, Requirements, ER Model, Use Cases, Technology Choices: Google Doc or pdf
• Deliverable 3: Data Model, Generation, Screen Designs, Transactions: Google Doc or pdf
• Deliverable 4: Detailed Test Plan: Google Doc or pdf

Final Report and Presentation

• Project Report: Google Doc or pdf
• Presentation for Demo: Google Slides or pptx

Code and Data

• Data can be found in the Tables directory.
• code is in the code directory and contains the full implementation.

ER Diagram

• ER Diagram can be found here.