Create an ER model for a Reservation System for an airline. Include some non$-$key attributes for each entity. $($Hint: There are four entities$)$

Each Airline ${?}_{(})$ has its own airline number ${?}_{(}).$

Each Flight has their own flight number, airline number, destination, and date$/$time$.$ The airline number stores the airline of the flight.

Each Customer has their own customer number, and name.

$,$ Each Customer can make a flight reservation where a FlightReservation has a flight number, customer number, and seat number.

Put your diagram here:

Make sure you note these:

a$.$ Maximum and minimum cardinalities via crowfoot notation on your ERD.

b$.$ Add a weak entity to your ERD above and describe why it's weak

c$.$ 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$).$