Consider the ER diagram of Figure 7.20, which shows a simplified schema for an airline reservations system.

Question:

Consider the ER diagram of Figure 7.20, which shows a simplified schema for an airline reservations system. Extract from the ER diagram the requirements and constraints that resulted in this schema. Try to be as precise as possible in your requirements and constraints specification.