Design a database for an airline. The database must keep track of cus- tomers and their reservations, flights and their status, seat assignments on individual flights, and the schedule and routing of future flights. Your design should include an E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.
This is a HW problem so can be simple.
