Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Normalization Expand / Collapse
Author
Message
Posted Tuesday, April 26, 2011 10:04 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:11 PM
Points: 31,368, Visits: 15,837
Comments posted to this topic are about the item Normalization






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1099184
Posted Tuesday, April 26, 2011 11:35 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 12:52 PM
Points: 13,636, Visits: 11,509
Aaah, back to basics
Thanks for the question!




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1099197
Posted Wednesday, April 27, 2011 12:17 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 15, 2014 9:37 AM
Points: 1,016, Visits: 1,052
Good Question
Srikant
Post #1099201
Posted Wednesday, April 27, 2011 12:30 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, December 8, 2014 6:07 AM
Points: 2,301, Visits: 1,436
going back to basics...ohh good remember the concepts from basic level...
Post #1099207
Posted Wednesday, April 27, 2011 1:11 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:49 AM
Points: 2,620, Visits: 2,467
Great question.
Post #1099217
Posted Wednesday, April 27, 2011 2:29 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 8:17 AM
Points: 558, Visits: 1,495
Basic but a great question. Some more like this would be fantastic.
Post #1099241
Posted Wednesday, April 27, 2011 3:42 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 6:24 AM
Points: 2,227, Visits: 1,776
Nice question and an interesting example. Would renaming the columns "Telephone 1" and "Telephone 2" to "Home Phone" and "Mobile Phone" mean that the table was then in 1NF?
Post #1099280
Posted Wednesday, April 27, 2011 3:53 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 2:54 PM
Points: 820, Visits: 2,135
Nice question and an interesting example. Would renaming the columns "Telephone 1" and "Telephone 2" to "Home Phone" and "Mobile Phone" mean that the table was then in 1NF?


I would say no, because there can be other categories of phone, such as Business Phone. The phone number may not be the best example because it could be said that "I only want two phone numbers", in which case an argument can be made for having the columns in the main table. Not a great argument, as the single column in a seperate table still makes queries and searches easier, and if someone would ever come a long and decide they want to track three phone numbers, the seperate table is much easier to implement, as it is already so.




Post #1099284
Posted Wednesday, April 27, 2011 5:54 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 6:20 AM
Points: 1,269, Visits: 3,635
Richard Warr (4/27/2011)
Nice question and an interesting example. Would renaming the columns "Telephone 1" and "Telephone 2" to "Home Phone" and "Mobile Phone" mean that the table was then in 1NF?

Great thought. It's funny how even a definition of something so basic, like 1NF, can still be fuzzy. If you're going by Chris Date's definition, his fourth rule states "Every row-and-column intersection contains exactly one value from the applicable domain (and nothing else)." Now, are all categories of telephone numbers (mobile, home, work etc.) considered of the same "domain"? Not to mention, adding a second telephone number field would mean one of them could possibly be null. Null fields, to some, is also a violation of 1NF.

... I think it's a trick question and I want extra points!


______________________________________________________________________________________________
Forum posting etiquette. Get your answers faster.
Post #1099344
Posted Wednesday, April 27, 2011 6:10 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:20 PM
Points: 18,064, Visits: 16,099
Excellent question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1099354
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse