Shoutbox

Anyone good at it? Cos im stuck

code:

---

1NF
Order Number
Customer Number
Customer
Street
District
Town
Postcode
Contact Number
-
Device Number
Device Name/Description
Unit Price
Quantity Ordered
Description
Device Price
-
Component Number
Component Type
Component Name
Component Price   

---

Any help where i go to normalise to 2NF?

Remember:
1NF: They Key
2NF: The Whole Key
3NF: Nothing But The Key

To convert to 2NF, where you have Order Number and Customer Number, move Order Number to a separate table that links to Customer Number.

code:

---

2NF
Order Number
Customer Number
-
Customer Number
Customer
Street
District
Town
Postcode
Contact Number
-
Device Number
Device Name/Description
Unit Price
Quantity Ordered
Description
Device Price
-
Component Number
Component Type
Component Name
Component Price   

---

Edit: Though I must say your table design lacks full and thorough thought.

quote:

---

Originally posted by raceprouk
Remember:
1NF: They Key
2NF: The Whole Key
3NF: Nothing But The Key

To convert to 2NF, where you have Order Number and Customer Number, move Order Number to a separate table that links to Customer Number.

code:

---

2NF
Order Number
Customer Number
-
Customer Number
Customer
Street
District
Town
Postcode
Contact Number
-
Device Number
Device Name/Description
Unit Price
Quantity Ordered
Description
Device Price
-
Component Number
Component Type
Component Name
Component Price   

---

Edit: Though I must say your table design lacks full and thorough thought.

---

thanks , nah it was just a quick post lol

Fair enough

Edit: I assume you know what the normal forms are?