What are the Characteristics of a Good Primary Key?
A good primary key should have the following characteristics:
Uniqueness: Each value should be unique across the table. Non-nullable: Each record must have a primary key value. Immutability: The value of the primary key should not change. Minimality: It should consist of the minimum number of fields necessary to guarantee uniqueness.