Re: Table Names: Singular or Plural?

Some Thoughts:

Enforcement of business rules:
powerful rdbms like Oracle offer many possibilities to enforce business rules via declarative means. This way the path from logical to physical design becomes way shorter. I tend to keep the gap between logical and physical model small, so the physical datamodel remains readable in terms of business rules.

evolving datamodel:
systems, which grow over years tend to be modelled only on/at (?) the physical side. I prefer to apply some "logical modelling" practises to keep the model clean and readable. If you apply enhancements in the way the typical developer will do it, the data model will quickly become un-understandable.

educaion of developers:
many developers lack data modelling experience. When confronting them with a physical model not too far from the logical model, chances are better, that they gain by time a better feeling for logical modelling conerns.

Please excuse my clumpsy english :-)

regards
Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Sat Apr 06 2002 - 10:30:42 CEST