Movie Ticketing System Database Design
Movie Ticketing System Database Design is basically aimed to provide complete information of the movie and schedule to the customer, according to which he/she can easily get a ticket instantly and can book a ticket on his/her favorite movies. Admin can use Movie Ticketing System to insert and delete data such as movie descriptions, movie schedules which will update the related webpage and will be accessible by the customers. Admin can update the webpage changing according to the data in the database also admin can check the statistics information from the system. Operate your cinema with better efficiency by automating reservation and ticketing process improve profitability and manage your cinema better by having access to key data in a centralized and systematic view and increase customer satisfaction by giving your customers what they want when it comes to the seat preference.
Based on seat and ticket reservation system allowing booking in a few easy steps. This powerful movie ticketing system can be deployed on any website offering tickets for movies, theater, and other scheduled performances.
Movie Ticketing System Database Design Features:
List of Upcoming Movies
. Description About the Movie
. List of cinema hall city
. Ticket availability
. The Payment gateway for transaction
Entity Relationship Diagram of Movie Ticketing System
Data Dictionaries for Ticketing System Database Design
Table 1: tblCustomer
| Field Name | Description | Type | Length |
| customer_id (PK) | Customer ID number | Int | 11 |
| customer_name | Customer Full Name | varchar | 30 |
| customer_mobile | Customer Mobile Number | varchar | 11 |
| customer_email | Customer Email Address | varchar | 30 |
| customer_address | Customer Address | Text |
Table 2: tblCashier
| Field Name | Description | Type | Length |
| employee_id (PK) | Employee ID number | Int | 11 |
| emloyee_name | Employee Full Name | varchar | 30 |
| employee_address | Employee Address | Text | |
| employee_salary | Employee Salary | varchar | 50 |
Table 3: tblMovieShow
| Field Name | Description | Type | Length |
| movie_id (PK) | Movie ID number | Int | 11 |
| movie_name | Movie Name or the Title of the movie | varchar | 50 |
| movie_language | Movie in Different Languages | varchar | 50 |
| movie_hour | Movie Duration Time | varchar | 50 |
| movie_type | The type of the Movie | varchar | 50 |
| movie_date | Date of the movie released | varchar | 50 |
Table 4: tblBookingTicket
| Field Name | Description | Type | Length |
| No_Of_Tickets_Available | Number of Tickets Available | Int | 11 |
| Movie_Name | Movie Name or the Title of the movie | varchar | 50 |
| Ticket_Number | The Number of the Ticket | Int | 11 |
| Date | The Date when you book the Ticket | varchar | 50 |
| Time | The Time when you Book the Ticket | varchar | 50 |
| Venue | The Place where you want to watch | varchar | 50 |
| Ticket_ID (PK) | Ticket ID Number | Int | 11 |
Table 5: tblPayment
| Description | Type | Length | |
| ID (PK) | Payment ID number | Int | 11 |
| amount | Cash Amount | Int | 50 |
| customer | Movie in Different Languages | varchar | 50 |
| date | Movie Duration Time | varchar | 50 |
| Time | The type of the Movie | varchar | 50 |
Conclusion
This Ticketing System Database Design is a requirement in the DBMS mini Project. if you want to develop your own Ticketing System Database Design, you can upgrade this database design to suit your requirements.