Shoutbox

Database Normalisation - Printable Version

-Shoutbox (https://shoutbox.menthix.net)
+-- Forum: MsgHelp Archive (/forumdisplay.php?fid=58)
+--- Forum: Skype & Technology (/forumdisplay.php?fid=9)
+---- Forum: Tech Talk (/forumdisplay.php?fid=17)
+----- Thread: Database Normalisation (/showthread.php?tid=56284)
Database Normalisation by mwe99 on 02-27-2006 at 11:33 AM

Anyone good at it? Cos im stuck :P

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?


RE: Database Normalisation by RaceProUK on 02-27-2006 at 12:13 PM

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.
RE: Database Normalisation by mwe99 on 02-27-2006 at 12:31 PM

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
RE: Database Normalisation by RaceProUK on 02-27-2006 at 06:59 PM

Fair enough ;)

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