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:

Twins

Biologically born individuals sharing the same womb simultaneously, often characterized by a close genetic and physical similarity.

Nominal Rate

The stated interest rate of a loan or investment, before adjusting for compounding or inflation.

Compounded Quarterly

Interest calculation method where interest is added to the principal sum at the end of every quarter, thus earning interest on interest.

Compounded Nominal

Refers to the calculation of interest added to the principal amount of a deposit or loan based on both the initial principal and the accumulated interest from previous periods.