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

question 9

Essay

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

---

Definitions:

Vesting Date

The date on which an employee gains the right to receive benefits or stock options from an employer's plan.

Share-based Payment

A transaction in which the entity acquires goods or services by issuing shares of its equity or share options rather than with cash or other assets.

AASB 2

An Australian Accounting Standards Board standard that specifies the accounting requirements for share-based payment transactions.

Option Pricing Models

Mathematical models used to determine the fair value of options, considering various factors such as the underlying asset price, strike price, volatility, and time to expiration.