Where to find practical well-designed database schema examples to learn from?

Database

Database Problem Overview

I am new to database schema design and I want to learn more about how a well-designed database scheme is implemented in the real world?

Is there any places to find those schemes? Or is there any book focused on explanation over examples.

Database Solutions

Solution 1 - Database

DatabaseAnswers.org (unfortunately now defunct) but well-preserved in the Wayback Machine is a great source of example database schemas.

I can also recommend Beginning Database Design, published by Apress. I own this book and can confirm that it is of high quality. The book looks at a number of real world scenarios and explains the impact a certain design decision could have on the way the database works and the quality of the data and its output.

Finally I would advise building some small databases (E.G. contact management, Task list etc). Start by specifying some basic requirements and create some tables and queries. You WILL make some mistakes which is the best way of learning.

Solution 2 - Database

Here is a nice library of schemas to browse through.
http://www.databaseanswers.org/data_models

Categories
Recommended Database Solutions

Previous Solution:

c# open file, path starting with %userprofile%

C#File

Next Solution:

C++11 does not deduce type when std::function or lambda functions are involved

C++TemplatesLambdaC++11

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionsteveyangView Question on Stackoverflow
Solution 1 - DatabaseBenjamin GaleView Answer on Stackoverflow
Solution 2 - DatabaseblackappyView Answer on Stackoverflow