database 在哪里可以找到实用的精心设计的数据库模式示例以供学习？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/9993842/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Where to find practical well-designed database schema examples to learn from?
提问by steveyang
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.
有什么地方可以找到这些方案吗？或者有没有什么书侧重于例子的解释。
回答by Benjamin Gale
Thisis a great source of example database schema's.
这是示例数据库模式的重要来源。
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.
我还可以推荐由 Apress 出版的Beginning Database Design。我拥有这本书，可以确认它是高质量的。这本书着眼于许多现实世界的场景，并解释了某个设计决策可能对数据库的工作方式以及数据及其输出的质量产生的影响。
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.
最后，我建议建立一些小型数据库（EG 联系人管理、任务列表等）。首先指定一些基本要求并创建一些表和查询。你会犯一些错误，这是最好的学习方式。
回答by blackappy
Here is a nice library of schemas to browse through.
http://www.databaseanswers.org/data_models
这里有一个不错的模式库可供浏览。
http://www.databaseanswers.org/data_models
