Subject: Database Management System

Q.2. Draw an ERD with attributes (clearly indicating the attribute types) for the following scenario: The PIA Database stores details about PIAs fleet (group / number of planes), flights, and seat bookings. PIA has one or more airplanes. An airplane has a model number, a unique registration number, and the capacity to take one or more passengers. An airplane flight has a unique flight number, a departure airport, a destination airport, a departure date and time, and an arrival date and time. Each flight is carried out by a single airplane. A passenger has first name, a middle name, last name, and a unique passport number. A passenger can book a seat on a flight. 10