[solved]-Bcnf Table Normalization 1a Show Deletion Modification Insertion Anomalies Table 1b Norma Q39088854

BCNF Table Normalization 1a) Show the deletion, modification and insertion anomalies on the table below. 1b) Normalize the table and explain why it’s a BCNF The following shipment table is in 1NF Shipment(S# P#, Status, city, qty) Status P# P1 20 S# S1 S1 S1 S1 S1 P2 P3 20 20 20 20 Qty 100 200 300 100 300 S1 20 City London London London London London London Paris Paris Paris London London London Zurich P4 P5 P6 P4 P5 P6 P1 P3 S2 S2 10 10 450 200 140 300 600 120 S2 10 20 S3 S3 20 20 120 S3 S4 P5 P4 30 100 Show transcribed image text BCNF Table Normalization 1a) Show the deletion, modification and insertion anomalies on the table below. 1b) Normalize the table and explain why it’s a BCNF The following shipment table is in 1NF Shipment(S# P#, Status, city, qty) Status P# P1 20 S# S1 S1 S1 S1 S1 P2 P3 20 20 20 20 Qty 100 200 300 100 300 S1 20 City London London London London London London Paris Paris Paris London London London Zurich P4 P5 P6 P4 P5 P6 P1 P3 S2 S2 10 10 450 200 140 300 600 120 S2 10 20 S3 S3 20 20 120 S3 S4 P5 P4 30 100

Expert Answer

---

Answer to BCNF Table Normalization 1a) Show the deletion, modification and insertion anomalies on the table below. 1b) Normalize t… . . .