M-TICKET – Mobile Booking

Chapter 4

SYSTEM DESIGN

4.1 System Design:

4.1.1 Database Design

Table No 1: cust

Field Name Data Type Description
Cname Varchar Name of the customer
mobile_no Varchar Mobile number of the customer
credit_no Varchar Credit card number of the customer

Table No 2: admin

Field Name Data Type Description
username Varchar Username of the administrator
password Varchar Password of the administrator
Fname Varchar First name of the administrator
Lname Varchar Last name of the administrator
Gender Int Gender of the administrator
Dob Datetime Date of birth of the administrator
Address Varchar Address of the administrator
Pin_code Varchar Pin code
email_id Varchar Email id of the administrator
mobile_no Varchar Mobile number of the administrator
credit_no Varchar Credit card number of the administrator
question Char Security question
Answer Varchar Answer for the security question

Table No 3: theatre

Field Name Data Type Description
tname Varchar Theatre name
owner Varchar Owner of the theatre
location Varchar Location of the theatre
ph_code Varchar Phone code
Ph_number Bigint Phone number

Table No 4: screen

Field Name Data Type Description
screen_id Int Identifier of the screen
screen_name Varchar Name of the screen
No_of_classes Int No of classes in the screen
no_of_shows Int No of shows in the screen

Table No 5: class_info

Field Name Data Type Description
screen_id Int Identifier of the screen
class_id Int Identifier of the class
class_name Varchar Name of the class
No_of_rows Int No of rows in a class of a screen

Table No 6: seat_ numbers

Field Name Data Type Description
screen_id Int Identifier of the screen
class_id Int Identifierof the class
row_name Varchar Row name
seat_no Int Seat number

Table No 7: movie

Field Name Data Type Description
movie_code Int Code of the movie
movie_name Varchar Name of the movie

Table No 8: movie_info

Field Name Data Type Description
Date_of_show Datetime Date of show of the movie
screen_id Int Identifier of the screen
show_code Int Code for show time of the movie
movie_code Int Code of the movie

Table No 9: cost

Field Name Data Type Description
screen_id Int Identifier of the screen
class_id Int Identifier of the class
Price Real Price

Table No 10: reservation

Field Name Data Type Description
resv_date Datetime Reservation date
resv_no Bigint Reservation number
Cname Varchar Customer name
mobile_no Varchar Mobile number of the customer
movie_code Int Code of the movie
Date_of_show Datetime Show date of movie
screen_id Int Identifier of the screen
show_code Int Code for show time of the movie
class_id Int Identifier of the class
row_name Varchar Row name
seat_no Int Seat number
pay_mode Int Pay mode
Price Real Price
Paid Int This field indicates whether payment is done or not

Table No 11: seat_details

Field Name Data Type Description
date_of_show Datetime Show date of the movie
screen_id Int Identifier of the screen
show_code Int Code for show time of the movie
movie_code Int Code of the movie
class_id Int Identifier of the class
row_name Int rowname
seat_no Int Seat number
Booked Int It indicates whether a seat is reserved or not
resv_no Bigint Reservation number
resv_date Datetime Reservation date

Table No 12: seat_reserved

Field Name Data Type Description
resv_date Datetime Reservation date
resv_no Bigint Reservation number
No_of_seats Int Number of seats reserved

Table No 13: time_info

Field Name Data Type Description
screen_id Int Identifier of the screen
show_code Int Code for show time of the movie
show_time Datetime Time of the show

28 Responses to “M-TICKET – Mobile Booking”

  1. ROTIMI

    INTERESTING, I’VE BEEN CONTEMPLATING A PROJECT IN SAME DOMAIN AS WELL AS FOR TAXI BOOKING. IS IT POSSIBLE FOR US TO RUN A PILOT/ EVALUATION OF YOUR PROJECT IN OUR TERRITORY? I’D LOVE TO COLLABORATE, KINDLY SEND ME MORE DETAILS BY EMAIL

    Reply
  2. Elizabeth

    please.can i get the code for this program? I’m doing a similar project. thanks

    Reply
  3. Dilip Singh Kasana

    [email protected] : Hey If you want code for this I have.Mail me and I will send.

    Reply

Leave a Reply