QUESTION 1

Re-desing the database and ensure that all the tables are in third normal form

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 NAME DEPENDENT ID --> DEPENDENT DATE OF BIRTH --> DEPENDENT SEX DEPENDENT ID DEPENDENT ID DEPENDENCE DIAGRAM: Membership Membership Type Member Member Member Member Member Employer Address Employer Phone PC Physician Name Date Of Birth No Name Address Sex Employer Physician No