Flight Boarding Management System (FBMS) — ER Modeling

FBMS is used to manage the details of passengers and flight crew members boarding and checking in to airplane for each flight. As a practice, I attempted the ER modeling of FBMS.

ER Modeling

The process of ER modeling involves the following steps:

1. To identify the real world entities or objects involved in the system
2. To identify the attributes of these real world entities in the system
3. To identify the relationships between these entities in the system
4. To identify the Primary Key (PK) and Foreign Key (FK) among the attributes of each entity in the ER model

FBMS: Entities

As a first step, I identified the following entities in FBMS:

1. Airline
2. Airplane
3. Passenger
4. Pilot
5. Cabin Crew Member
6. Flight
7. Boarding Pass
8. Ticket

FBMS: Entity Relationships

The below ER diagram depicts the attributes of the above entities and also the relationships between those objects.