quote:

---

But I think you're mistakenly mixing data atomicity into Codd's Information Rule. I didn't check your sources, but decomposition is a function of schema design (first normal form) and not something which can or should be enforced by a DBMS.

---

Yes, you're right.

It is not mentioned in Rule #1. Looking to fix the article.

quote:

---

An RDBMS can be designed to support one of Codd's rules, but it doesn't necessarily prevent one from ignorantly breaking that rule; e.g. one can also create a table without a primary key in SQL Server, so the database is therefore not relational, but that cannot be blamed on SQL Server.

---

How do you say?

'Only a poor worksman blames his tool'?

Frank

http://www.insidesql.de

http://www.familienzirkus.de