The question is more simple than what it looks. There are many use cases that are well known and people have put a lot of thought into them. For example: Audit trailing, login users, and so on. We are looking for a good resource site that present the DB design for those common use cases.
views:
162answers:
2
+2
A:
Check out
There are over 500 data models available for free there. It's not hard to convert them into a working database. For some of them, if you contact the webmaster, they will send you a working MS Access application with a built in database.
Even if you don't use Access this could serve as a prototype.
Walter Mitty
2009-08-11 00:21:45
Hello Walter: Thanks for your reply. I think you are making reference to this page: http://databaseanswers.org/data_models/index.htm, Thanks for the lead again.
Geo
2009-08-23 18:49:24
Yes. I always point people at the portal.
Walter Mitty
2009-08-24 04:52:56
A:
Try The Data Model Resource Book by Len Silverston. It has 3 volumes and not only shows but also explains the usual use cases.
Leigh Pyle
2009-10-07 09:08:11