The ER (Entity Relationship) Diagram of online movie ticket booking system is an ER model of movie ticket booking system entity. The primary purpose of ERD diagram is to represent data objects and their relationships.
The entity relationship diagram of online movie ticket booking system graphically represents database tables and relations between movie, customer, cinema, screen etc. The main entity of the online movie ticket booking system is Movie booking website, Customer, Movie, Booking, Movie Show, Cinema, Screen etc. Let’s see what are the entities of movie ER diagram.
Checkout: ER Diagram for Library Management System Checkout: DFD for Online Movie Ticket Booking System
Online Movie Ticket Booking System ER diagram Entities and their Attributes
Each of the entities have their respective attributes. Attributes of all movie ER diagram entities are as follows:
- Movie Ticket Booking Website:– Attributes are website_name, website_url, contact_no.
- Customer:– Attributes of customer are customer_id, customer_name, customer_address,customer_contact.
- Movie:– Attributes of movie are movie_title, movie_description, Movie_stars.
- Movie Show:– Attributes are show_date, movie, show_time, cinema_name.
- Cinema:- Attributes of cinema are cinema_name, cinema_location, cinema_city.
- Screen:– Attributes of screen are screen_name, screen_no, no_of_seats.
Database Details of Online Movie Ticket Booking System
Movie database ER diagram has following features:
- Each entity contains a primary key and unique key
- For reducing data redundancy, we have normalized all the entities (Movie booking website, Customer, Movie, Booking, Movie Show, Cinema, Screen)
- For faster query execution we have implemented indexing on each table.
- Movie table stores all movie related data, Customer table stores all customer data, Movie Show table stores all different show related details and similarly other tables store respective data.
- 1:1 and 1:M relationship exists in the database.
Download Online Movie Ticket Booking System Synopsis pdf
Online Movie Ticket Booking System ER Diagram
This is an ER model of a movie ticket booking. The entities are represented in rectangular boxes and the relationships between different entities are represented by a diamond shaped box.
Here is complete movie theater database er diagram.