Explain Why Using an Employee's Last Name as the Primary

question 56

Essay

Explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

---

Definitions:

Supergroup

In biology, a high-level taxonomic rank above the group level, often used in the classification of life forms that share common evolutionary traits.

Green Algae

Photosynthetic, aquatic organisms in the Chlorophyta division, considered the ancestors of land plants.

Representative Clade

A group of organisms that consists of a common ancestor and all its lineal descendants, representing a single branch on the tree of life.

Supergroup

A high-level taxonomic rank in the classification of organisms, above kingdom, proposed to accommodate the phylogenetic relationships.