11 Important Database designing rules

最新推荐文章于 2025-11-27 13:57:04 发布

转载最新推荐文章于 2025-11-27 13:57:04 发布 · 114 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/shuay/blog/53844

文章标签：

#数据库

本文作者结合个人经验和项目实践总结了11条实用的数据库设计规则，旨在帮助开发者们跳出仅依赖三范式的局限，更好地应对实际项目中遇到的问题。文章深入浅出地解释了每一条规则的重要性，并提供了具体的应用场景。

为什么80%的码农都做不了架构师？>>>

http://www.c-sharpcorner.com/UploadFile/shivprasadk/11-important-database-designing-rules/#Rule6:-Watchforpartialdependencies.

Introduction

Before you start reading this article let me confirm that I am not a guru in database designing. The below 11 points which are listed are points which I have learnt via projects, my own experiences and my own reading. I personally think it has helped me a lot when it comes to DB designing. Any criticism welcome.

The reason why I am writing a full blown article is, when developers sit for designing a database they tend to follow the three normal forms like a silver bullet. They tend to think normalization is the only way of designing. Due this mind set they sometimes hit road blocks as the project moves ahead.

In case you are new to normalization, then click and see 3 normal forms in action which explains all three normal forms step by step.

Said and done normalization rules are important guidelines but taking them as a mark on stone is calling for troubles. Below are my own 11 rules which I remember on the top head while doing DB design.

转载于:https://my.oschina.net/shuay/blog/53844