Airline Booking System ER Diagram

Posted By freeproject on July 17, 2017

This ER (Entity Relationship) Diagram represents the model of Airline Booking System Entity. The entity-relationship diagram of Airline Booking System shows all the visual instrument of database tables and the relations between Airlines Booking, Ticket, Ticket, Airline Enquiry etc. It used structure data and to define the relationships between structured data groups of Airline Booking System functionalities. The main entities of the Airline Booking System are Ticket, Airlines Booking, Passenger, Ticket, Booking Enquiry, and Airline Enquiry.

Airline Booking System entities and their attributes :

  • Ticket Entity : Attributes of Ticket are ticket_id, ticket_customer_id, ticket_type, ticket_date, ticket_description
  • Airlines Booking Entity : Attributes of Airlines Booking are airlines booking_id, airlines_passenger_id, airlines booking_type, airlines booking_date, airlines booking_description
  • Passenger Entity : Attributes of Passenger are passenger_id, passenger_name, passenger_mobile, passenger_email, passenger_username, passenger_password, passenger_address
  • Ticket Entity : Attributes of Ticket are ticket_id, ticket_type, ticket_booking_id, ticket_Date, ticket_description
  • Booking Enquiry, Entity : Attributes of Booking Enquiry, are booking enquiry,_id, booking enquiry,_title, booking enquiry,_type, booking enquiry,_date, booking enquiry,_description
  • Airline Enquiry Entity : Attributes of Airline Enquiry are airline enquiry,_id, airline enquiry,_title, airline enquiry,_type, airline enquiry,_date, airline enquiry,_description

Description of Airline Booking System Database :

  • The details of Ticket is store into the Ticket tables respective with all tables
  • Each entity (Airline Enquiry, Passenger, Booking Enquiry,, Airlines Booking, Ticket) contains primary key and unique keys.
  • The entity Passenger, Booking Enquiry, has binded with Ticket, Airlines Booking entities with foreign key
  • There is one-to-one and one-to-many relationships available between Booking Enquiry,, Ticket, Airline Enquiry, Ticket
  • All the entities Ticket, Booking Enquiry,, Passenger, Airline Enquiry are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Airline Booking System tables for fast query execution.
Airline Booking System ER Diagram
Get 6 diagrams only in 300/- or $6.99 USD.
Call or WhatsApp us on +91-8470010001 for more details.

Related Entity Relationship Diagram (ERD)

Fashion Model Management System ER Diagram

Fashion Model Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Fashion Model Management System Entity. The entity-relationship diagram of Fashion Model Management System shows all the visual instrument of database tables and the relations between Models, Events, Fashion, ##keyword6## etc. It used...
Contract Management System ER Diagram

Contract Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Contract Management System Entity. The entity-relationship diagram of Contract Management System shows all the visual instrument of database tables and the relations between Authoring, Reporting, Contract, Tenders etc. It used structure...
Insurace Policy Enquiry System ER Diagram

Insurace Policy Enquiry System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Insurace Policy Enquiry System Entity. The entity-relationship diagram of Insurace Policy Enquiry System shows all the visual instrument of database tables and the relations between Buyers, Payments, Insurance, User etc. It used...
Stores Manager Sales System ER Diagram

Stores Manager Sales System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Stores Manager Sales System Entity. The entity-relationship diagram of Stores Manager Sales System shows all the visual instrument of database tables and the relations between Customer, Sales, Stores, Supplier etc. It used structure...
Cheque Book Transaction System ER Diagram

Cheque Book Transaction System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Cheque Book Transaction System Entity. The entity-relationship diagram of Cheque Book Transaction System shows all the visual instrument of database tables and the relations between Account, Balance, Cheque Book, Customer etc. It used...
Budget Controlling System ER Diagram

Budget Controlling System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Budget Controlling System Entity. The entity-relationship diagram of Budget Controlling System shows all the visual instrument of database tables and the relations between Employee, Sales, Budget, Login etc. It used structure data and to...