Tom.Thomson (5/10/2011)

---

Well, presumably one of the applicable values that a-null could be is 0, and it surely is not true that 0/0 delivers 0 (it should deliver something like "error:...

Eric M Russell (6/20/2011)

---

That's strange. In my observable universe, SQL Server and Oracle support declarative data integrity, meet business needs, EAV tables exist only within the realm of niche applications,...

Eric M Russell (6/14/2011)

---

MS SQL and Oracle are first and formost relational database engines. If Microsoft thinks NoSQL datbase solutions are a market worth breaking into, then I'd expect...

Belatedly I realised that normalization isn't entirely defeated by Codd tables without keys. Given the definition of JDs already discussed, the Codd table T(a) would satisfy the JD * (a,{})...

Tom.Thomson (4/27/2011)

---

Ted Codd

---

There are two options:

1. warn users not to use tautologies as conditions in their...

I shouldn't...

Tom, thank you very much for your thoughtful and thorough response to my post. For me you have made this thread worth continuing. I will mull over your reply and...

GSquared (4/27/2011)

---

I'm not asking you to define "relational", I'm asking you to defend the proposition that "rows that have a value in them which indicates the order of the rows...

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. It's not...

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

GSquared (4/27/2011)

---

As...

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

David Burrows (4/27/2011)

---

David & Steven,

If, as you state, the DDL in question does conform to Date's 1NF as in 'There's no top-to-bottom ordering to the rows' can you post example...

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, it's right...

Tom.Thomson (4/26/2011)

---

David Portas (4/26/2011)

---

Now you are being silly. No one said nulls are "evil" or objected to them for "religious" or dogmatic reasons. The objections are about the practical disadvantages...

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 authority, then...