Question 1. RE-DESIGN THE DATABASE AND ENSURE THAT ALL THE TABLES ARE IN THIRD NORMAL FORM

Question 2. THE SECOND TABLE IS DEPENDENTS:

PART II: NORMALIZATION Question 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, MEMRER SEX MEMBER EMPLOYER EMPLOYER ADDRESS EMPLOYER PHONE, PC PHYSICIAN_NO, PHYSICIAN_NAME) FUNTIONAL DEPENDENCIES MEMBER EMPLOYEREMPLOYER ADDRESS MEMBER EMPLOYERS EMPLOYER PHONE PC PHYSICIAN NO PHYSICIAN NAME DEPENDENT ID DEPENDENT NAME DEPENDENT ID DEPENDENT DATE OF BIRTH DEPENDENT ID-DEPENDENT SEX DEPENDENCE DIAGRAM: 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: TTT CONTR AST Final answer write the normalized tables) of questions 1 and 2