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. Department Designation Charges Patient Id Doc Name Address Phone Patient CNIC Phone Room Room Bed Per hour No. Name No. No. no. D1 Dr. Nadeem Abc 123 0333-123, Neurology 042-123 Professor 5000 P1 Kahlid Ahmed 12345-1 042-1 12345-2| 042-2 N R2 Normal B1 P5 P7 12345-3 042-3 Mehmood 12345-4 042-4 12345-3 042-3 12345-6 042-5 12345-7 | 042-6 12345-1 042-1 12345-9 | 042-8 12346-0 042-9 Anum Nill Dr.Nadeem Kb13 0334-124, Orthopedic Professor 0300-123 D2 5000 P4 P7 R2 R4 Normal B1 Two Anum B5 P9 Khawar bed B7 Dr.Erum 0321-123 ENT/ Neurology Ak123 3000 Astt. Professor D4 P10 Tanweer Nill Nll Khalid R5 Special B8 Nill Special B9 P1 D5 Dr.Hafeez Nd123 0321-124 Astt. 3000 P12 Sohail NI Skin/ Orthopedic Professor P13 Ahmed R6