Part I. $(40$ Points$)$

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

FUNTIONAL DEPENDENCIES:

MEMBER$\_$EMPLOYER $$ EMPLOYER$\_$ADDRESS

MEMBER$\_$EMPLOYER $$ EMPLOYER$\_$PHONE

P$\_$C$\_$PHYSICIAN$\_$NO $-$ P PHYSICIAN$\_$NAME

DEPENDENT$\_$ID $-->$ DEPENDENT$\_$NAME

DEPENDENT$\_$ID $$ DEPENDENT$\_$DATE$\_$OF$\_$BIRTH

DEPENDENT$\_$ID $$ DEPENDENT$\_$SEX