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)

Doctors Information System ER Diagram

Doctors Information System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Doctors Information System Entity. The entity-relationship diagram of Doctors Information System shows all the visual instrument of database tables and the relations between Degree, schedule, Doctors, Test etc. It used structure data and...
Course Registration System ER Diagram

Course Registration System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Course Registration System Entity. The entity-relationship diagram of Course Registration System shows all the visual instrument of database tables and the relations between Fees, Students, Course, Trainers etc. It used structure data...
Feedback Management System ER Diagram

Feedback Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Feedback Management System Entity. The entity-relationship diagram of Feedback Management System shows all the visual instrument of database tables and the relations between Comment, Product quality, Feedback, Notification etc. It used...
Car Rental System ER Diagram

Car Rental System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Car Rental System Entity. The entity-relationship diagram of Car Rental System shows all the visual instrument of database tables and the relations between Booking, Car Routes, Cars, ##keyword6## etc. It used structure data and to define...
Online Travel Portal System ER Diagram

Online Travel Portal System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Online Travel Portal System Entity. The entity-relationship diagram of Online Travel Portal System shows all the visual instrument of database tables and the relations between Registrations Customer, Bookings, Users, Payments etc. It...
Marrige Buero Management ER Diagram

Marrige Buero Management ER Diagram

This ER (Entity Relationship) Diagram represents the model of Marrige Buero Management Entity. The entity-relationship diagram of Marrige Buero Management shows all the visual instrument of database tables and the relations between Registration, Photograps, Partners, Multipile Types etc. It used...
Poll Survey System ER Diagram

Poll Survey System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Poll Survey System Entity. The entity-relationship diagram of Poll Survey System shows all the visual instrument of database tables and the relations between Users, Survey, Polls, Registration etc. It used structure data and to define...
Attendance Management System ER Diagram

Attendance Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Attendance Management System Entity. The entity-relationship diagram of Attendance Management System shows all the visual instrument of database tables and the relations between Employee, Holidays, Attendance, Login etc. It used...
Faculty Management System ER Diagram

Faculty Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Faculty Management System Entity. The entity-relationship diagram of Faculty Management System shows all the visual instrument of database tables and the relations between Faculty, Teacher, Leave, Subject etc. It used structure data and...
Office Management System ER Diagram

Office Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Office Management System Entity. The entity-relationship diagram of Office Management System shows all the visual instrument of database tables and the relations between Employees, Tasks, Offices, Time Entries etc. It used structure data...
Call FreeProjectz WhatsApp FreeProjectz