INFO DATABASE

PE2.1

Transform the EERD below to a Relational Schema.

NB: The notation for the generalization hierarchies might be different from your text. You may assume that:

Employee & Pilot are subtypes (i.e. subclasses) of Person.

Owner is a category based on Person & Corporation.

Salary Shift Model CapacityWeight WORKS ON EMPLOYEE / MAINTAIN PLANE TYPE Restr Lic_num FLIES > PILOT OF-TYPE Date) Workcode Date/workcode SERVICE Hours AIRPLANE PLANE SERVIC NI Pdate STORED IN OWNS OWNER SsnPERSON HANGAR Number Location Capacity CORPORATION Phone Name Phone Address Address