About Restaurant Management System
A database-driven system developed using Java and Oracle DBMS to manage restaurant operations like inventory control, employee schedules, customer orders, and feedback. The project reinforces core DBMS principles like normalization, entity mapping, and optimized SQL querying.
System Walkthrough (Slideshow)
Entity-Relationship diagram showing relationships between customers, employees, orders, and inventory.
Converted ER model into relational tables with keys and constraints for implementation in Oracle.
Query to fetch current menu items from the database using SELECT statement.
List of customers who provided ratings, useful for analyzing feedback trends.
Query showing customers who placed multiple orders — useful for loyalty insights.
My Contribution: I was responsible for designing the ER diagram based on the given problem statement and functional requirements. I also converted it into a relational schema by applying normalization up to 3NF, and implemented SQL queries for key data operations.