What are the design criteria for primary keys?

by

The criteria for consideration of a primary key are:

  • Uniqueness
  • Irreducibility (no subset of the key uniquely identifies a row in the table)
  • Simplicity (so that relational representation & manipulation can be simpler)
  • Stability (should not be altered frequently)
  • Familiarity (meaningful to the user)

More Related Contents:

  1. What’s the difference between identifying and non-identifying relationships?
  2. Can I have multiple primary keys in a single table?
  3. What’s wrong with foreign keys?
  4. Surrogate vs. natural/business keys [closed]
  5. What is the best design for a database table that can be owned by two different resources, and therefore needs two different foreign keys? [closed]
  6. Oracle (ORA-02270) : no matching unique or primary key for this column-list error
  7. Is it fine to have foreign key as primary key?
  8. What is the most efficient way to store tags in a database?
  9. Which is a good design for a database table that can be owned by two different resources, and therefore needs two different foreign keys? [closed]
  10. Alternatives to Entity-Attribute-Value (EAV)?
  11. Should OLAP databases be denormalized for read performance? [closed]
  12. Is storing a delimited list in a database column really that bad?
  13. Should each and every table have a primary key?
  14. Database, Table and Column Naming Conventions? [closed]
  15. What are the performance improvement of Sequential Guid over standard Guid? [closed]
  16. Normalization: What does “repeating groups” mean?
  17. Are soft deletes a good idea? [duplicate]
  18. Relational table naming convention [closed]
  19. Why use a 1-to-1 relationship in database design?
  20. What is the optimal length for an email address in a database?
  21. Are foreign keys really necessary in a database design?
  22. GUID vs INT IDENTITY [duplicate]
  23. Database optimization orders
  24. In what way does denormalization improve database performance?
  25. have address columns in each table or an address table that is referenced by the other tables?
  26. Minimum no of tables that exists after decomposing relation R into 1NF?
  27. Limit an sqlite Table’s Maximum Number of Rows
  28. When we need to use 1-to-1 relationship in database design?
  29. What’s the better database design: more tables or more columns?
  30. Best beginner resources for understanding the EAV database model? [closed]

Leave a Comment