Now you ask , simpler than it appears. You will find many use cases which are well-known the ones have put lots of thought into them. For instance: Audit trailing, login customers, and so forth. We're searching for a great resource site that present the DB design for individuals common use cases.
Take a look at
You will find over 500 data models readily available for free there. You can convert them right into a working database. For a number of them, should you contact the website owner, they'll give back a functional MS Access application having a built-in database.
Even when you do not use Access this could help as a prototype.
Try The Data Model Resource Book by Len Silverston. It's 3 volumes and never only shows but additionally describes the typical use cases.