ARMY PUBLIC SCHOOL
Nehru Road
IT PROJECT
2025-26
TOPIC: RESTAURANT MANAGEMENT SYSTEM
NAME: RAJVANSH SINGH
CLASS: XII-C
ROLL NO: 19
CERTIFICATE
This is to certify that Rajvansh Singh, student of class XII-C,
session 2025–26, has successfully completed the Information
Technology Project on the topic “Restaurant Management
System” under the guidance of Mr. Gaurav Mishra for the
academic year 2025–26.
The student has been dedicated throughout the project work and
has completed it within the given time frame. This project is the
original work of the student and can be submitted for evaluation.
TEACHER’S SIGNATURE
2
ACKNOWLEDGEMENT
I would like to express my sincere gratitude to my Information
Technology teacher Mr. Gaurav Mishra for providing me with the
opportunity to work on this project on the topic “Restaurant
Management System”. Their constant guidance, encouragement,
and valuable suggestions throughout the course of this project
helped me understand the practical application of SQL and
database management concepts.
I am thankful for the continuous support and feedback provided
during the planning and development stages of this project, which
enabled me to improve my logical thinking and problem-solving
skills. This project has helped me gain a deeper understanding of
how databases are used to manage real-world systems efficiently.
I would also like to thank my school for providing a supportive
learning environment and the necessary resources required to
complete this project successfully. Lastly, I am grateful to my
friends and classmates for their cooperation and assistance
whenever needed during the completion of this project.
3
INDEX
S. No. Content Page No.
1 Certificate 2
2 Acknowledgement 3
3 Introduction 5
4 Database Overview 6
5 Database Creation 7
6 Table Structure – MENU 8
7 Table Structure – EMP 9
8 Table Structure – CUSTOMERS 10
9 Table Structure – ORDERS 11
10 Table Structure – ORDER_ITEMS 12-13
11 Data Insertion 14-16
12 SQL Queries 17-18
13 Project Output 19-21
14 Conclusion 22
4
INTRODUCTION
In today’s digital era, database management systems play a vital
role in the efficient functioning of various real-world applications.
Restaurants, in particular, require proper data management to
handle menu details, employee information, customer records,
and orders in an organized manner. The Restaurant Management
System is a database-based project designed using SQL to manage
these operations effectively.
The main objective of this project is to design and implement a
structured database that can store, retrieve, and manage
restaurant-related data efficiently. This system helps in maintaining
accurate records of dishes available on the menu, employees
working in the restaurant, customers who dine at the restaurant,
and the orders placed by them.
By using relational tables and proper linking between them, this
project demonstrates how SQL can be used to represent real-life
relationships in a database. The Restaurant Management System
reduces data redundancy, improves data consistency, and allows
easy access to information, making restaurant operations more
systematic and reliable.
5
DATABASE OVERVIEW
The Restaurant Management System is designed using a relational
database approach, where data is stored in multiple tables that
are linked to each other using unique identifiers. Each table
represents a specific real-world entity involved in restaurant
operations, such as menu items, employees, customers, and
orders.
The database consists of the following main tables:
• MENU – Stores details of all dishes available in the restaurant,
including dish ID, dish name, and price.
• EMP – Stores information about restaurant employees such as
chefs, waiters, and managers.
• CUSTOMERS – Maintains records of customers who dine at
the restaurant.
• ORDERS – Stores information about orders placed by
customers and the employees who served them.
• ORDER_ITEMS – Stores detailed information about each dish
included in an order, along with quantity and the chef who
prepared the dish.
These tables are connected using primary keys and foreign keys, which help
maintain data consistency and avoid duplication. By using this structured
approach, the database ensures efficient storage, easy retrieval, and
accurate management of restaurant-related information.
6
DATABASE CREATION
Before creating tables, a database must be created to store and
manage all restaurant-related data. In this project, a database
named “rst_management” is created to hold all tables such as
menu, employees, customers, and orders.
The following SQL commands are used to create and select the
database:
The “CREATE DATABASE” command creates a new database,
while the “USE” command selects the database so that all
subsequent tables and queries are executed within it.
7
TABLE STRUCTURE: MENU
The “MENU” table is used to store information about the dishes
available in the restaurant. Each dish is assigned a unique
“DishID”, which helps in identifying dishes and linking them with
customer orders. Storing menu details in a separate table avoids
repetition of dish information and makes updates easier.
Column Name Data Type Key Description
DishID INT Primary Key Uniquely identifies
each dish
DishName VARCHAR(100) Name of the dish
Price INT Price of the dish
The “DishID” serves as the primary key of the table and ensures
that no two dishes have the same identifier. This table does not
depend on any other table and acts as a base table in the database.
8
TABLE STRUCTURE: EMP
The “EMP” table stores information about the employees working
in the restaurant. This includes staff members such as managers,
chefs, and waiters. Each employee is assigned a unique “EmpID”,
which helps in identifying employees and linking them with orders
and food preparation records.
Column Name Data Type Key Description
EmpID INT Primary Key Uniquely identifies
each employee
Name VARCHAR(100) Name of the employee
Post VARCHAR(50) Job role of the
employee
Salary INT Monthly salary of the
employee
The “EmpID” acts as the primary key of the table, ensuring that
each employee's record is unique. This table is also independent
and can be referenced by other tables, such as orders and order
items.
9
TABLE STRUCTURE:
CUSTOMERS
The “CUSTOMERS” table stores information about customers who
dine at the restaurant. Each customer is assigned a unique
“CustID”, which helps in identifying customers and linking them
with their respective orders. This table helps maintain customer
records in an organized manner.
Column Name Data Type Key Description
CustID INT Primary Key Uniquely identifies
each customer
Name VARCHAR(100) Name of the customer
The “CustID” serves as the primary key of the table and ensures
that every customer record is unique. This table is referenced by the
ORDERS table to associate orders with customers.
10
TABLE STRUCTURE: ORDERS
The “ORDERS” table stores information about orders placed by
customers in the restaurant. Each order is assigned to a unique
“OrderID”. This table connects customers with the employees who
served them, making it a key table for maintaining relationships in
the database.
Instead of storing customer and employee names directly, their IDs
are stored. This helps avoid data duplication and ensures accuracy.
Column Name Data Type Key Description
OrderID INT Primary Key Uniquely identifies
each order
CustID INT Foreign Key Identifies the customer
who placed the order
Date DATE Date on which the
order was placed
ServedByEmpID INT Foreign Key Identifies the
employee who served
the order
The “CustID” is a foreign key that references the “CUSTOMERS”
table, and “ServedByEmpID” is a foreign key that references the
“EMP” table. These relationships ensure that orders are linked only
to valid customers and employees.
11
TABLE STRUCTURE:
ORDER_ITEMS
The “ORDER_ITEMS” table stores detailed information about the
dishes included in each order. Since a single order can contain
multiple dishes, this table helps break down an order into individual
items. It also records the quantity of each dish and the employee
(chef) who prepared it.
This table plays a crucial role in establishing a many-to-many
relationship between orders and menu items.
Column Name Data Type Key Description
OrderItemID INT Primary Key Uniquely identifies
each order item
OrderID INT Foreign Key Identifies the order
DishID INT Foreign Key Identifies the dish
ordered
Quantity INT Number of units
ordered
CookedByEmpID INT Foreign Key Identifies the chef who
prepared the dish
The “OrderID”, “DishID”, and “CookedByEmpID” columns act as
foreign keys that reference the “ORDERS”, “MENU”, and “EMP”
tables respectively. This ensures that each ordered dish is linked to
a valid order, a valid menu item, and a valid employee.
12
13
DATA INSERTION
After creating the database and tables, sample data is inserted into
each table to simulate real-world restaurant operations. This data
helps demonstrate how information is stored and later retrieved
using SQL queries.
1. Inserting Data into MENU Table:
14
2. Inserting Data into EMP Table:
3. Inserting Data into CUSTOMERS Table:
15
[Link] Data into ORDERS Table:
5. Inserting Data into ORDER_ITEMS Table:
16
SQL QUERIES
SQL queries are used to insert data into tables, retrieve
information, and perform operations on the database. In this
project, various SQL queries are used to manage restaurant data
efficiently.
1. Displaying All Menu Items:
This query displays all dishes available in the restaurant along with
their prices.
2. Displaying Employee Details:
This query retrieves information about all employees working in the
restaurant.
3. Displaying Customer Records:
This query shows the list of customers who have dined at the restaurant.
17
4. Displaying Orders with Customer Names:
This query displays order details along with the names of
customers who placed the orders.
5. Displaying Orders with Serving Employee:
This query shows which employee served each customer’s order.
6. Calculating Total Bill for Each Order:
This query calculates the total bill amount for each order based on
the dishes ordered and their quantities.
18
PROJECT OUTPUT
The following screenshots show the successful execution of the
SQL queries used in the Restaurant Management System. These
outputs verify that the database tables are correctly created, data
is properly inserted, and relationships between tables are
functioning as expected.
1. MENU Table Output:
19
2. EMP Table Output:
3. CUSTOMERS Table Output:
20
4. ORDERS Table Output:
5. ORDER_ITEMS Table Output:
6. Total Bill Calculation Output:
21
CONCLUSION
The Restaurant Management System is a practical implementation
of SQL concepts used to manage real-world data efficiently.
Through this project, a relational database was designed to store
and organize information related to menu items, employees,
customers, and orders in a structured manner.
By using multiple tables and establishing relationships through
primary and foreign keys, the system ensures data consistency and
reduces redundancy. The successful execution of SQL queries and
accurate outputs demonstrates that the database functions
correctly and fulfills the objectives of the project.
This project helped in developing a better understanding of
database creation, table relationships, data insertion, and query
execution using SQL. Overall, the Restaurant Management System
serves as an effective and reliable solution for managing
restaurant-related data.
22