你如何教数据库规范化?

问题描述:

数据库规范化的步骤和指导是什么?如果给了一群具有良好的计算机和逻辑技能的人,那么你如何向他们解释如何规范化数据库设计?您的思考过程是获取属性列表(字段),并将该列表变成1NF中的数据库? 2NF? 3NF?

What are your steps and guidelines for database normalization? If given a bunch of people with good computer and logic skills, how do you explain to them how to normalize a database design? What is your thought process for taking a list of attributes (fields) and turning that list into a database in 1NF? 2NF? 3NF?

查看以下资源:

  • 3 Normal Forms - a tutorial
  • Database normalization tutorial

或让你的人成为学习数据库设计的最好的书籍:

or get your folks the best book I've found for learning database design:

数据库设计(R):关系数据库设计的实践指南(第2版​​)作者:Mike Hernandez

Database Design for Mere Mortals(R): A Hands-On Guide to Relational Database Design (2nd Edition) by Mike Hernandez

>