Airline Booking System ER Diagram

Subscribe our YouTube channel for latest project videos and tutorials Click Here

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.

Project Category

Related Entity Relationship Diagram (ERD)

Project Management System ER Diagram

Project Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Project Management System Entity. The entity-relationship diagram of Project Management System shows all the visual instrument of database tables and the relations between Employee, Task, Project, Ticket etc. It used structure data and...
Cargo Management System ER Diagram

Cargo Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Cargo Management System Entity. The entity-relationship diagram of Cargo Management System shows all the visual instrument of database tables and the relations between Cargo, Billing, Customer, Payment etc. It used structure data and to...
CRM Application System ER Diagram

CRM Application System ER Diagram

This ER (Entity Relationship) Diagram represents the model of CRM Application System Entity. The entity-relationship diagram of CRM Application System shows all the visual instrument of database tables and the relations between Customer Feedback, Product, Customer, Offering etc. It used structure...
Gym Management System ER Diagram

Gym Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Gym Management System Entity. The entity-relationship diagram of Gym Management System shows all the visual instrument of database tables and the relations between Package, Payment, Gym, Member etc. It used structure data and to define...
College Management System ER Diagram

College Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of College Management System Entity. The entity-relationship diagram of College Management System shows all the visual instrument of database tables and the relations between Books, Issues, Library, Branch etc. It used structure data and to...
Canteen Billing System ER Diagram

Canteen Billing System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Canteen Billing System Entity. The entity-relationship diagram of Canteen Billing System shows all the visual instrument of database tables and the relations between Products, Items, Canteen, Payment etc. It used structure data and to...
Fitness Center Management System ER Diagram

Fitness Center Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Fitness Center Management System Entity. The entity-relationship diagram of Fitness Center Management System shows all the visual instrument of database tables and the relations between Branch, Fitness class, Fitness, Memeber etc. It...
Patient Management System  ER Diagram

Patient Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Patient Management System Entity. The entity-relationship diagram of Patient Management System shows all the visual instrument of database tables and the relations between Doctor, Diease, Patient, Medicine etc. It used structure data and...
Railway Reservation System ER Diagram

Railway Reservation System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Railway Reservation System Entity. The entity-relationship diagram of Railway Reservation System shows all the visual instrument of database tables and the relations between Ticket, Customer, Train, Train Route etc. It used structure...
Library Management System ER Diagram

Library Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Library Management System Entity. The entity-relationship diagram of Library Management System shows all the visual instrument of database tables and the relations between Books, Librarian, Student, Address etc. It used structure data...
Call FreeProjectz WhatsApp FreeProjectz