Question: Transform the ERD below to a Relational Schema. NB: The notation for the generalization hierarchies might be different from your text. You may assume that:
Transform the ERD 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 Capacity Weight EMPLOYEE WORKS ON MAINTAIN PLANE TYPE Restr Lic num PILOT FLIES OF TYPE Date Work code Hours ate/workcode SERVICE Reg LANE SERVIC AIRPLANE Pdate OWNER OWNS STORED IN HANGAR Ssn PERSON CORPORATION Name Phone Name Phone Number Location Address Address Capacity
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
