VELAMMAL VIDHYASHRAM SURAPET
COMPUTER SCIENCE
Topic: BUS RESERVATION MANAGEMENT
SYSTEM
Academic year: 2021-2022
Done By:
[Link] KUMAR
XII – A2
BONAFIDE CERTIFICATE
This is to certify that this COMPUTER SCIENCE Project on the topic
"BUS RESERVATION MANAGEMENT SYSTEM”has been successfully completed by CM.
YOGESH KUMARof class XII A2, [Link]…………………... at Velammal Vidhyashram, Surapet, for
the partial fulfilment of this project as a part of All India Senior School Certificate Examination-CBSE,
New Delhi for the academic Year 2021- 2022.
Date: …………………….
Signature of Principal Teacher in charge
Signature of the Signature of the
Internal Examiner External Examiner
2
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 express my deep sense of gratitude to the luminary The Principal, Mrs.
ChitraMadhavanBharathi Wing Velammal vidhyashram surapet who has been continuously motivating
and extending their helping hand to us.
I express my sincere thanks to the CEO. Mr. Velmurugan Velammal vidhyashram surapet, for
providing this opportunity in doing these project
My sincere thanks to Mrs. Kavitha.K, Master In-charge, A guide, Mentor all the above a friend,
who critically reviewed my project and helped in solving each and every problem, occurred during
implementation of the project
The guidance and support received from all the members who contributed and who are contributing
to this project, was vital for the success of the project. I am grateful for their constant support and help.
3
TABLE OF CONTENT:
SNO. CONTENTS PAGE
NO.
1. ABSTRACT
2. SYSTEM CONFIGURATION
3. INTRODUCTION
4.
OBJECTIVES OF THE PROJECT
5. PROPOSED SYSTEM
6. LIBRARIES AND FUNCTIONS USED
7. MYSQL QUERIES USED IN THIS
PROJECT
8. SOURCE CODE
9. OUTPUT(SCREENSHOT)
10 CONCLUSION
.
11 BIBILOGRAPHY
.
4
ABSTRACT:
Bus Reservation Management project is developed using Python and MySQL database. This application
provides an easy way for the employers at a Bus reservation office to make their work convenient. In this
5
project users can perform various activities like creating a new entry, deleting an entry and altering the
information in an entry.
SYSTEM CONFIGURATION:
HARDWARE CONFIGURATION
Microsoft windows 7 professional/windows 8/windows 8.2:
• Processor : Intel Core i3 or equivalent
• Memory : 2 GB (32-bit), 4 GB (64-bit)
• Disk space :1.5 GB of free disk space
SOFTWARE REQUIREMENTS
• 1 GB RAM (2 GB+ recommended)
• 9-58 GB free hard disk space depending on edition and configuration, including space required for
temporary files
• DVD-ROM drive (if installing from a Media Kit DVD)
• Basic GPU – Any vendor DirectX 9.0 class or better (Pixel Shader Level 2)
• Intel® Pentium® or compatible, 1.6 GHz minimum (2GHz+ recommended)
• 1024x768 or higher-resolution monitor
• MOUSE OR OTHER POINTING DEVICE
INTRODUCTION
" BUS RESERVATION MANAGEMENT SYSTEM"This application provides an easy way for
the employers at a Bus reservation office to make their work convenient. The emerging of digital system
6
made information available on finger tips. This project emphases on adding of new customer entry, deleting
an entry of a customer, altering the information in a customer entry.
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 research or applied Computer Science project, requiring
writing and presentation skills which exemplify scholarly style in computer science.
PROPOSED SYSTEM
Today one cannot afford to rely on the fallible human beings of be really wants to stand against
today’s merciless competition where not to wise saying “to err is human” no longer valid, it’s outdated to
rationalize your mistake. So, to keep pace with time, to bring about the best result without malfunctioning
and greater efficiency so to replace the unending heaps of flies with a much sophisticated hard disk of the
computer.
One has to use the data management software. Software has been an ascent in atomization various
organisations. Many software products working are now in markets, which have helped in making the
organizations work easier and efficiently. Data management initially had to maintain a lot of ledgers and a
lot of paperwork has to be done but now software product on this organization has made their work
faster and easier. Now only this software has to be loaded on the computer and work can be done. This
prevents a lot of time and money. The work becomes fully automated and any information regarding the
7
organization can be obtained by clicking the button. Moreover, now it’s an age of computers of and
automating such an organization gives the better look.
LIBRARIES AND FUNCTIONS USED:
1. MySQL connector- MySQL Connector/Python enables Python programs to access MySQL
databases, using an API that is compliant with the Python Database API Specification v2.0 (PEP 249).
It is written in pure Python and does not have any dependencies except for the Python Standard
Library.
FUNCTIONS USED: WRITE IN DETAIL ABOUT PURPOSE OF THE FUNCTION.
1 connect ()-The connect () function initiates a 3-way handshake with the server socket and establishes the
connection between MySQL and python
2 print ()-The print () function prints the specified message to the screen, or other standard output device.
The message can be a string, or any other object, the object will be converted into a string before written
to the screen.
3 commit ()- The COMMIT command is the transactional command used to save changes invoked by a
transaction to the database.
4 ADDINFO ()- It is a user defined function to add a new entry into the table bus.
5 DELETEINFO ()- It is a user defined function to delete a particular entry from the table bus.
6 MODIFYINFO ()- It is a user defined function to modify a particular entry from the table
SOURCE CODE:
def ADDINFO():
import [Link]
8
db=[Link](host="localhost",user="TOD
THUNDER",passwd="dhonivirat07",database="cs")
mycursor=[Link]()
a=int(input("enter serial no:"))
b=input("ENTER DATE:")
c=input("ENTER PICKUP POINT:")
d=input("ENTER DESTINATION POINT:")
e=input("ENTER NAME:")
f=eval(input("ENTER MOBILE NUMBER:"))
[Link]("insert into bus values(%s,'%s','%s','%s','%s',%s)"%(a,b,c,d,e,f))
[Link]()
[Link]("select * from bus")
#for x in mycursor:
#print(x)
def DELETEINFO():
import [Link]
db=[Link](host="localhost",user="TOD
THUNDER",passwd="dhonivirat07",database="cs")
delete=[Link]()
j=eval(input("ENTER THE PERSONS MOBILE NUMBER FOR DELETING THEIR
INFORMATION:"))
[Link]("delete from bus where mobileno={}".format(j))
[Link]()
[Link]("select * from bus")
9
#for i in delete:
#print(i)
def MODIFYINFO():
import [Link]
db=[Link](host="localhost",user="TOD
THUNDER",passwd="dhonivirat07",database="cs")
alter=[Link]()
x=int(input("WHAT DO YOU WANT TO ALTER\n if datepress1\nif pickup press2\nif destination
press3\n:"))
if x==1:
p=input("ENTER THE PERSON NAME YOU WANT TO ALTER:")
u=input("ENTER NEW DATE:")
[Link]("update bus set date=(%s) where name=(%s)",(u,p))
[Link]()
[Link]("select * from bus")
#for t in alter:
#print(t)
elif x==2:
r=input("ENTER THE PERSON NAME YOU WANT TO ALTER:")
c=input("ENTER NEW PICKUP POINT:")
[Link]("update bus set pickup=(%s) where name=(%s)"%(c,r))
[Link]()
[Link]("select * from bus")
#for s in alter:
10
#print(s)
elif x==3:
n=input("ENTER THE PERSON NAME YOU WANT TO ALTER:")
z=input("ENTER NEW DESTINATION:")
[Link]("update bus set destination=(%s) where name=(%s)",(z,n))
[Link]()
[Link]("select * from bus")
#for q in alter:
#print(q)
p='y'
while p=='y':
print("WELCOME TO BUS RESERVATION ADMINISTRATION TABLE:")
x=int(input("\nPRESS 1 TO ADD NEWPERSONS DETAILS\nPRESS 2 TO DELETE A PERSON
DETAILS\nPRESS 3 TO MODIFY A PERSONS DETAILS\n:"))
#main program
if x==1:
ADDINFO()
elif x==2:
DELETEINFO()
elif x==3:
MODIFYINFO()
p=input("DO YOU WANT TO REPEATE THE PROCESS IF YES PRESS'y' OR NO PRESS'n':")
11
import [Link]
db=[Link](host="localhost",user="TOD
THUNDER",passwd="dhonivirat07",database="cs")
main=[Link]()
[Link]("select * from bus")
for q in main:
print(q)
OUTPUT:
12
PYTHON OUTPUT:
MYSQL OUTPUT:
13
CONCLUSION:
Bus reservation management system is an environment where all the process of the customers entry details
is managed in bus reservation office. It is done through the automated computerized method.
This system saves the time of the employers. It includes process like newentry added, deleting a customer
detail, altering a customer detail.
If filed a query to search or update in a manual system, it will take a lot of time to process the query and
make a report which is a tedious job.
This computerized system stores all the data in the database which makes it easy to fetch and update
whenever needed.
14
BIBILOGRAPHY:
Computer Science With Python by Sumita Arora for Class 11& 12
HTTPS://[Link]/PYTHON/PYTHON_MYSQL_GETSTARTED.ASP
HTTPS://[Link]/PYTHON/PYTHON_DATABASE_ACCESS.
HTMHTTPS://[Link]/MYSQL-WITH-PYTHON/
15
