Problem 1: Transform each following EER diagram into a relational schema, with functional dependencies of each relation. If you see any of the relations are not in 3NF, transform them into 3NF too.

1. Relations from Figure 3-6b
2. Relations from Figure 3-7a
3. Relations from Figure 3-9
4. Relations from Figure 3-10

a. Relations from Figure 3-6b d. Relations from Figure 3-10 VEHICLE Vehicle ID Price Engine Displacement Vehicle Name Make Model PERSON SSN Address Gender Date of Partial Specialization: A Vehicle can be a Cor a Truck, but does not have to be ther STUDENT CAR No Of Passengers TRUCK Capacity Cab Type EMPLOYEE Salary Dutered ALUMNUS Degree Ogration Duteill (b) Partial specialization rule FACULTY Park SF Position GRADUATE STUDENT UNDERGRAB STUDENT Figure 3-6 Examples of completeness constraints b. Relations from Figure 3-7a Is Cared For Figure 3-10 Example of supertypelsubtype hierarchy PATIENT Patient ID Patient Name Admit Date RESPONSIBLE PHYSICIAN Physician ID Disjointe A Patient can be either an Outpatientora Resident Patient, but not both at the same time BED OUTPATIENT Checkback Date RESIDENT PATIENT Date Discharged Is Assigned He Bed to (a) Disjoint rule c Relations from Figure 3-9 Subtype discriminator is a composite attribute when there is an overlap PART Part No Description Location Oly On Hand Part Type Manufactured? Purchased SUPPLER Supplier ID Part Types Manufactured?" Purchased MANUFACTURED PART Routing Number PURCHASED PART SUPPLES Unt Price Figure 3-9 Subtype discriminator (overlap rule)