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 Signup:

Customer Main Page:

Staff Login:

Waiter:

Chef:

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: