Question: 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 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 R2042-123 P5 Ahmed 1234520422 PT Anum 1234530423 NI Dr.Nadeem K6130334-124, Orthopedic Professor 5000 P4 Mehmood (12345-40424 R20300-123 PY Anum 12345-30423 R4 P9 Khawar 12345-60425 Dr. Erum AK 1230321-123 ENTI P10 Tanweer 12345-7042-6 NII Neurology Professor P1 Khalid 12345-1042-1 R5 Dr. Hafeez Nd1230321-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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!