Tiffin-Booking-System

This is a non-GUI Python-MySQL integrated system which is based on the topic "Tiffin Booking System".While booking(ordering) thing on the internet you may be curious to know about how these system work in the background , tiffin-booking system can make you understand the same and the programmers can get to know about the login-system logic as well as a better understanding about the conditional (if-else) statements . The various options available for the users include :-

• Sign-Up
• Log-In
• Book the Tiffin
• Check the booked Tiffin Status
• Check Tiffin and Customer Details
• Update Details
• Cancle Tiffin Subscription
• Master Login (by this the owner of the tiffin compay can check the total sale the no.of accounts created )

The data that will be entered by the user will be saved , updated in the sql database that will be locally created and stored.

Kindly read the instructions given below throughly to setup the project successfully on your local machine.

Prequsites

• Python
  • IDE
• Python Libraries
  • pandas
  • getpass
  • os
  • tabulate
  • datetime
  • mysql.connector
• MySQL
  • Server
  • Workbench

Installation

• Python : https://www.python.org/downloads
• Libraries : Use the pip install library_name command in terminal to install all libraries
• MySQL : https://dev.mysql.com/downloads

Setting Up

• Download both the python(.py) and mysql(.sql) file.
• Open the MySQL Workbench and open the mysql(.sql) script file which you have downloaded.
• Now follow the instructions strictly in the commented section and run the statements one by one from top to bottom.
  • WARNING! Don't make any changes in the table name and delete the database with the similar name as the script if you have any.
  • WARNING! Run the statement to create customer_info table at the end after creating all other tables from Tiffin_Type to Master_Login as it contains foreign key constraints.
• When you reach at the point creating Master_Login table ,create the table and before inserting values in it you can change the master username and password by changing the create_username and create_password under the quoted marks according to yourself.
• After running all the statements use the SHOW TABLES; statement and verify that you have created all the tables successfully.
• Now open the python(.py) file while you have earlier downloaded and run the code.
  • WARNING! Visual Studio Code is recommended as some libraries may not work in terminal or other python IDE's.
• Now in the 11th line use your mysql user and password in place of your_user and your_mysql_password respectively if you have not set the password then remove the passwd word.

If you have set the password If you have not set the password

• You have successfully started the Tiffin-Booking System ,you can now follow the instruction and explore it.

How To Use

• Here are some snips showing an example user using the system

• User is asked for Sign-Up or login choice

• 2

• 3

• 4

• 5a

• 5b

• 6a

• 6b

• 7

• 8

• 9

• 10a

• 10b

• 11

• 11a

• 12

• 13

• 14

• 15a

• 15b

• 15c

• 16a

• 16b

• ER DIAGRAM OF SQL DATABASE