Elements of a Candidate Key

   
  • 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.


   
Top


Database Design for Mere Mortals[c] A Hands-On Guide to Relational Database Design
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design
ISBN: 0201694719
EAN: 2147483647
Year: 2002
Pages: 203

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net