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 P_C_PHYSICIAN_NO --> PHYSICIAN_NAME DEPENDENT_ID -> DEPENDENT_NAME DEPENDENT_ID -> DEPENDENT DATE OF BIRTH DEPENDENT_ID --> DEPENDENT_SEX DEPENDENCE DIAGRAM: Member embership No Membership Type Member Member Name Address Member Date Of Birth Member Employer Employer Address Employer Phone PC Physician No Physician Name Sex 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 DEPENDENT NAME RELATIONSHIP DEPENDENT DATE OF BIRTH DEPENDENT SEX Final answer (write the normalized tables) of questions 1 and 2