关系数据库规范化设计理论探析  

Primary Analyses on the Relational Database Normalization Theory

作　　者：贾玲[1] 

机构地区：[1]武警学院基础部,河北廊坊065000

出　　处：《武警学院学报》2007年第12期87-89,共3页Journal of the Armed Police Academy

摘　　要：数据库设计是数据库应用领域的主要研究课题,是继需求分析后的一个非常重要的环节。关系数据库设计的重点难点就是数据库的规范化理论,必须深入透彻的理解规范化理论,才能设计出一个高质量的数据库。根据数据库设计理论和应用要求,通过通俗易懂的实例详尽地说明了1NF、2NF、3NF和BCNF在数据库设计中的具体操作步骤和方法,对于数据库设计有重要的指导意义。The design of database structure is a mostly research topic of a database application field, which is a very important segment after requirement analyses. The relational database normalization theory is the most important and difficult contents of database design, Which we must prehend thoroughly that we can design a high quality database. According to the database theory and practical requirement, the paper illuminates the operation steps and ways of database design with 1NF 2NF 3NF and BCNF in a simple and understandable way. It is an important guidance to design a database.

关 键 词：关系数据库规范化理论 范式 1NF 2NF 3NF BCNF 

分 类 号：TP311.132.3[自动化与计算机技术—计算机软件与理论]