Elements of a Primary Key

  Previous section   Next section
  • It cannot be a multipart field.

  • It must contain unique values.

  • It cannot contain null values.

  • Its value cannot cause a breach of the organization's security or privacy rules.

  • Its value is not optional in whole or in part.

  • It comprises a minimum number of fields necessary to define uniqueness.

  • Its values must uniquely and exclusively identify each record in the table.

  • Its value must exclusively identify the value of each field within a given record.

  • Its value can be modified only in rare or extreme cases.

Rules for Establishing a Primary Key

  • Each table must have oneand only oneprimary key.

  • Each primary key within the database must be uniqueno two tables should have the same primary key unless one of them is a subset table.


Part II: The Design Process