RE$-$DESIGN THE DATABASE AND ENSURE THAT ALL THE TABLES ARE IN THIRD NORMAL FORM. Show the table $($or schemas$).$

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

THE FIRST TABLE IS MEMBER.

The Schema of the table is as follows:

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$)$

THE SECOND TABLE IS DEPENDENTS:

The Schema of the table is as follows:

DEPENDENTS$($MEMBERSHIP$\_$NO$,$ DEPENDENT$\_$ID$,$ DEPENDENT$\_$NAME, RELATIONSHIP,

DEPENDENT$\_$DATE$\_$OF$\_$BIRTH, DEPENDENT$-$SEX$)$