$(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.$[[$VisitNo$,$VisitDate,PatNo,PatAge,PatCity,ProvNo,ProvSpecialty,Diagnosis$],[$V$10020,(1)/(13)/2007,$P$1,35,$DENVER,D$1,$INTERNIST,EAR INFECTION$],[$V$10020,(1)/(13)/2007,$P$1,35,$DENVER,D$2,$NURSE PRACTIONER,INFLUENZA$],[$V$93030,(1)/(20)/2007,$P$3,17,$ENGLEWOOD,D$2,$NURSE PRACTIONER,PREGNANCY$],[$V$82110,(1)/(18)/2007,$P$2,60,$BOULDER,D$3,$CARDIOLOGIST,MURMUR$]]\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$]]$