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 Wednesday, April 27, 2011 6:55 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 6:27 AM
Points: 1,378, Visits: 454
Basic but very needed fundamental question
Post #1099380
Posted Wednesday, April 27, 2011 7:33 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
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?


I am not the db design guru, but from my understanding, that would be incorrect. The "use" of that property is different, but both home and mobile are the same type of property in relation to the entity.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1099418
Posted Wednesday, April 27, 2011 8:14 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, November 04, 2013 4:02 PM
Points: 659, Visits: 474
Good question.
Post #1099485
Posted Wednesday, April 27, 2011 8:20 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232, Visits: 1,046
Nice question Steve.
We never have to guess or debate an answer with you.
Post #1099496
Posted Wednesday, April 27, 2011 8:24 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
SanDroid (4/27/2011)
Nice question Steve.
We never have to guess or debate an answer with you.


Ha! I've made plenty of mistakes and had some sketchy questions.

I am trying to get better and have learned to write questions that probe a bit without trying to trick someone.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1099500
Posted Wednesday, April 27, 2011 8:31 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232, Visits: 1,046
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?

No, but you could normalize the Phone number type.
Defining a table to store the repeating types of phone numbers.

You could start by adding another Table called Phone_Number_Types with an Id coulumn.
Then you could use a lookup table to match the repeating Phone_Numbers to the repeating Phone_Number_Types for each Employee.
Post #1099511
Posted Wednesday, April 27, 2011 8:36 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232, Visits: 1,046
Steve Jones - SSC Editor (4/27/2011)
I am trying to get better and have learned to write questions that probe a bit without trying to trick someone.


"without trying to trick someone"
That says it all.
If you are going to tell 70% or more of a community that they are wrong, you should never try to trick them.
Doing this could activate the kind of basic defense mechanisms that are counter productive to learning.
Post #1099517
Posted Wednesday, April 27, 2011 9:25 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 5:49 PM
Points: 2,263, Visits: 3,758
Nice question, testing our basics.

Mohammed Moinudheen
Post #1099577
Posted Wednesday, April 27, 2011 9:26 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, March 10, 2014 3:52 PM
Points: 1,380, Visits: 2,681
Excellent question, Thanks!

---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
Post #1099578
Posted Wednesday, April 27, 2011 10:20 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 8:50 AM
Points: 2,163, Visits: 2,184
Nice question, thanks!
Post #1099620
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse