Skip to content

JitendraJoshi2000/Hotel-Mangement-DBMS-Mini-Project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

27 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Hotel-Management-DBMS-Mini-Project

This is Hotel(Restaurant) management project that displays the menu of the hotel and takes orders from customers and generates bills which are recorded in database and also in file. We have considered requirements for the hotel side and have considered 3 major users i.e Customer, Chef, and Waiter.

Frontend: Python(tkinter)

Database used: Sqlite

Scope of Mini Project:-

Scope of project is for managing orders received from customers using 3 Actors/Users in process.

1: Customer side

Project Scope for Customers is only place order for parcels.

2: Hotel side

At the Hotel side there are two GUI's for handling orders i.e.Chef, Waiter GUI.

Chef: Chef receives and completes orders.

Waiter: Waiter can place orders for customers.

Screen Shots:-

Customer Login:

Customer Login

Customer Signup:

Customer Signup

Customer Main Page:

Customer Main Page

Staff Login:

Staff Login

Waiter:

Waiter

Chef:

Chef

Generated Bill:

Generated Bill

Database Schema:-

Customer( email_id varchar primary key , name varchar, phone_no integer, password varchar)

// For Customer

Orders( order_no varchar primary key , date varchar, time varchar, cust_id varchar references Customer(email_id ) )

Items( name varchar, rate integer, quantity integer, order_no varchar references Orders( order_no), status varchar, category varchar, primary key(name,order_no))

// For Waiter

waiter_order( order_no varchar primary key , table_no integer, date varchar, time varchar, cust_name varchar, cust_email varchar)

waiter_Items( name varchar, rate integer, quantity integer, order_no varchar references waiter_order( order_no), status varchar, category varchar, primary key(name,order_no) )

// Record All Orders

Record_Order(order_no varchar primary key)

Record_Items( name varchar, rate integer, quantity integer, category varchar, order_no varchar references Record_Order(order_no))

ER Diagram:

Generated Bill

About

Our DBMS Mini Project

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages