实例分析关系模式的规范化与反规范化

规范化是减少数据冗余、设计合理的数据库的重要手段,是数据库课程的重点。由于涉及到关系数学理论,仅做理论讲解,很难使学生理解,尤其是高职层次的学生。本文通过一个关系模式不断分解、规范化的实例,采用逐步深入的方法解决数据库设计中存在的问题,使学生既掌握数据库设计的技能,也加深对函数依赖、规范化理论的理解。

Example Analysis of Normalization and De-normalization of Relational Modal

Normalization is an important means of reducing data redundancy and designing rational database.It is the key point of the database course.As the relational mathematics theory is concerned, it is difficult for students, especially those in the higher vocational schools to understand if the theory is explained simply.This paper solves step by step the problems of database designing by an example of continuous dissolution and normalization of a relational modal.It enables the students to possess the knowledge of designing database and deepen their understanding of functional dependency and normalization theory.