Yes, I do know these things. You don't know debate, logic, or how to...

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

Steven993 (4/27/2011)

---

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

David...

David Portas (4/27/2011)

---

You think that people aren't going to be insulted when you say they are "psychotic" if they hold a particular point of...

Would you be happy if I'd put quotes around the word "tuples", implying that, in this case, these "rows"...

As for "all relations are by definition in 1NF", honestly, all orthodox relations are, by definition, in at least 5NF. Otherwise, they aren't proper relations, now are they?

It's circular...

David Portas (4/27/2011)

---

GSquared (4/27/2011)

---

So what you're saying is that the rule about rows not having a specified order was written just to take up space. Since it's physically impossible...

I've had to use this kind of table before, and something I've found valuable is a column that indicates which kind of data a given row will hold. You...

Below a threshhold number of rows in a table, the query optimizer doesn't even check for indexes, it just scans the table. Figuring out which index to use would...

Steven993 (4/27/2011)

---

....

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

David Portas (4/27/2011)

---

GSquared (4/27/2011)

---

I say the rows in that table are "ordered" because there's a column that specifically determines the order of the rows. Look at the table design,...

I'm saving mine up so I can get either the secret decoder ring, or the "run faster" button for my code. I'm not sure which yet.

The original requirement was if there's more than one row, do X. If Exists will test if there is at least one row. Are you sure that's what's...

You're welcome.

David Portas (4/26/2011)

---

GSquared (4/26/2011)

---

My objection to this whole debate is the introduction of "authority" into it. My whole point is that citing authority is silly. Yes, I cited...