Question

Which criteria is correct for choosing a primary key

Answer 1

Answer:

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)

Answer 2

Answer:

Usually the following criteria is con considered

1. Uniqueness

2. irreduciblility

3. Simplicity

4. Stability

5. Familiarity