There's a semantic difference. So far as I'm aware neither is a term of logic, so there can't...

Michael L John (4/28/2011)

---

Unfortunatly, I am seeing this practice more and more, except it's XML. Create a table, give it a name and an identity as an artficial key,...

GSquared (4/27/2011)

---

I guess my problem is that I don't have strong feelings about normalization one way or the other. I go with what's most practical for the problem I'm...

Peter Trast (4/27/2011)

---

OK, here is the fix for hardcore 1NF fans. One column, long text datatype (pick your fav) like concatenating an entire name if there is no use for...

Steve Jones - SSC Editor (4/27/2011)

---

I may be wrong, and I'll admit that. However the "use" of the data in terms of when/how you might call someone is debatable. The...

calvo (4/27/2011)

---

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...

Nice simple question, and reasonable answer.

One thing I didn't like in the explanation though was "though a primary key is part of the definition according to Chris Date", as if...

Steven993 (4/28/2011)

---

Read the entire post. There is domain definition in it.

Of course there was debate about the word "atomicity".

Is the VARHAR(5) string 'Hello' atomic ?

Can we decompose it in 'H',...

Steven993 (4/28/2011)

---

Well he has told you plainly and clearly, even down to the page number, but you appear to be too lazy to...

David Burrows (4/28/2011)

---

Steven993 (4/27/2011)

---

My example, you mean AddressLine table ? It's is not a...

David Portas (4/27/2011)

---

GSquared (4/27/2011)

---

On the circular reason point, saying "all relations are in 1NF, thus this is automatically in 1NF because we say it's a relation", is circular reasoning. ...

Tht's a disgraceful statement. You owe Gus an apology.

Steven993

---

Example of 1NF definition, from the only book I have...

David Portas (4/27/2011)

---

Codd states that nulls cause incorrect results in several places and he gives examples to prove it. Here's what he says in "The Relational Model for Database Management...

Yes, MD5...

Grant Fritchey (4/26/2011)

---

I used to work for a medical software company. it was...