这个面试问题该怎么回答呢？
由于我有 1-2 年的经验，我应该对这个面试问题说什么......
标准化有哪些类型？ 我应该说所有正常形式还是什么？
As i am in between 1-2 years experience what should i say to this interview question....
What are the types of Normalization?
Should i say all the normal forms or what?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
对于面试来说这个问题太宽泛了——它可以写满一本小书。我只会记住关于前 3 个范式的几个关键点（4 和 5 需要额外学分）。 这是对它们的一个相当不错的总结。
如果我采访你并提出这个问题，我最想听到的是大多数数据库设计者都力求至少达到 3NF，但应该能够因为 X 原因而偏离这一点。知道何时偏离规范化以及为什么偏离规范化比了解定义更重要、更能说明问题。
Way too broad of a question for an interview - it could fill a small book. I would simply remember a few key points about the first 3 normal forms (4 and 5 for extra credit). Here's a somewhat decent summary of them.
If I were interviewing you, and asked the question, I would want to hear above anything else that most db designers strive for at least 3NF but should be able to deviate from that for X reasons. Knowing when to stray from normalization and why is way more important and telling than knowing the definitions.
了解范式的正式定义并能够给出一些现实世界的例子将是这个问题的一个很好的答案。
Knowing the formal definitions of the normal forms and being able to give some real world examples would be an excellent answer to the question.
FWIW，我认为这是一个愚蠢的问题，除非是直接采访来自大学的人，因为除了理论之外没有太多可问的。他们在教授标准化时教给我的第一件事是“我们现在将解释这些[标准化]步骤，但请记住，一旦你理解了它，你就不会用范式来思考，因为 3NF 会自然而然地出现”。他们是对的。
更好的面试问题是“这个模式有什么问题？”和“为以下数据设计一个模式......”。因为它们展示了基本原理的应用、实用知识。
FWIW, I think it's a silly question to ask except when interviewing people straight from a University where there's not much to ask for but theory. One of the 1st things they taught me when they taught normalization was "we'll explain these [normalization] steps now, but keep in mind that once you understand it, you won't think in terms of normal forms because 3NF will come naturally". And they were right.
Much better interview questions would be "what's wrong with this schema?" and "design a schema for the following data...". because they show applied, practiical knowledge of the underlying principles.