关系数据库设计中主键的定义分析  

The Definition Analysis of the Primary Key in Relational Database Design

作　　者：刘奕[1] 

机构地区：[1]抚顺职业技术学院,辽宁抚顺113122

出　　处：《辽宁高职学报》2014年第6期92-93,共2页Journal of Liaoning Higher Vocational

摘　　要：在关系数据库中,主关键字定义起着重要作用。为避免数据库设计中出现错误,主键定义必须遵守相关守则,即主键必须唯一识别每一记录,且主键的值不能为空。因此,在实际工作中,代理键比自然键更适合定义主键。这一简单的方法为程序开发提供了坚固的、稳定的、灵活的基础。In relational database, the primary key definition plays an important role. To avoid errors in the design of database, the primary key definition must abide by the related rules, namely the primary key must be unique to identify each record, and the primary key value can not be empty. Therefore, in practice, a surrogate key is more suitable to define the primary key than a natural key. The simple method provides a solid, stable, and flexible foundation for program development.

关 键 词：关系数据库 主键 自然键 代理键 

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