Entities:
1. Passenger
- Attributes: passenger_id (PK), name, age
2. Amenity
- Attributes: amenity_id (PK), location, type
3. Flight
- Attributes: flight_id (PK), passenger_id (FK), departure_airport, arrival_airport
4. Medical Emergency
- Attributes: emergency_id (PK), passenger_id (FK), date_time, description
Relationships:
- Passenger can request the location of an Amenity (1:1)
- Passenger can have multiple Flights (1:M)
- Passenger can request medical assistance multiple times (1:M)
(Entity Relationship Diagram notations are not supported in text format. We recommend using a tool or software such as Microsoft Visio, Lucidchart, or draw.io to create the diagram visually.)
Assume that the following business rules are in place:
• One passenger can request the location of one and only one amenity at a time.
• It is possible for a passenger to have multiple flights departing from the same airport and, as such, can view multiple flight bookings.
• One passenger can experience multiple medical emergencies and, as such, can request medical assistance multiple times..Q.3.1 Create an Entity Relationship Diagram that will represent the business rules
presented at the beginning of the question. Include at least three attributes for every entity. Also, indicate the primary keys for each entity.
1 answer