Question

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.

Fig: 1