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

Question

Quizplus · Accepted Answer

The purchases table will have two foreign keys (one for the vendor table and one for the inventory table), but it will not have a foreign key for the purchasing agent table. The purchasing agent table may have a compound primary key if necessary, and the database may need a junction table to handle many-to-many relationships between tables.

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