Movie Ticketing System Database Design

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

Ticketing System Database Design
Movie Ticketing System Database Design

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.

Related Articles you may Like

Leave a Comment