Q4. Normalize the data up to the 4th 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 4NF. 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 D2 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 P1 Kahlid 12345-104221 R2 042-123 P5 Ahmed 12345 20422 PT Anum 12345 3 0423 NI Dr.Nadeem K613 0334-124, Orthopedic Professor 5000 P4 Mehmood (12345-40424 R2 0300-123 PY Anum 12345-30423 R4 P9 Khawar 12345-60425 Dr. Erum AK 123 0321-123 ENTI P10 Tanweer 12345-7042-6 NII Neurology Professor P1 Khalid 12345-1042-1 R5 Dr. Hafeez Nd123 0321-124 Skin Astt. 3000 P12 Sohail 12345-970428 NU Orthopedic Professor P13 Ahmed 12346-0042-9 R6 NI Normal 81 TWO 35 bed BY NUO Special B8 NU Special B9 D4 Astt 3000 D5