Online Ticket Booking System ER Diagram | Entity Relationship Diagram

Online Ticket Booking or Reservation System Entity Relationship Diagram in DBMS with Tables

Hi there Itsourcecoders! Today I will give you ideas about the Online Ticket Booking or reservation System ER Diagram (Entity Relationship Diagram) for 2021. This simple database will also give you deep understanding about Online Ticket Booking system database project with ER Diagrams tables. This will teach you in managing Online Ticket Booking database as well as the relationships of tables in Online Ticket Booking or Reservation project database design. By the end of the discussion you will find the Online Ticket Booking system ER diagram PDF and PPT files that will be helpful for your studies in DBMS.

This Entity Relationship Diagram for the Online Ticket Booking System project with a table will also give you the idea of how to make a database design for a Online Ticket Booking system with ERDtables, and schema.

The idea presented here can be used for your Online Ticket Booking system final year project. You can enhance the ER diagram for a system in this article to meet your desired system requirements.

What are included in this ER Diagram for Online Ticket Booking System Database projects 2021?

  • Online Ticket Booking system Description with Features
  • Online Ticket Booking system database tables
  • Simple diagram for Ticket Booking management system
  • Entity Relationship Diagram for Online Ticket Booking System

Online Ticket Booking System ER Diagram Description

This Online Ticket Booking system database design was made based on managing booking requirements. The system can encode customers’ request regarding with ticket bookings. The system admin can have access to the customers’ status and information for booking transaction. They can handle and update the data in accord to ticket bookings as well as the transactions made by their customers.

The features included in the system’s ER diagram were the security and monitoring of the ticket bookings and customers’ records, transactions and status. These features were also listed and recorded in reports that served as the history of transactions done in the system.

ER Diagram For Online Ticket Booking System With Tables and Features

Time needed: 5 minutes.

Here’s the simple database design for Online Ticket Booking system with ER Diagram that includes Tables, PPT, PDF, etc.

  • Online Ticket Booking Management

    Online Ticket Booking Management is the main feature of this system wherein ER diagram contains the basic details of the system. Its information was composed of the transactions done by the customers, the accommodation available for ticket booking.

  • Customer Management

    This feature plays a big role for the system because this gathers the important information of the customers. These information were used to track their transactions and other important matters regarding with the system.

  • Manage Movies’ Information

    The Movies’ information management was important for the system because it serves as the basis of the customers as they avails the bookings offered by the movie system. These information was monitored to keep the customers updated.

  • Transaction and Booking Management

    Its feature will store the bookings made by the customers as well as the date of the transaction. This will also save and update the accommodation based on the date requested by the customers.

Online Ticket Booking System Entity Relationship Diagram Tables

These tables below provide the complete database tables details such as Field NameDescriptionsdata typescharacter lengths.

Table Name: Customer

stud_ID (PK)Customer IDInt11
fnameCustomer First NameVarchar255
lnameCustomer Last NameVarchar255
genderCustomer GenderInt11
ageCustomer AgeInt11
contact_addContact AddressInt11
cust_emailCustomer EmailVarchar255
cust_passCustomer PasswordVarchar255

Table Name: Admin

admin_ID (PK)Admin IDInt11
fnameAdmin First NameVarchar255
lnameAdmin Last NameVarchar255
genderAdmin GenderInt11
ageAdmin AgeInt11
contact_addContact AddressInt11
admin_emailAdmin EmailVarchar255
admin_passAdmin PasswordVarchar255

Table Name: Ticket

ticket_ID (PK)Ticket IDInt11
ticket_numberTicket NumberInt11
accom_timeAccommodation TimeTime
ticket_typeTicket TypeVarchar30
seat_numberSeat NumberInt11

Table Name: Booking or Reservation

res_ID (PK)Reservation IDInt11
ticket_ID (FK)Ticket ID
cust_ID (FK)Customer IDInt11
admin_ID (FK)Admin IDInt11
res_dateReservation IDInt11
time_startTime StartTime
time_endTime EndingTime

Table Name: Transaction

trans_ID (PK)Transaction IDInt11
trans_nameTransaction NameVarchar30
ticket_ID (FK)Ticket IDInt11
res_ID (FK)Reservation IDInt11
cust_ID (FK)Customer IDInt11
admin_ID (FK)Admin IDInt11
trans_dateDate of TransactionDate

Table Name: Reports

report_ID (PK)Report IDInt11
trans_ID (FK)Transaction IDInt11
res_ID (FK)Reservation IDInt11
report_date Report DateDate

Entity Relationship Diagram for Online Ticket Booking or Reservation System

ER Diagram of Online Ticket Booking System shows the system entity relationships in each entity and their supposed functions in each relationship.

Sample ER Diagram for Online Ticket Booking or Reservation System Project

Online Ticket Booking or Reservation System ER Diagram
Online Ticket Booking or Reservation System ER Diagram

Based on the image above, the Entity Relationship diagram for this System is the entity of the Online Ticket Booking system database, which is presented by tables.

The tables are made to meet the required specification of the system and provide much more specific details of each entity within the system.

You can now have the PPT and PDF file of the Online Ticket Booking System ER Diagram for you to have your own copy and basis for your future studies in DBMS.


So that completes our discussion about ER Diagram project fellas, and I hope that this article about ER Diagram For Online Ticket Booking System Database Design 2021 will help you a lot.

Now let me ask you something. What have you learned through the discussion?

May this article help you with your projects in the future!

If you have inquiries or suggestions about Entity Relationship Diagram (ERD) for Online Ticket Booking System just leave us your comments below.

Keep us updated and Good day!

Related Articles:

Leave a Comment