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

在关系数据库中,主关键字定义起着重要作用。为避免数据库设计中出现错误,主键定义必须遵守相关守则,即主键必须唯一识别每一记录,且主键的值不能为空。因此,在实际工作中,代理键比自然键更适合定义主键。这一简单的方法为程序开发提供了坚固的、稳定的、灵活的基础。

The Definition Analysis of the Primary Key in Relational Database Design

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.