This must be FAQ. In 2003 someone asked this question very aptly.
http://groups.google.com/group/maili... erns&rnum=1&

However, the answer refers to this book:

'The Data Model Resource Book: A Library of Universal Data Models for
All Enterprises' from Wiley

which sounds very domain specific.

I am looking out for generic solutions like history, classification
etc. of entities and the constraints, stored procedures and triggers it
demands.

Can someone help with some literature?

TIA,
-Bhushit

Bhushit Joshipura wrote:
Not completely sure I understood your requirements but you can check
books by David C. Hay especially Data Model Patterns: Conventions of
Thought.
I've collected some resources I liked for Logical modelling in
http://www.gplivna.eu/papers/data_wa...#_Toc141543907

Gints Plivna
http://www.gplivna.eu

Gints Plivna wrote:
Yea and BTW you are messing a bit two concepts entities which are part
of logical modelling and constraints, stored procedures and triggers
which are part of physical modelling. If you are thinking about
physical modelling i.e. how to implement tables, constraints, stored
procedures and triggers then it is very DB and your task specific
question and I don't think one can do any "overall best practices"
because
1) architecture and implementation of various DB are completely
different and one cannot mechanically use the same constraints,
procedures and triggers in different DBs and
2) requirements needing above mentioned constructions can be sooooo
different that it is hard to find a "one size fits all" solution.
Anyway if you are thinking about physical design then look at vendor
oriented books for example for Oracle you can look for Thomas Kyte
books, don't know about other vendors. And even then it will be your
task to transform business requirements and logical model into physical
model, books can only help to do it more or less in a right way.

Gints Plivna
http://www.gplivna.eu