Reply to Re: foreign keys - on which kind of keys do the base on?

Your name:

Reply:


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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация