在哪里可以找到设计良好的实用数据库模式示例以供学习？ [英] Where to find practical well-designed database schema examples to learn from?

问题描述

我是数据库架构设计的新手，我想了解更多有关如何在现实世界中实现精心设计的数据库方案的信息？

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.

推荐答案

这是示例数据库架构的重要来源。

This is a great source of example database schema's.

我也可以推荐开始数据库设计，由Apress发布。我拥有这本书，可以确认它是高质量的。这本书着眼于多种现实情况，并解释了某些设计决策可能对数据库的工作方式以及数据质量及其输出产生的影响。

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.

最后，我建议您构建一些小型数据库（例如，EG联系人管理，任务列表等）。首先指定一些基本要求，然后创建一些表和查询。您会犯一些错误，这是最好的学习方法。

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.

这篇关于在哪里可以找到设计良好的实用数据库模式示例以供学习？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！