ANSWER THE QUESTION ACCORDING TO THE QUESTION

DONT MAKE YOUR OWN QUESTION AND ANSWER

WRONG ANSWER WILL BE DOWNVOTED

LOGICAL DATABASE DESIGN Hire >> Membership Member_Id {pk Name Gender DOB Tel_No Trainer Trainer_Id {pk) Name Specialty Telephone_No 0..1 {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)