Task 1:

En tites!

1. Customer

2. Flight

3. Reservation

4. Payment

weak Entity Seat

Relationships:

1. Customer books a reservation for flight

2. Reservation is made for a specific Seat onflight

3. Payment is made for areservation

4. Flight multiple reservations

Composite attributes:

Address attribute for Customer entity

Multivalued attributes:

Amenities attribute for Flight entity

Generalization and Specialization!

Reservation entity can be generalized into Economy Reservation and

Business Reservation, and Seat entity is a weak entity that belonge to the

Reservation entity.