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:

Cost of Goods Sold

The historical cost of products sold as reported in the income statement.

Gross Profit

The difference between revenue and the cost of goods sold, indicating the profitability of a company's core activities.

Goods Available for Sale

The total quantity of goods that a company has in its stock ready to sell at the end of a financial period.

Absorption Costing

An accounting method that includes all manufacturing costs — direct materials, direct labor, and both variable and fixed overhead — in the cost of a product.