Re: Does Codd's view of a relational database differ from that ofDate&Darwin?[M.Gittens]

Marshall Spight wrote:
> Jan Hidders wrote:
>

>>It provides you with a higher-level data model.

Let me mention two small things. In the RM if you want to add a one-to-many relationship between two entities you have to extend one of the relations with a foreign key. If there are more than one candidate key you have to choose one of them. In an ER model you don't have to make such a choice, you simply indicate that there is a relationship.

Another small thing is updating primary keys. If a primary key has accidentally been entered wrong and you want to fix that with an update then it is usually not possible to simply update it, and the problem gets even worse if it is also refered to by foreign keys. In an ER model this is a non-problem.

>>Moreover, it has slowly
>>begun to dawn on people that the big advantages of the relational model
>>(simplicity, formal basis, data-independence, declarativity, etc.) are
>>actually also easiliy achieved in other data models.

I basically have the FDM data model in mind, but modernized a bit.

• Jan Hidders