Create an ER model for a Flight Reservation System for Airplanes. Include some attributes for each entity.

Each Airplane has its own airplane number.

A Seat on each airplane has its own seat number.

A particular reservation is called a FlightReservation, and each flight reservation has a passenger, and a seat number. Each flight is reserved by a Passenger who is given a passenger number.

Note: provide

Point out any weak entity and tell why it's weak

Describe why a mandatory relationship in your model is mandatory.

(Deciding whether participation is mandatory or optional depends on the business rules we want to enforce. Often you could decide, either way, so be sure to tell why).