IT 450 Ch 2 Data Models

Consider the attached ER Diagram which shows a simplified schema for an airline reservation 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. Convert the ER diagram and the simplified schema to relational database schema.