Exp_Date 9. Convert following Project table into Second Normal form: EmpName Shanskaar ProjNumber P-001-C1 P-005-C2 P-008-C2...

Transcribed Image Text:

Exp_Date 9. Convert following Project table into Second Normal form: EmpName Shanskaar ProjNumber P-001-C1 P-005-C2 P-008-C2 P-009-C3 P-007-C5 EMPID EMP-101 EMP-102 EMP-103 EMP-104 Sudha EMP-105 Sudhanshu What anomalies will arise if table is not in 2NF? Shanskriti Sudhan ProjTitle RoadConst-I WaterSupply Railways BridgeConst RoadConst-II Exp_Date 9. Convert following Project table into Second Normal form: EmpName Shanskaar ProjNumber P-001-C1 P-005-C2 P-008-C2 P-009-C3 P-007-C5 EMPID EMP-101 EMP-102 EMP-103 EMP-104 Sudha EMP-105 Sudhanshu What anomalies will arise if table is not in 2NF? Shanskriti Sudhan ProjTitle RoadConst-I WaterSupply Railways BridgeConst RoadConst-II