Question: can you provide explanation Database Normalization Lab Normalize the following u-normalized table to the 3rd Norm Form. Project Project Project Project Employee Employee Department Department
Database Normalization Lab Normalize the following u-normalized table to the 3rd Norm Form. Project Project Project Project Employee Employee Department Department Hourly Code Name Manager Budget No. Name No. Name Rate PC010 Reservation Mr. Ajay 120500 S100 Mohan DO3 Database 21.00 System PC010 Reservation Mr. Ajay 120500 S101 Vipul DO2 Testing 16.50 System PC010 Reservation Mr. Ajay 120500 S102 Riyaz DOI IT 22.00 System PC011 HR System Mrs Charu 500500 S103 Pavan DO3 Database 18.50 PC011 HR System Mrs Charu 500500 S104 Jitendra DO2 Testing 17.00 PC011 HR System Mrs Charu 500500 S315 Pooja DOI IT 23.30 PC012 Attendance M. Rajesh 710700 S137 Rahul D03 Database 21.50 System PC012 Attendance M. Rajesh 710700 S218 Avneesh DO2 Testing 15.50 System PC012 Attendance M. Rajesh 710700 S109 Vikas DOI 20.50 System
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
