Questions

A)Normalize the above database to 1NF,2NF,3NF and Boyce-Codd normal form (BCNF)?

B)Show each step taken that is, movement from one normal form to another?

C)Briefly explain each business rule?

Transcribed Image Text:

Claims Claim_ Bill_N Contract_ Numbe umbe Item_N Number Bill Description umber Item_Description Unit Rate Place Quantity Date wSC 19/20 WSC 19/20 WSC 19/20 wSC 19/20 wsC 19/20 wsC 19/20 wSC 19/20 WSC 19/20 wSC 19/20 wsC 19/20 wsC 19/20 wsC 19/20 wsC 19/20 wsC 19/20 1 Desilting Desilting Desilting Desilting Desilting Desilting Gravelling Gravelling Gravelling Gravelling Gravelling Construct new crossing Upgrade Culvert Crossing Desilting Desilting Desilting Desilting Desilting Excavate Drain And Level Spoil On Site Desilt and clean drain from one side and level spoil on site LM Desilt and clean drain from one side and level spoil on site Desilt and clean drain from one side and level spoil on site LM Desilt and clean drain from one side and level spoil on site Desilt and clean drain from one side and level spoil on site Desilt and clean drain from one side and level spoil on site Gravelling Gravelling $0.50 $0.50 Cautata Dravo 1 1 1006 2/1/2020 1 1 1 LM 247 2/1/2020 Koronivia West 2/1/2020 2/1/2020 2/1/2020 2/1/2020 2/1/2020 2/1/2020 2/1/2020 2/1/2020 2/1/2020 2/1/2020 2/1/2020 4/18/2020 4/18/2020 4/18/2020 4/18/2020 |4/18/2020 2268.33 4/18/2020 1 1 1 $0.50 38 $0.50 $0.50 1 1 1 LM Lakena/Manoca/Buiduna 212 1 1 1 LM Mokani 1500 1 LM $0.50 Waikete 2866 1 3 4 M3 $15.00 Cautata 50 1 4 M3 $15.00 Dravo 15 Gravelling Gravelling Gravelling Construct New Crossing 1 3 4 M3 $15.00 Naila 44.5 $15.00 $15.00 LM $1,000.00 Naila $500.00 Buiduna $0.50 $0.50 $0.50 M3 M3 Naitalasese Waivou 1 3 4 89 1 3 4 29.6 1(b) 1(c) Upgrade culvert crossing Desilt and clean drain from one side and level spoil on site 1 2.88 1 LM 2.88 Lakena/Manoca/Waituri Qaraniki/Naselai Qaraniki/Visama Qumgum 2 1 LM 3662 WSC 19/20 WSC 19/20 WSC 19/20 wsC 19/20 wsC 19/20 1 Desilt and clean drain from one side and level spoil on site Desilt and clean drain from one side and level spoil on site LM Desilt and clean drain from one side and level spoil on site 1 1 LM 3000 2 1 1 3321 2 1 1 LM $0.50 1556 $0.50 $1.50 $1.50 LM $1,000.00 Noco $500.00 Naitasiri $50.00 Waituri $1.00 $1.50 Desilt and clean drain from one side and level spoil on site LM Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site Construct Flap Gate 2 1 Vuci 4568 2 M3 Qaraniki/Naselai 257.33 4/18/2020 Excavate Drain And Level Spoil On Site Construct new crossing WsC 19/20 wSC 19/20 wSC 19/20 wSC 19/20 WSC 19/20 WSC 19/20 WSC 19/20 WSC 19/20 2 2 1 M3 Vuci 3(c) 1(c) Upgrade culvert crossing Stone Pitching General Excavation Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site 1(c) Upgrade culvert crossing Stone Pitching General Excavation Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site 1(c) Upgrade culvert crossing 1(ii) Upgrade of Doors and Components 1(ii) JUpgrade of Doors and Components 4/18/2020 4/18/2020 4/18/2020 4/18/2020 4/19/2020 4/19/2020 4/20/2020 4/20/2020 4/20/2020 4/21/2020 4/21/2020 4/22/2020 2 4 3.1 Upgrade Culvert Crossing Stone Pitching and General Excavation Stone Pitching and General Excavation Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site Upgrade Culvert Crossing Stone Pitching and General Excavation Stone Pitching and General Excavation Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site 2 LM M3 2.66 2 5.68 2. 4 M3 Waituri 155 Noco Waituri 3 2 1 M3 300 3 2 1 M3 $1.50 300 LM M3 $500.00 Noco $50.00 2.26 wSC 19/20 wSC 19/20 wsC 19/20 wSC 19/20 wSC 19/20 wSC 19/20 wSC 19/20 wSC 19/20 WSC 20/20 wSC 20/20 3 3 Noco 5 3 4 M3 $1.00 Waituri 20 $1.50 $1.50 $1.50 $1.50 M3 Naila 20 4 2 M3 Vuci 365 Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site Upgrade Culvert Crossing Upgrade Doors And Components Upgrade Doors And Components Buiduna Naila 2 1 562 M3 M3 1 1 4/22/2020 4/22/2020 4/22/2020 4/24/2020 4/25/2020 $1.50 Vuci $500.00 Naila 2 1 M3 10 LM SET $1,000.00 Dravo SET $1,000.00 Vuci 5 2.55 6. 4 6 Claims Claim_ Bill_N Contract_ Numbe umbe Item_N Number Bill Description umber Item_Description Unit Rate Place Quantity Date wSC 19/20 WSC 19/20 WSC 19/20 wSC 19/20 wsC 19/20 wsC 19/20 wSC 19/20 WSC 19/20 wSC 19/20 wsC 19/20 wsC 19/20 wsC 19/20 wsC 19/20 wsC 19/20 1 Desilting Desilting Desilting Desilting Desilting Desilting Gravelling Gravelling Gravelling Gravelling Gravelling Construct new crossing Upgrade Culvert Crossing Desilting Desilting Desilting Desilting Desilting Excavate Drain And Level Spoil On Site Desilt and clean drain from one side and level spoil on site LM Desilt and clean drain from one side and level spoil on site Desilt and clean drain from one side and level spoil on site LM Desilt and clean drain from one side and level spoil on site Desilt and clean drain from one side and level spoil on site Desilt and clean drain from one side and level spoil on site Gravelling Gravelling $0.50 $0.50 Cautata Dravo 1 1 1006 2/1/2020 1 1 1 LM 247 2/1/2020 Koronivia West 2/1/2020 2/1/2020 2/1/2020 2/1/2020 2/1/2020 2/1/2020 2/1/2020 2/1/2020 2/1/2020 2/1/2020 2/1/2020 4/18/2020 4/18/2020 4/18/2020 4/18/2020 |4/18/2020 2268.33 4/18/2020 1 1 1 $0.50 38 $0.50 $0.50 1 1 1 LM Lakena/Manoca/Buiduna 212 1 1 1 LM Mokani 1500 1 LM $0.50 Waikete 2866 1 3 4 M3 $15.00 Cautata 50 1 4 M3 $15.00 Dravo 15 Gravelling Gravelling Gravelling Construct New Crossing 1 3 4 M3 $15.00 Naila 44.5 $15.00 $15.00 LM $1,000.00 Naila $500.00 Buiduna $0.50 $0.50 $0.50 M3 M3 Naitalasese Waivou 1 3 4 89 1 3 4 29.6 1(b) 1(c) Upgrade culvert crossing Desilt and clean drain from one side and level spoil on site 1 2.88 1 LM 2.88 Lakena/Manoca/Waituri Qaraniki/Naselai Qaraniki/Visama Qumgum 2 1 LM 3662 WSC 19/20 WSC 19/20 WSC 19/20 wsC 19/20 wsC 19/20 1 Desilt and clean drain from one side and level spoil on site Desilt and clean drain from one side and level spoil on site LM Desilt and clean drain from one side and level spoil on site 1 1 LM 3000 2 1 1 3321 2 1 1 LM $0.50 1556 $0.50 $1.50 $1.50 LM $1,000.00 Noco $500.00 Naitasiri $50.00 Waituri $1.00 $1.50 Desilt and clean drain from one side and level spoil on site LM Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site Construct Flap Gate 2 1 Vuci 4568 2 M3 Qaraniki/Naselai 257.33 4/18/2020 Excavate Drain And Level Spoil On Site Construct new crossing WsC 19/20 wSC 19/20 wSC 19/20 wSC 19/20 WSC 19/20 WSC 19/20 WSC 19/20 WSC 19/20 2 2 1 M3 Vuci 3(c) 1(c) Upgrade culvert crossing Stone Pitching General Excavation Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site 1(c) Upgrade culvert crossing Stone Pitching General Excavation Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site 1(c) Upgrade culvert crossing 1(ii) Upgrade of Doors and Components 1(ii) JUpgrade of Doors and Components 4/18/2020 4/18/2020 4/18/2020 4/18/2020 4/19/2020 4/19/2020 4/20/2020 4/20/2020 4/20/2020 4/21/2020 4/21/2020 4/22/2020 2 4 3.1 Upgrade Culvert Crossing Stone Pitching and General Excavation Stone Pitching and General Excavation Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site Upgrade Culvert Crossing Stone Pitching and General Excavation Stone Pitching and General Excavation Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site 2 LM M3 2.66 2 5.68 2. 4 M3 Waituri 155 Noco Waituri 3 2 1 M3 300 3 2 1 M3 $1.50 300 LM M3 $500.00 Noco $50.00 2.26 wSC 19/20 wSC 19/20 wsC 19/20 wSC 19/20 wSC 19/20 wSC 19/20 wSC 19/20 wSC 19/20 WSC 20/20 wSC 20/20 3 3 Noco 5 3 4 M3 $1.00 Waituri 20 $1.50 $1.50 $1.50 $1.50 M3 Naila 20 4 2 M3 Vuci 365 Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site Excavate Drain And Level Spoil On Site Upgrade Culvert Crossing Upgrade Doors And Components Upgrade Doors And Components Buiduna Naila 2 1 562 M3 M3 1 1 4/22/2020 4/22/2020 4/22/2020 4/24/2020 4/25/2020 $1.50 Vuci $500.00 Naila 2 1 M3 10 LM SET $1,000.00 Dravo SET $1,000.00 Vuci 5 2.55 6. 4 6

Answer rating: 100% (QA)

A Normalization 1NF ContactPlace ContactNumber Place AvailableItems ContactNumber ItemNumber ItemDescription Unit Rate ContactBills ContactNumber BillNumber BillDescription Date ContactClaims ContactN... View the full answer