Question 2 SEE FUNCTIONAL DEPENDENCIES ON DIAGRAM SHOW BELOW

FINAL ANSWER(WRITE THE NORMALIZED TABLES) OF QUESTION 1 AND 2

PARTE II: NORMALIZACION (50 Pts.). Question 1. . RE-DESIGN THE DATABASE AND ENSURE THAT ALL THE TABLES ARE IN THIRD NORMAL FORM THE FIRST TABLE IS MEMBER: MEMBER(MEMBERSHIP NO, MEMBERSHIP_TYPE, MEMBER_NAME, MEMBER_ADDRESS, MEMBER DATE OF BIRTH, MEMBER_SEX, MEMBER EMPLOYER, EMPLOYER ADDRESS EMPLOYER PHONE, P C PHYSICIAN NO, PHYSICIAN NAME) FUNTIONAL DEPENDENCIES: MEMBER EMPLOYER --> EMPLOYER ADDRESS MEMBER EMPLOYER --> EMPLOYER PHONE PC PHYSICIAN NO --> PHYSICIAN NAME DEPENDENT ID --> DEPENDENT NAME DEPENDENT ID --> DEPENDENT DATE OF BIRTH DEPENDENT ID --> DEPENDENT SEX DEPENDENCE DIAGRAM: Member Membership No Membership Type Member Name Member Address Member Date Of Birth Sex Member Employer Employer Address Employer Phone PC Physician No Physician Name Question 2. THE SECOND TABLE IS DEPENDENTS: DEPENDENTS(MEMBERSHIP NO, DEPENDENT_ID, DEPENDENT_NAME, RELATIONSHIP, DEPENDENT_DATE_OF_BIRTH, DEPENDENT-SEX) See Functional dependencies on diagram shown below: DEPENDENCE DIAGRAM: MEMBERSHIP NO DEPENDENT RELATIONSHIP DEPENDENT NAME DEPENDENT DATE OF BIRTH DEPENDENT SEX ID CLOT final answer (write the normalized tables) of questions 1 and 2