Q$4.$ Normalize the data up to the $4$th Normal Form? N&N Hospital is facing problems in its data organization. As database analyst, you have to normalize following N&N Hospital data up to $4$NF$.$ Elaborate each step you perform with logic and state clearly any other VALID assumption that you make Doc no$.01$ Room Bed Type No$.$ Normal $81$ D$2$ Name Address Phone Department Designation Charges Patient Patient CNIC Phone Room Id Per hour No$.$ Name No$.$ Dr$.$Nadeem Abc $1230333-123,$ Neurology Professor $5000$ P$1$ Kahlid $12345-104221$ R$2042-123$ P$5$ Ahmed $1234520422$ PT Anum $1234530423$ NI Dr$.$Nadeem K$6130334-124,$ Orthopedic Professor $5000$ P$4$ Mehmood $(12345-40424$ R$20300-123$ PY Anum $12345-30423$ R$4$ P$9$ Khawar $12345-60425$ Dr$.$ Erum AK $1230321-123$ ENTI P$10$ Tanweer $12345-7042-6$ NII Neurology Professor P$1$ Khalid $12345-1042-1$ R$5$ Dr$.$ Hafeez Nd$1230321-124$ Skin Astt. $3000$ P$12$ Sohail $12345-970428$ NU Orthopedic Professor P$13$ Ahmed $12346-0042-9$ R$6$ NI Normal $81$ TWO $35$ bed BY NUO Special B$8$ NU Special B$9$ D$4$ Astt $3000$ D$5$