Question: 1. What is an entity cluster, and what advantages are derived from its use?
2. What primary key characteristics are considered desirable? Explain why each characteristic is considered desirable.
3. Under what circumstances are composite primary keys appropriate?
4. What is a surrogate primary key, and when would you use one?