Re: MySql vs. Oracle

No question about it. Without foreign keys, relationships cannot be expressed
in a relational framework. A DBMS may not implement foreign keys explicitly,
in which case the programmer can still use columns as foreign keys, just by including the columns that are implicit foreign keys in the join conditions of the WHERE
clause.

But then, referential integrity checking by the DBMS isn't possible, because the DBMS doesn't know which columns are foreign keys.

And one of Codd's original twelve commandments states that the DBMS must be able to enforce referential integrity.

Bob Badour wrote in message <8stp76$1rs$1_at_cougar.golden.net>...
>While I would agree that most triggers and stored procedures are wasteful
>ways of doing things, I think that foreign keys and nesting are essential
 in
>a database management system.
>
>
>
Received on Sun Oct 22 2000 - 19:52:57 CEST