Social Security Number and Employee ID Are Candidate Keys for a Table

question 103

True/False

Social Security Number and Employee ID are candidate keys for a table. An organization chooses Employee ID as the primary key. Social Security Number is considered an alternate key.

---

Definitions:

Optimal Order Size

The ideal quantity of inventory to order that minimizes the total costs associated with ordering, carrying, and stockouts.

Annual Inventory Cost

The total expense associated with holding and managing inventory over the course of a year, including costs of storage, insurance, and loss due to decay.

Order Replenish

refers to the process of restocking goods or materials to ensure sufficient inventory levels are maintained, often in response to customer orders.

Ordering Cost

Expenses associated with placing and receiving orders for goods or supplies, including administrative and staffing costs.