Viewing 15 posts - 16 through 30 (of 30 total)
David Burrows (4/27/2011)
April 27, 2011 at 8:21 am
....
You have never read 1NF definition or even the Relation definition.
Example of 1NF definition, from the only book I have right now :
Database Systems - The complete Book Second Edition...
April 27, 2011 at 7:35 am
GSquared (4/26/2011)
I'm not quoting me. I'm quoting Date. If you really think he doesn't know what 1NF is, that's another issue entirely...
........ I can't believe it...
YOU are the...
April 26, 2011 at 2:23 pm
Obviously you don't know what a predicate is, or you'r just ignoring predicate variables. Nice 😉
You'r calling Occam's razor on the number of tables ? What a joke... Why are...
April 26, 2011 at 12:55 pm
Well we have a problem here.
I think you didn't understand what 1NF is.
Let's take data example to make it clear !!
What you are citing are the properties a TABLE must...
April 26, 2011 at 7:11 am
tabraham 36699 (4/26/2011)
Ideally, Chris Date's vision of an OO-Relational DB will emerge, with, among other things, a formally defined range for each attribute and an explicit value representing UNKNOWN, with...
April 26, 2011 at 6:10 am
@tom.Thomson
Tom.Thomson (4/25/2011)
For supplier S# the information we have about his name is indicated by SNAME and the...
April 26, 2011 at 4:00 am
What the ??
What is violating 1NF, and what is your definition of 1NF ?
I give up, good luck guys 😉
April 25, 2011 at 3:24 pm
@tom.Thomson
When you write Dace, I guess you mean Date.
I actually own almost every books Chris published. He wrote hundred of pages on NULL topic.
Maybe I'll come later and...
April 24, 2011 at 4:22 pm
Tom.Thomson (4/24/2011)
Perhaps because Dace had to pervert them to get them to fit his strange world view? :hehe::-P
I don't know Dace's work, but maybe you could explain it for me,...
April 24, 2011 at 12:06 pm
Tom.Thomson (4/24/2011)
April 24, 2011 at 10:48 am
I have no issues with you address solution but it requires an extra join and it can degrade performance.
If the objective is perfect normalization then go with an extra table...
April 23, 2011 at 4:10 pm
Tom.Thomson (3/7/2011)
if A is nullable, there can be no such functional dependency
My demonstration was maybe too short, but this was my point.
NULL impacts nomalization...
Tom.Thomson (3/7/2011)
March 7, 2011 at 11:39 am
Tom.Thomson (1/26/2011)
David Portas (1/22/2010)
March 7, 2011 at 1:47 am
Viewing 15 posts - 16 through 30 (of 30 total)