A Relational Database Contains Four Tables: Vendor, Inventory, Purchasing Agent

question 11

Multiple Choice

A relational database contains four tables: vendor, inventory, purchasing agent and purchases. Which of the following statements is least true?

• A) The purchases table will have two foreign keys.
• B) The purchases table will have three foreign keys.
• C) The purchasing agent table will have a compound primary key.
• D) The database will also need at least one junction table.

---

Definitions:

Warehousing Space

The area available for the storage of goods in a warehouse, crucial for inventory management and logistics.

Supply Chain Design

The process of structuring a supply chain to meet the goals of cost, efficiency, delivery, and flexibility.

Significant Investments

involves allocating substantial financial resources into a project, asset, or venture with the expectation of achieving considerable returns or benefits.

Warehousing Space

The amount of physical area available for storing goods within a warehouse or distribution center, typically measured in square feet or meters.