Database Systems

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: Membership No Membership Type | Member Name Member Address Employer Member Date of Birth Member Sex Member Employer Employer Address P_C Physician Phone Physician Name No