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
/ 
