Kendriya Vidyalaya Ambernath
ACADEMIC YEAR : 2022-23
PROJECT REPORT ON
DAILY TRAVEL BOOKING
ROLL NO : 12112
NAME : Dipankar Sonawane
CLASS : XII
SUBJECT : COMPUTER SCIENCE
1
kendriya Vidyalaya Ambernath
CERTIFICATE
This is to certificate Dipankar Pankaj sonawane of Class XI- A having CBSE
ROLL NO.12 has satisfactorily completed the “COMPUTER SCIENCE
INVESTIGATORY PROJECT” for ALL INDIA SENIOR SECONDARY
CERTIFICATE EXAMINATION 2022-2023.
2
TABLE OF CONTENTS [ T O C ]
SER DESCRIPTION
01 ACKNOWLEDGEMENT
02 INTRODUCTION
03 OBJECTIVES OF THE PROJECT
04 FLOW CHART
05 SOURCE CODE
06 OUTPUT
07 HARDWARE AND SOFTWARE REQUIREMENTS
08 BIBLIOGRAPHY
3
ACKNOWLEDGEMENT
Apart from the efforts of me, the success of any project depends largely on the
encouragement and guidelines of many others. I take this opportunity to express my
gratitude to the people who have been instrumental in the successful completion of
this project.
I express deep sense of gratitude to almighty God for giving me strength for the
successful completion of the project.
I express my heartfelt gratitude to my parents for constant encouragement while
carrying out this project.
I gratefully acknowledge the contribution of the individuals who contributed in
bringing this project up to this level, who continues to look after me despite my flaws,
I would like to express my special thanks of gratitude to our Principal , Mr.
Deepak Singh Bhati and My Computer Teacher Mrs. Kshama Raut who gave
me the golden opportunity to do this wonderful project on the topic "DAILY
TRAVEL BOOKING", which also helped me in doing a lot of Research and I
came to know about so many new things I am really thankful to them.
4
PROJECT ON DAILY TRAVEL BOOKING
INTRODUCTION
This software is helpful to citizens ,being exploring in nature and also in urgency to
go for a board towards achieving their respective objectives . For booking the transport
, this application allows user friendly environment.
OBJECTIVES OF THE PROJECT
The objective of this project is to let the students apply the programming
knowledge into a real- world situation/problem and exposed the students how
programming skills helps in developing a good software.
1. Write programs utilizing modern software tools.
2. Apply object oriented programming principles effectively when developing small
to medium sized projects.
3. Write effective procedural code to solve small to medium sized problems.
4. Students will demonstrate a breadth of knowledge in computer science, as
exemplified in the areas of systems, theory and software development.
5. Students will demonstrate ability to conduct a research or applied Computer
Science project, requiring writing and presentation skills which exemplify
scholarly style in computer science.
5
FLOW CHART
START
import mysql.connector as sql
conn=sql.connect(host='localhost',user='root',password='manager',database
='travel_booking')
c1=conn.cursor()
conn.autocommit==True
from time import gmtime, strftime
n=strftime("%a, %d %b %Y", gmtime())
n=str(n)
today=n[5:]
6
print(' ','________TRAVEL DAILY welcomes U!!!!!!__________')
print()
print(' ',n)
print()
print('Press 1 to Login')
choice=int (input('Enter your choice='))
if choice
==1:
7
a=int(input('Enter your phone number='))
#Name of the person
u=("select name from accounts where phone_number = "+str(a)+";")
c1.execute(u)
#Wrong phone number[account doesn't exist]
datan=c1.fetchall()
s=c1.rowcount
s=abs(s)
if s!==1:
print()
print("***********************ACCOUNT DOESN'T
EXIST************************")
8
print()
create=int(input("Press 32 to create account {{or}} Press 0 to exit="))
phone_number=int(input('Phone Number='))
name=str(input('Name='))
password =str(input( 'password[10]='))
c1.execute("insert into
accounts(Phone_number,password,name )values(" +
str(phone_number) +",'" +password + "',' "+name+" ')")
9
phone_number=int(input('Phone Number='))
name=str(input('Name='))
password =str(input( 'password[10]='))
c1.execute("insert into accounts(Phone_number,password,name )values(" + str(phone_number) +",'"
+password + "',' "+name+" ')")
conn.commit()
10
print('Account sucessfully Created')
import sys
if
choice==3:
import sys
sys.exit()
11
else:
print()
print()
print("*************
STOP
12
SOURCE CODE
DATABASE CREATION:
import mysql.connector as sql
conn=sql.connect(host='localhost',user='root',password='manage
r',database='travel_bookings')
c1=conn.cursor()
if conn.is_connected:
c1.execute("create database travel_booking")
print("database created successfully")
TABLE 1 CREATION:
import mysql.connector as sql
conn=sql.connect(host='localhost',user='root',password='manage
r',database='travel_bookings')
c1=conn.cursor()
c1.execute('create table accounts(Phone_number bigint(13)
primary key,name varchar(30),password bigint(10));')
conn.commit()
TABLE 2 CREATION:
import mysql.connector as sql
conn=sql.connect(host='localhost',user='root',password='manage
r',database='travel_bookings')
c1=conn.cursor()
c1.execute('create table customer_bookings(Phone_number
bigint(13) ,FOREIGN KEY(Phone_number) REFERENCES
13
accounts(Phone_number),Your_location
varchar(30),Your_destination varchar(30),time
varchar(30),Driver varchar(60),Urgency
varchar(30),date_booked varchar(90));')
conn.commit()
MAIN SOURCE CODE:
import mysql.connector as sql
conn=sql.connect(host='localhost',user='root',password='manage
r',database='travel_booking')
c1=conn.cursor()
conn.autocommit==True
from time import gmtime, strftime
n=strftime("%a, %d %b %Y", gmtime())
n=str(n)
today=n[5:]
print(' ','________TRAVEL DAILY welcomes
U!!!!!!__________')
print()
print(' ',n)
print()
print('Press 1 to Login')
print('Press 2 Create account')
print("press 3 delete account")
print('Press 4 to Exit')
print()
choice=int (input('Enter your choice='))
14
if choice ==1:
print()
a=int(input('Enter your phone number='))
#Name of the person
u=("select name from accounts where
phone_number = "+str(a)+";")
c1.execute(u)
#Wrong phone number[account doesn't exist]
datan=c1.fetchall()
s=c1.rowcount
s=abs(s)
if s!= 1:
print()
print("***********************ACCOUNT
DOESN'T EXIST************************")
print()
create=int(input("Press 32 to create
account {{or}} Press 0 to exit="))
if create==32:
phone_number=int(input('Phone
Number='))
name=str(input('Name='))
password =str(input( 'password[10]='))
c1.execute("insert into
accounts(Phone_number,password,name )values(" +
str(phone_number) +",'" +password + "',' "+name+" ')")
conn.commit()
print('Account sucessfully Created')
import sys
15
sys.exit()
else:
import sys
sys.exit()
datan=datan[0]
datan=list(datan)
datan= datan[0]
datan= str(datan)
#selecting password
y="select password from accounts where
phone_number =({})".format(a)
c1.execute(y)
data=c1.fetchall()
data=data[0]
data=list(data)
data=data[0]
b=int(input('Enter your password='))
if b!=data:
print()
print("***********************INVALID
PASSWORD**************************")
conn.commit()
16
if b==data:
print()
print("LOGGED IN !!!!!")
print()
print("HI",datan,"!!")
print()
print("What can I do for you?")
print()
print('12.Book for a board')
print('13.Bill verification')
print('14.My travel log')
print('0.Exit')
print()
choice1=int(input('Enter Your Choice='))
if choice1==0:
print()
print("Thank you , Visit again !!")
import sys
sys.exit()
if choice1==12:
your_location=input('Your_location=')
your_destination=input('Your_destination=')
time=input('time to start board=')
17
driver=input("driver gender
preferences=")
urgency=input('urgency(yes/no)=')
c1.execute("insert into
customer_bookings values(" + str(a) +",' " + your_location +
" ' ,' "+your_destination+ " ' ,' "+time+ " ' ,' "+driver+" '
,' "+urgency+" ',' "+today+" ' )")
conn.commit()
print()
print('********************************AT YOUR SERVICE
AT',time,"********************************")
import sys
sys.exit()
if choice1==13:
Dist=int(input('distance travelled
[km]='))
bill=Dist*5
print('your payment =Rs.',bill)
if choice1==14:
c1.execute("select
your_destination,date_booked from customer_bookings where
phone_number like '"+str(a)+"';")
data=c1.fetchall()
for row in data:
print(row[0],'- {',row[1],'}')
conn.commit()
import sys
sys.exit()
18
if choice!=14 and 12 and 13:
print()
print()
print("********************INVALID
CHOICE**********************")
import sys
sys.exit()
if choice==2:
phone_number=int(input('Phone Number='))
name=str(input('Name='))
password =str(input( 'password[10]='))
c1.execute("insert into
accounts(Phone_number,password,name )values(" +
str(phone_number) +",'" +password + "',' "+name+" ')")
conn.commit()
print('Account sucessfully Created')
import sys
sys.exit()
if choice==3:
phone_number=int(input("enter your phone_number="))
c1.execute("delete from customer_bookings where
phone_number ="+str(phone_number)+";")
c1.execute("delete from accounts where phone_number
="+str(phone_number)+";")
conn.commit()
print()
19
print("**************************************SUCCESSFULLY
ACCOUNT DELETED**************************************")
import sys
sys.exit()
if choice==4:
import sys
sys.exit()
if choice!=1 and 2 and 3:
print()
print()
print("********************INVALID
CHOICE**********************")
20
OUTPUT
1.
2.
21
3.
4.
22
HARDWARE AND SOFTWARE REQUIREMENTS
I.OPERATING SYSTEM : WINDOWS 7 AND ABOVE
II. PROCESSOR : PENTIUM(ANY) OR AMD
ATHALON(3800+- 4200+ DUAL CORE)
III. MOTHERBOARD : 1.845 OR 915,995 FOR PENTIUM 0R MSI
K9MM-V VIA K8M800+8237R PLUS
CHIPSET FOR AMD ATHALON
IV. RAM : 512MB+
V. Hard disk : SATA 40 GB OR ABOVE
VI. CD/DVD r/w multi drive combo: (If back up required)
VII. FLOPPY DRIVE 1.44 MB : (If Backup required)
VIII. MONITOR 14.1 or 15 -17 inch
IX. Key board and mouse
X. Printer : (if print is required – [Hard copy])
SOFTWARE REQUIREMENTS:
I. Windows OS
II. Python.
INSTALATION PROCEDURE
DAILY TRAVEL BOOKING :-
Pre-Requisites :-
23
1. You have to have the following softwares for the successful running of this
software; which are
I) Python (Only for the First time), it is downloadable from
'www.python.org'.
II) MySQL (Only for the First time), it is downloadable from
'www.mysql.org'.
Installation :-
1. There will be two folders namely 'Python Files' and 'EXE files'.
2. The folder 'Python Files' will contain the source code of the software in python
language. If you are running the software by the 3rd step mentioned below you have
to pre install the following modules :-
I) mysql.connector
II) matplotlib.
3. Open the files in any python editors and run it to start and work on the
software.
4. The folder 'EXE files' will contain two files namely 'main.exe' and
'Tables_in_mysql.exe'.
24
5. First run the 'Tables_in_mysql.exe' to create the tables in MySQL.
1. Then run the file 'main.exe' to start and work on the software.
CAUTION :-
If you are running the software through running the python files or by running
the .exe files ; first run the file named 'Tables_in_mysql'.
The .exe file will take a lot of time; so be PATIENT.
BIBLIOGRAPHY
1. Computer science With Python - Class XII
2. A Project Report On DAILY TRAVEL BOOKING
25
3. By : Dipankar Sonawane
4. Website: https://www.w3resource.com
***
26
