In the Following Shorthand Representation of a Database, the Underlined

question 4

Multiple Choice

In the following shorthand representation of a database, the underlined items are _____. INVOICES (INVOICE_NUM, INVOICE_DATE, CUST_ID)
INVOICE_LINE (INVOICE_NUM, ITEM_ID, QUANTITY, QUOTED_PRICE)
ITEM (ITEM_ID, DESCRIPTION, ON_HAND, CATEGORY, LOCATION, PRICE)

• A) relations
• B) entities
• C) nonkey columns
• D) primary keys

---

Definitions:

Economic Order Quantity

A formula used by companies to determine the optimal order size that minimizes the total costs associated with inventory.

Carrying Cost

The total cost of holding inventory, which includes storage, insurance, depreciation, spoilage, and opportunity cost.

Fixed Cost

Costs that do not change with the volume of production or level of activity within a certain range.

Economic Order Quantity

A formula used to determine the optimal order size that minimizes the total holding costs and ordering costs in inventory management.