COMPUTER SCIENCE PROJECT

FILE
PROJECT REPORT
ON
MOVIE TICKET RESERVATION SYSTEM
COMPUTER SCIENCE
FOR
CLASS XII
(2023-24)
Submitted in partial fulfillment of the requirement of CBSE, Delhi

VIKASH.V
UNDER THE GUIDANCE OF
Mrs. D. SAKTHI PRIYA M.C.A., M.E., B.Ed.,
(P.G.T Computer Science)

Mahatma Global Gateway (CBSE)

Gopalakrishnan Guruvasal,
Veerapanchan, Madurai-625 020.
 ACKNOWLEDGEMENT

At the outset I would like to take the opportunity of expressing my

sincere thanks to the Almighty for keeping me in good health all through
this gruelling project work.

I would like to express my special thanks to my worthy Academic

Director Mrs.P.Hamsa Priya, Principal Mrs. Meena Karuppiah and to
my teacher guide Mrs. D. Sakthi Priya who provided motivation and
valuable guidance to complete this project.

I got ample opportunity to do research which enriched my

knowledge and widen my thoughts in this arena. I am indebted to
them.

I would also like to thank my parents and friends who always inspired
and helped me to complete this project.

Signature of the student

 CERTIFICATE

This is to certify that VIKASH.Vof class XII of Mahatma

Global Gateway (CBSE), Madurai, has completed his project file
as a part of the paper of computer science under my supervision.
He has taken proper care and shown utmost sincerity in the
completion of this project.

I certify that this project is up to my expectation and as per

the guidelines issued by CBSE.

Signature of the Principal Signature of the Teacher In-charge

(Mrs.Meena Karuppiah) (Mrs.D.SakthiPriya)

Submitted for the viva-voce examination held on , at

Mahatma Global Gateway (CBSE), Madurai.

Signature of the Examiner

 INDEX

TOPIC

1 System Requirements
2 Feasibility Study
3 Errors and its Types
4 Testing
5 Maintenance
6 Abstract
7 Modules used
8 Flow Chart
9 Source code
10 Output
11 Database Details
12 Bibliography
 SYSTEM

REQUIREMENTS

1. HARDWARE:
✓ Keyboard
✓ Minimum memory -2GB
✓ Processor

2. SOFTWARE:
✓ Operating System –OS7,OS8
✓ Python IDLE
✓ MYSQL
 FEASIBILITYSTUDY
Feasibility study is a system proposal according to its work,
ability, impact on the operation ability to meet the needs of users
and efficient use of resources. An important outcome of
preliminary investigations the determination of that system
requested feasible.

ECONOMICAL FEASIBILITY:
Economics analysis is the most frequent use method for
evaluating the effectiveness of the candidates the benefits and
savings that are expected from system and compare them with
cost. This software is not very costly. It just worth Rs.5500/-.So
users records can be maintained at a cheaper cost and every
school would like to use this software so that the student’s
records can be managed easily.

TECHNICAL FEASIBILTY:
Technical feasibility center on the existing computer system and
to what extent it can support the proposed task. This involves
financial consideration to accommodate technical
enhancements. It is technically feasible because whatever
technology is needed to develop this software is easily
available.
 ERRORS ANDITSTYPES

An error, sometime called “A BUG” is anything in the code that

prevents a program from compiling and running correctly. There
are broadly three types of errors as follows:
1. Compile- time errors: Errors that occurs during
compilation of a program is called compile time error. It has
two types as follows:
a. Syntax error: It refers to formal rules governing the
construction of valid statements in a language.
b. Semantics error: It refers to the set of rules which give the
meaning of a statement.
2. Run time Errors: Errors that occur during the execution of
program are run time errors. These are harder to detect errors.
Some run-time error stop the execution of program which is
then called program “Crashed”.
3. Logical Errors: Sometimes, even if you don’t encounter any
error during compiling-time and runtime, your program does
not provide the correct result. This is because of the
programmer’s mistaken analysis of the problem he or she is
trying to solve. Such errors are called logical error.
 TESTING

1. Alpha Testing: It is the most common type of testing used

in the software industry. The objective of this testing is to
identify all possible issues or defects before releasing it into the
market or to the user. It is conducted at the developer’s site.
2. Beta Testing: It is a formal type of software testing which is
carried out by the customers. It is performed in a real
environment before releasing the products into the market for
the actual end-users. It is carried out to ensure that there are no
major failures in the software or product and it satisfies the
business requirement. Beta Testing is successful when the
customer accepts the software.
3. White Box Testing: White box testing is based on the
knowledge about the internal logic of an application’s code. It is
also known as Glass box Testing. Internal Software and code
working should be known for performing this type of testing.
These tests are based on the coverage of the code statements,
branches, paths, conditions etc.
4. Black Box Testing: It is a software testing, method in which
the internal structure or design of the item to be tested is not
known to the tester. This method of testing can be applied
virtually to every level of the software testing.
 MAINTENANCE

Programming maintenance refers to the modifications in the

program. After it has been completed, in order to meet
changing requirement or to take care of the errors that shown
up. There are four types of maintenance:
1. Corrective Maintenance: When the program after
compilations hows error because of some unexpected situations,
untested areas such errors are fixed up by Corrective
maintenance.
2. Adaptive Maintenance: Changes in the environment in
which an information system operates may lead to system
management. To accommodate changing needs time to time
maintenance is done and is called Adaptive maintenance.
3. Preventive Maintenance: If possible the errors could be
anticipated before they actually occur; the maintenance is
called Preventive maintenance.
4. Perfective Maintenance: In this rapidly changing world,
information technology is the fastest growing area. If the
existing system is maintained to keep tuned with the new
features, new facilities, new capabilities, it is said to be
Perfective maintenance.
 ABSTRACT

The aim of this project is to create a platform for people to book

movie tickets in an easy and better way through python
integrated MySQL connectivity program.

Some of the features of this program are:

1. Customers can give short and brief customer details for

booking tickets.
2. The firm can get instant details about the customers in their
database.
3. Customers can go through the show details and choose the
screen gateway they want. Popflix Cinema has Gold 4dx,
IMAX and Silver screen booking.
4. Each of them has peculiar details with different prices;
customers can choose anyone of them.
5. Then the customer can finally reserve the tickets they want
and get a total for their purchase.
6. Only the payment mode is specified in the booking process,
customer has to pay for their tickets at the booking center
directly.
 MODULES USED

Random module

The random module is a built-in module to generate the

pseudo-random variables. It can be used perform some action
randomly such as to get a random number, selecting a random
elements from a list, shuffle elements randomly, etc.

Sql.connector

MySQL is a Relational Database Management System

(RDBMS) whereas the structured Query Language (SQL) is
the language used for handling the RDBMS using commands
i.e. Creating, Inserting, Updating and Deleting the data from
the databases. SQL commands are case insensitive i.e.
CREATE and create signify the same command.
 FLOWCHART

Start

Show
details

Yes No

Customer’s details Exit

gateway
 Insertion (Insertion of
customer details)

One time customer ID

Screen and seat

booking

Insertion (insertion of
booking details)

Exit
 SOURCECODE

importmysql.connector
import random
db=input("Enter name of the database: ")

mydb=mysql.connector.connect(host='localhost',user='root',passwor
d='abisql')
ifmydb.is_connected():
print("Connection Succesful..")
mycursor=mydb.cursor()

sql="Create Database if not exists %s"%(db,)

mycursor.execute(sql)
print("Database created successfully")

mycursor=mydb.cursor()
mycursor.execute("Use "+db)
TableName=input("Name of Table to be created:")
TableName1=input("Name of Table to be created:")
TableName2=input("Name of Table to be created:")
TableName3=input("Name of Table to be created:")

query1="Create table if not exists "+TableName+"\

(Name varchar(50),\
Phone bigint,\
No_Tickets integer,\
Sex varchar(10),\
First_Namevarchar(50),\
Last_Namevarchar(50),\
Email_IDvarchar(100),\
Mode_paymentvarchar(50))"
mycursor.execute(query1)

query2="Create table if not exists "+TableName1+"\

(Customer_IDvarchar(50),\
movie_namevarchar(50),\
Amount int)"
mycursor.execute(query2)

query3="Create table if not exists "+TableName2+"\

(Customer_IDvarchar(50),\
movie_namevarchar(50),\
Amount int)"
mycursor.execute(query3)

query4="Create table if not exists "+TableName3+"\

(Customer_IDvarchar(50),\
movie_namevarchar(50),\
Amount int)"
mycursor.execute(query4)

ifmydb.is_connected():

print ("Enter your choice as 1,2,3&4")

print
("$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$ POPFLIX THEATRE BOOKING
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$4$$$$$$$$$$$
$$$")

print (" YOUR SAFETY IS

OUR PRIORITY ")
print (" Use of masks
")

print (" Sanitization after each

show ")

print (" Social distancing in

cinema halls ")

print (" Mandatory temperature

checks ")

print ("POPFLIX THEATRE")

ch = input ("do you want to check the show details(yes/no) :")

ifch == 'yes' or ch=='YES':

print("*"*150)

print(" SHOW DETAILS ")

print("*"*150)
print("Select Shows (a.Morning Show /b.Noon Show/c. Night
Show")

sh=input("Enter your choice: ")

ifsh=='a':
print("Time: 9:00 A.M")
print("*"*30," Movies","*"*30)
print("Screen 1. Ava")
print("Screen 2. AquaMan")

ifsh=='b':
print("Time: 1:00 P.M")
print("*"*30," Movies","*"*30)
print("Screen 1. After")
print("Screen 2. Lucy")

ifsh=='c':
print("Time: 10:00 P.M")
print("*"*30," Movies","*"*30)
print("Screen 1. Ava")
print("Screen 2. Baywatch")

print("**********************************************CUS
TOMER DETAILS
GATEWAY*********************************************
*************")

v_mname = input("Enter the movie name :")

v_phone = input("Enter your Phone number :")

v_tic = input("Enter total tickets :" )

v_sex = input ("Enter your sex :" )

v_fname = input ("Enter your first name :")

v_lname = input ("Enter your last name :")

v_Email_ID = input ("Enter your Email ID :")

v_mpayment=input("Enter mode of payment(Debit or Credit

card/UPI/Net Banking): ")

print("Type OK to Generate your one time Customer ID")

m=input("Enter OK: ")

if m=='OK'or m=='ok':
choices = list(range(1000))
random.shuffle(choices)
print("Your Member_ID is",choices.pop())
v_ins="insert into theatre values(
'{}',{},{},'{}','{}','{}','{}','{}')".format(v_mname,v_phone,v_tic,v_se
x,v_fname,vv_lname,v_Email_ID,v_mpayment)
mycursor.execute(v_ins)
mydb.commit()

print (" SCREEN AND SEAT BOOKING

GATEWAY ")
print("1.GOLD [4dx] Ticket Booking")
print(" Price per Ticket: Rs.1500 ")
print("2.IMAX Ticket Booking")
print(" Price per Ticket: Rs.850 ")
print("3.Silver Ticket Booking")
print(" Price per Ticket: Rs.500 ")
ch=int(input("Enter your choice :"))

ifch ==1:
print
("******************************************************
*WELCOME TO GOLD 4DX CINEMA
BOOKING**********************************************
*****************")
a = input("Enter your one time Customer ID: ")
c = input ("Enter your movie name :")
d = int(input("Enter the number of tickets: "))
total=d*1500
print("Bill for the tickets:",total)
pswd= input("Your payment OTP :")
sks = input("your complimetary snacks(chips/popcorn/no):")
dd=input("your complementary drink(coke/pepsi/no): ")
v_dx="insert into 4dx values( '{}','{}',{})".format(a,c,total)

mycursor.execute(v_dx)
mydb.commit()
print ("*********************TICKET
BOOKED***********************")

print ("/////////////////////////////////////////////////ENJOY THE MOVIE

AND HAVE FUN////////////////////////////////////////////////////////")

ifch ==2:
print
("******************************************************
*WELCOME TO IMAX TICKET BOOKING
*******************************************************
***************")

aa = input("Enter your one time Customer ID: ")

cc = input ("Enter your movie name :")
dd = int(input ("Enter number of tickets :"))
ttotal=dd*850
print("Bill for the tickets:",ttotal)
pswd= input("Your payment OTP :")
sks = input("your complimetary snacks(chips/popcorn/no):")
dd=input("your complementary drink(coke/pepsi/no): ")
v_dy="insert into imaxvalues( '{}','{}',{})".format(aa,cc,ttotal)
mycursor.execute(v_dy)
mydb.commit()
print ("*********************TICKET
BOOKED**************************")
print ("///////////////ENJOY THE MOVIE AND HAVE
FUN/////////////////")

ifch == 3:
print
("******************************************************
*****WELCOME TO SILVER TICKET
BOOKING**********************************************
******************")
aaa = input("Enter your one time Customer ID: ")
ccc = input ("Enter your movie name :")
ddd = int(input("Enter number of Tickets: "))
tttotal=ddd*500
print("Bill for the tickets:",tttotal)
pswd= input("Your payment OTP :")
v_dz="insert into silver values( '{}','{}',{})".format(aaa,ccc,tttotal)
mycursor.execute(v_dz)
mydb.commit()
print ("*********************TICKET
BOOKED**************************")
print ("//////////////////////////////////////////////ENJOY THE MOVIE
AND HAVE FUN///////////////////////////////////////////////////////////")
else:
print("Thanks for visiting")
 OUTPUT

1. Tablecreation

2. Show Details

3. Customer Details Gateway

4. One time CustomerID

5. Screen and Seat Booking Gateway

6.Enter into Ticket booking
 DATA BASE DETAILS

1. Showtables

2. DescribeTables
3. Select all details fromtables
 BIBLIOGRAPHY

Textbooks:
Computer Science with python by SumitaArora
Computer Science with python by PreetiArora

Websites:
https://en.wikipedia.org/
http://python.mykvs.in/