Hi! Today, I’ll share some thoughts on the ER Diagram Airline Reservation System.
This small database will also provide you with a thorough overview of the tables in the Airline Reservation system database project.
This course will teach you how to administer an airline reservation database and how to construct a database for an airline reservation system.
You will get the Airline Reservation System ER diagram PDF and PPT files at the end of the talk, which will be useful for your DBMS studies.
What are included in this ER Diagram of Airline Reservation System Database projects?
- Airline Ticket Reservation System Description with Features
- Airline Reservation system database tables
- A simple diagram for Airline Reservation management system
- ER Diagram for Airline Ticket Reservation System
Airline Reservation System ER Diagram and Database Structure Description
The database design for this airline reservation system was based on managing reservation requirements. Customers’ requests for airline reservations can be encoded by the system.
Customers’ status and information for reservation transactions can be seen by the system administrator. They can manage and update data related to bookings and transactions made by their customers.
The system’s ER diagram includes features such as security and monitoring of reservations and customers’ records, transactions, and status.
These characteristics were also listed and recorded in reports that served as a record of the system’s transactions.
Features of Airline Reservation System ER Diagram
Time needed: 5 minutes
Here are the airline reservation system features which were the basis for creating the database tables and ER Diagram design for project development.
- Customer Management
This function is extremely vital to the system because it collects all of the important information from the clients. These details were utilized to keep track of their transactions and other key system details.
- Airline Ticket Reservation Management
The core aspect of this system is airline reservation management, and the ER diagram covers the system’s essential details. Its data consisted of client transactions and available accommodations for reserve.
- Manage Airline Information
The airline information management was critical for the system since it serves as the foundation for customers who utilize the airline’s reservation services. These details were kept track of in order to keep clients informed.
- Transaction and Reservation Management
Its feature will keep track of the reservations made by consumers as well as the transaction’s date. The accommodate will be saved and updated based on the date desired by the clients.
Airline Reservation System Database Tables
The tables below provide the complete database table details such as Field Name, Descriptions, data types, and character lengths.
Table Name: tbl_Customer
| Field | Description | Type | Length |
| stud_ID (PK) | Customer ID | Int | 11 |
| fname | Customer First Name | Varchar | 255 |
| lname | Customer Last Name | Varchar | 255 |
| gender | Customer Gender | Int | 11 |
| age | Customer Age | Int | 11 |
| contact_add | Contact Address | Int | 11 |
| cust_email | Customer Email | Varchar | 255 |
| cust_pass | Customer Password | Varchar | 255 |
Table Name: tbl_Admin
| Field | Description | Type | Length |
| admin_ID (PK) | Admin ID | Int | 11 |
| fname | Admin First Name | Varchar | 255 |
| lname | Admin Last Name | Varchar | 255 |
| gender | Admin Gender | Int | 11 |
| age | Admin Age | Int | 11 |
| contact_add | Contact Address | Int | 11 |
| admin_email | Admin Email | Varchar | 255 |
| admin_pass | Admin Password | Varchar | 255 |
Table Name: tbl_Ticket
| Field | Description | Type | Length |
| ticket_ID (PK) | Ticket ID | Int | 11 |
| ticket_num | Ticket Number | Int | 11 |
| date_avail | Date Available | Date | |
| date_flight | Date of Flight | Date | |
| time_depart | Departure Time | Time | |
| time_land | Landing Time | Time | |
| destination | Destination | Varchar | 30 |
Table Name: tbl_Reservation
| Field | Description | Type | Length |
| res_ID (PK) | Reservation ID | Int | 11 |
| cust_ID (FK) | Customer ID | Int | 11 |
| admin_ID (FK) | Admin ID | Int | 11 |
| ticket_ID (FK) | Ticket ID | Int | 11 |
| date_reserve | Date Reservation | Date | |
| date_accom | Date of Accommodation | Date |
Table Name: tbl_Transaction
| Field | Description | Type | Length |
| trans_ID (PK) | Transaction ID | Int | 11 |
| trans_name | Transaction Name | Varchar | 30 |
| borrowing_ID (FK) | Subject ID | Int | 11 |
| stud_ID (FK) | Student ID | Int | 11 |
| trans_date | Date of Transaction | Date |
Table Name:tbl_ TransactionType
| Field | Description | Type | Length |
| transty_ID (PK) | Transaction Type ID | Int | 11 |
| trans_name | Transaction Type | Varchar | 30 |
Table Name: tbl_Reports
| Field | Description | Type | Length |
| report_ID (PK) | Report ID | Int | 11 |
| trans_ID (FK) | Transaction ID | Int | 11 |
| res_ID (FK) | Reservation ID | Int | 11 |
| report_date | Report Date | Date |
Entity Relationship Diagram of Airline Reservation System
ER Diagram Symbols
In the image below, you will see the different ER Diagram Symbols.
ER Diagram of Airline Reservation System shows the system entity relationships in each entity and their supposed functions in each relationship.
ER Diagram of Airline Reservation System with Relationship
This section will show you the ER Diagram for the Airline Reservation System. In the image below you see the actual relationship of all entities.
In creating this activity diagram we used lucidchart.
ER Diagram of Airline Reservation System
The database design shown with tables in the Entity Relationship diagram for the Airline Reservation System is shown in the image above.
The tables are designed to suit the system’s requirements and to provide considerably more detailed information about each entity within the system.
The purpose of this ER Diagram is to thoroughly comprehend both the Airline System and the table relationships in the project database design.
You can also get a PDF copy of the conversation if you want to use it as a reference for your project.
Conclusion
To summarize, we have discussed the ER diagram for the Airline Reservation System, and above we have the system database tables and their relationships.
Related Articles
- Activity Diagram for Airline Reservation System
- Airline Reservation System Use Case Diagram
- Airline Reservation System in PHP with Source Code
- ER Diagram for Online Hotel Reservation System
Inquiries
If you have inquiries or suggestions about the ER Diagram of the Airline Reservation System just leave us your comments below.
We would be glad to know to concerns and suggestions and be part of your learning.
Keep us updated and Good day!