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 |
Hi Chitra,
I like this project and I hope you don’t mind shearing.
Please send code as an attachemt to my email.
thanks for sharing.
Please send me the full project report and Code of project.
Hi,
This is dilip kasana.
I have the source of this project.
mail me at dilipgurjarkasana@gmail.com.
with the subject “Code of M-TICKET-MOBILE-BOOKING”.
source is in JAVA.
hi
pls send me your poject
hi chitra,
can u please me ur project “Code of M-TICKET-MOBILE-BOOKING”.
i wana try it.
my email is- sahil4404@gmail.com
i very much interested to get more details about this M ticket booking .
ourself is event marketting firm from oman. our requirement is to book tickets and purchace through mobile sms sytem and send soft copy of tickets to their moble .After this at the entrance they can show their tickets on their moble itself and can entry to the location and also they can reserve seat also .
hai pa
pls mail me ur project code.
vijiv2008@gmail.com
hi,
I would like to try the project.
Pls mail me the project code.
Thanks
can you please mail me the code
I am an M.Cs student…
I am trying to do this project but for the local train ticket
so can you give me the source code of the project.
plz really it is very helpful to me…
Thanks
can you please mail me the source code?
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
please.can i get the code for this program? I’m doing a similar project. thanks
dilipgurjarkasana@gmail.com : Hey If you want code for this I have.Mail me and I will send.
I have.
I have. mail me your mail id
code at : plaese commit,modify,update or report issue if found
https://github.com/dilipkasana/movie-booking-sms/
at above git repository.
can i have code for m booking in vb.net.?