Tafila Stdudent's 10 Question 01 : Design the Enhanced ER-Diagram to keep track of information for a small private airport database that is used to keep track of airplanes, their owners, airport employees, and pilots. Assume that the following requirements were collected: Each AIRPLANE has a registration number (Regt), is of a particular plane type (OF_TYPE], and is stored in a ( 10 Points) particular hangar (STORED_IN]. Each PLANE_TYPE has a model number (Model), a capacity (Capacity), and a weight (Weight]. Each HANGAR has a number (Number), a capacity (Capacity), and a location Location). The database also keep track of the OWNERS of each plane [OWNS) and the EMPLOYEES who have maintained the plane (MAINTAIN). Each relationship instance in OWNS relates an airplane to an owner and includes the purchase date [Pdate). Each relationship instance in MAINTAIN relates an employee to a service record [SERVICE). Each plane undergoes service many times; hence, it is related by [PLANE_SERVICE] to a number of service records. A service record includes as attributes the date of maintenance [Date), the number of hours spent on the work (Hours), and the type of work done [Workcode]. We use a weak entity type (SERVICE) to represent airplane service, because the airplane registration number is used to identify a service record. An owner is either a person or a corporation. Hence, we use a union type (category) (OWNER) that is a subset of the union of corporation (CORPORATION] and person (PERSON] entity types. Both pilots (PILOT) and employees [EMPLOYEE) are subclasses of PERSON. Each pilot has specific attributes license number [lic_Num) and restrictions [Restr], each employee has specific attributes salary (Salaryl and shift worked [Shift). All PERSON ntities in the database have data kept on their social security number (Ssn), name [Name], address [Address). 1 telephone number [Phone]. For CORPORATION entities, the data kept includes name [Name], address Address], and telephone number [Phone]. The database also keep track of the types of planes each pilot is authorized to fly (FLIES) and the types of planes each employee can do maintenance work on [WORKS_ON]