|
Posted by Ed Murphy on 11/23/07 17:20
Fritz Franz wrote:
> OK, I understand. Yes, you ar right, the design of DB is not normalized
> correctly. But for some reasons we decided to do it this way.
Please post the specific reasons, so that we can specifically
debunk them.
> It is not that
> important to have the FK defined in the DB, the applications will ensure the
> integrity of the data.
Celko is right, this will fail as soon as one of the application
programmers makes a mistake. DRI should be enforced directly in
the DB. More complex business logic may be enforced at the
application layer, but you should still look for ways to
centralize it.
[Back to original message]
|