Online movie tickets

ONLINE MOVIE TICKET BOOKING
GUIDED BY :-
Prof.Mahendra Yadav
SUBMITTED BY :-
JAI BAMORIYA
RISHABH AGRAWAL
SANDHYA SIKARWAR
PRESTIGE INSTITUTE OF
MANAGEMENT
GWALIOR

Contents
✓ Introduction
✓ Problem Statement
✓ Objective
✓ ER-Diagram

Introduction
➢This project is aimed to provide the customers facility to book tickets
for cinema halls online.
➢Online Ticket system is basically made for providing the customers
at any time and anywhere service for booking the seat in the cinema
hall and to gather information about the movies.
➢The user can easily to able to know the movies released and them
make the choice according their language, director, fare.

In this given project, we describes 8 tables where 2 tables (BOOK and
CONDUCT are of relationship) are following –
I. CUSTOMER
II. MOVIE
III. SHOW
IV. SEATS
V. BOOK
VI. CONDUCT
VII. PAYMENT
VIII.RATE

Customer Table –
1. c_id (Primary Key)
2. c_name
3. phn_no
Movie Table –
1. m_id (Primary Key)
2. m_name
3. type
4. language
5. duration
6. fare
7. director

Seats Table –
1. r_id
2. row
3. column
4. rate_id (foreign key)
Show Table –
1. show_id
2. time
3. screen

Payment Table –
1. p_id
2. p_date
3. amount
4. p_type
Rate Table–
1. rate_id
2. type
3. rate

Book Table –
1. b_id
2. c_id (foreign key)
3. s_id (foreign key)
4. p_id (foreign key)
5. con_id (foreign key)
Conduct Table –
1. con_id
2. m_id (foreign key)
3. show_id (foreign key)

Problem Statement
➢ The online interface created has to solve the difficulties faced by both the
customers and the staff of the cinema halls.
➢ The customer user interface should be intuitive , such that all the users are
able to book seats for any show without any assistance .
➢ The online portal must be capable of implementing serializability so that
many user can book a seat simultaneously.

Objective
➢ The main purpose of our online ticket booking system is to provide another
way for the customer to book movies.
➢This system is basically provide information of the customer, movie, seats,
rate, screen, shows to the customer.
➢The goals of our system are:
a) To provide service for the customer to book seats anytime anyplace.
b) To minimize the number of staff at the ticket box.
c) To promote the file film on the internet.
d) To increase the profit.
e) To obtain statistic information from the booking record.

ER-Diagram
CUSTOMER
C_idC_name
Phn_no
PAYMENT
P_idp_date
p_type
amount
RATE
Rate_idtype
rate
has
s_id
column
row
BOOK
SHOW
Show_id time
screen
CONDUCT
MOVIES
m_name
director
m_id
fare
lang
type
duaration
B_id
Con_id
SEATS

Online movie tickets

Recommended

Recommended

More Related Content

What's hot

What's hot (20)

Similar to Online movie tickets

Similar to Online movie tickets (20)

More from JAI BAMORIYA

More from JAI BAMORIYA (6)

Recently uploaded

Recently uploaded (20)

Online movie tickets