database

PART D: LOGICAL DATABASE DESIGN (10 points) Membership Member_Id {pk) Name Gender DOB Tel_No Hire >> 0..1 Trainer Trainer_Id {pk} Name Specialty Telephone_No {mandatory.or} Full Member Monthly Fee Parking_No Assoc Member Daily_Fee Program_Type Figure 4 The above EER-Diagram represents a Health Club Membership account that has two types of memberships (see Figure 4). A member can hire trainer if they wish so. Derive relations for logical model from the above EER-Diagram. Please identify any primary key or foreign key in the derive relations (if applicable)