Café Menu & Order Tracker is a small project for majorly understanding and visualizing the database operations with web inteface. This project was for my academic course CSE 3110 - Database Systems Laboratory (1.5 credit hour).
The Café Menu & Order Tracker with Ratings is a simple database-driven web application built as part of the CSE3110 – Database Systems Laboratory course.
It demonstrates SQL queries, CRUD operations, relational integrity, and the use of multiple interlinked tables.
The project features:
- A Customer Interface for browsing the menu, placing orders, and rating items.
- An Admin Panel for managing customers, menu items, orders, and feedback.
- View café menu (categorized items with prices).
- Place new orders (select multiple items with quantities).
- Give ratings (1–5 scale) and optional comments on menu items.
- Manage customers (add, update, delete).
- Manage menu items (add, edit, remove).
- View and manage orders (track, cancel, update).
- View and manage ratings/feedback.
The project uses 5 interlinked tables:
-
Customers
cust_id(PK),name,contact,email
-
Menu
item_id(PK),item_name,category,price
-
Orders
order_id(PK),cust_id(FK → Customers),order_date,total_amount
-
Order_Items (Mapping table)
order_id(FK → Orders),item_id(FK → Menu),quantity
-
Ratings
rating_id(PK),cust_id(FK → Customers),item_id(FK → Menu),rating,comment
- Customers → Orders: One-to-Many (a customer can place many orders).
- Orders ↔ Menu (via Order_Items): Many-to-Many.
- Customers ↔ Menu (via Ratings): Many-to-Many.
- Orders → Order_Items: One-to-Many.
- Menu → Ratings: One-to-Many.
- Frontend: ASP.NET Web Forms / HTML / CSS / JavaScript
- Backend: C# (Code-Behind), ASP.NET
- Database: MySQL / SQL Server (depending on setup)
- Version Control: GitHub
- Clone the repository:
git clone https://github.com/your-username/cafe-menu-order-tracker.git cd cafe-menu-order-tracker