Assume that the following business rules are in place:

Question

• 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...HOW do I also connect ct the diagram which diagram goes first

Answer 1

To create an Entity Relationship Diagram (ERD) representing the business rules mentioned above, you can follow these steps:

1. Identify the entities:
- Passenger
- Amenity
- Flight
- Medical Emergency

2. Define attributes for each entity:
Passenger:
- Passenger_ID (Primary key)
- Name
- Contact_Number

Amenity:
- Amenity_ID (Primary key)
- Name
- Location

Flight:
- Flight_ID (Primary key)
- Departure_Time
- Destination

Medical Emergency:
- Emergency_ID (Primary key)
- Description
- Location

3. Connect the entities:
- Connect Passenger entity with Amenity entity using a one-to-many relationship (one passenger can request the location of one amenity at a time).
- Connect Passenger entity with Flight entity using a one-to-many relationship (one passenger can have multiple flights departing from the same airport).
- Connect Passenger entity with Medical Emergency entity using a one-to-many relationship (one passenger can experience multiple medical emergencies).

Below is an example of the ERD:

```
+-------------+
| Passenger |
+-------------+
| Passenger_ID| <- PK
| Name |
| Contact_Number |
+-------------+
|
|
|
+--------------------------------+
| | |
▼ ▼ ▼
+-----------+ +---------+ +-----------------------+
| Amenity | | Flight | | Medical Emergency |
+-----------+ +---------+ +-----------------------+
| Amenity_ID| | Flight_ID| | Emergency_ID |
| Name | | Departure_Time | Description |
| Location | | Destination | Location |
+-----------+ +---------------+---------+------+
| |
| |
```

This ERD illustrates the relationships between the Passenger entity, Amenity entity, Flight entity, and Medical Emergency entity based on the business rules provided. Each entity has its primary key attribute, and the connections between entities show the relationships between them.