$(50\%)$ Using the Rowan Medical Patient Table below, complete the steps below for this exercise.

database image.png

$(10\%)$ List the functional dependencies and draw the functional dependency diagram for this table.

$(10\%)$ Follow the steps of converting this table into $1$st normal form and describe each step throughout the normalization process.

$(15\%)$ Follow the steps of converting this table into $2$nd normal form and describe each step throughout the normalization process.

$(15\%)$ Follow the steps of converting this table into $3$rd normal form and describe each step throughout the normalization process.$\backslash$table$[[$VisitNo$,$VisitDate,PatNo,PatAge,PatCity,ProvNo,ProvSpecialty,Diagnosis$],[$V$10020,\frac{1}{13}\frac{?}{2007},$P$1,35,$DENVER,D$1,$INTERNIST,EAR INFECTION$],[$V$10020,\frac{1}{13}\frac{?}{2007},$P$1,35,$DENVER,D$2,$NURSE PRACTIONER,INFLUENZA$],[$V$93030,\frac{1}{20}\frac{?}{2007},$P$3,17,$ENGLEWOOD,D$2,$NURSE PRACTIONER,PREGNANCY$],[$V$82110,\frac{1}{18}\frac{?}{2007},$P$2,60,$BOULDER,D$3,$CARDIOLOGIST,MURMUR$]]$