Has this normalisation from 1NF to 2NF and finally to 3NF been completed correct

Question

Has this normalisation from 1NF to 2NF and finally to 3NF been completed correctly?

1st Normal Part Number Description Part Cost Supplier ID Supplier Name Supplier Part Number Supplier Cost 1234 Converter 134 1111 Smith 3412Y 98 1234 Converter 134 2222 Jones 4534 77 1234 Converter 134 4444 Able 123GB 66 1234 Converter 134 5555 Green X72B 89 4543 Battery 45 2222 Jones 55555G 12 4543 Battery 45 6666 Gabriel 33333R 22 7777 Cable 10 5555 Green 1111C 3 7777 Cable 10 2222 Jones 2222C 4 8787 Coil 18 7777 Avery 567C 10 9999 Terminal 11 7777 Avery T438 3 9999 Terminal 11 1111 Smith 898T 4 6757 Points 33 2222 Jones 888P 14 6757 Points 33 8888 Jordon 777P 17 2nd Normal Part Number Description Part Cost Supplier ID Supplier Name Supplier Part Number Supplier Cost Part Number 1234 Converter 134 1111 Smith 3412Y 98 1234 4543 Battery 45 2222 Jones 4534 77 1234 7777 Cable 10 4444 Able 123GB 66 1234 8787 Coil 18 5555 Green X72B 89 1234 9999 Terminal 11 2222 Jones 55555G 12 4543 6757 Points 33 6666 Gabriel 33333R 22 4543 5555 Green 1111C 3 7777 2222 Jones 2222C 4 7777 7777 Avery 567C 10 8787 7777 Avery T438 3 9999 1111 Smith 898T 4 9999 2222 Jones 888P 14 6757 8888 Jordon 777P 17 6757 3rd Normal Part Number Description Part Cost Supplier ID Supplier Name Supplier Part Number Supplier Cost 1234 Converter 134 1111 Smith 3412Y 98 4543 Battery 45 2222 Jones 4534 77 7777 Cable 10 4444 Able 123GB 66 8787 Coil 18 5555 Green X72B 89 9999 Terminal 11 6666 Gabriel 55555G 12 6757 Points 33 7777 Avery 33333R 22 8888 Jordon 1111C 3 2222C 4 567C 10 T438 3 898T 4 888P 14 777P 17

Explanation / Answer

is 2nd normal fform some attributes add more frrom which is dependen of the first normal form like part quantity,part name and last in 3nd normal form that is the nokey attributes is the depend on the netry in another key which is not reuires in 3nd normal form

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.