ProblemSaemert: Design a database for an airline the database must keep track of customers and their reservations, fights and their status, seat assignments on individual fights, and the schedule and routine offuture fights. 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. Passenger cannot make cancellations Entities: Passenger. This entity includes passenger detail's Pid, name, age, address, e-mail. Airport This entity includes Airport details like Aiport code, name, city and county. -Bookig O 0e: lt nades Office-Id and Office name. Arplane This entity includes Reg No, Fight type, and no of seats. Arines: This entty represents the Airine Name and its owner. ight This entity includes details about the flights which comprises of Flight, Class - Eg: Business class, Economy class etc., source and destination airports of fights, its departure date and time, arrival date and time. Rektionshps: Books Tcket t is a relationship between the Passenger and Booking office. Lands On Its a relationship between the Airplane and Aiport, It depicts which plane lands on which airport. Owned By. Its a relationship which shows which relationship between the Airplane and Airines. ie., Which airplane belongs to which Arines. Flies: is a relationship that tells which Flight fies under which Airline. Travels an Its a relationship that tells us which fight travels on which routes. ie., Itshows the relationship between Flight and Route Charges: t's a relationship between the Route and Fare entities