Given the tables PRODUCT (ProductID,Description,Cost) SUPPLIER (SupplierID,ContactName,PhoneNumber) As shown in the figure below,which of the following would represent the correct placement of foreign keys? A) PRODUCT (ProductID, Description, Cost) SUPPLIER (SupplierID, ContactName, PhoneNumber) B) PRODUCT (ProductID, Description, Cost) SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductI C) PRODUCT (ProductID, Description, Cost, SupplierI D) SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductI D) PRODUCT (ProductID, Description, Cost, ContactName) SUPPLIER (SupplierID, ContactName, PhoneNumber) E) PRODUCT (ProductID, Description, Cost, SupplierI D) SUPPLIER (SupplierID, ContactName, PhoneNumber)

Question

Quizplus · Accepted Answer

The foreign key should be placed in the table where the relationship is one-to-many. In this case, each product can only come from one supplier (one-to-one relationship), but each supplier can supply multiple products (one-to-many relationship). Therefore, the SupplierID column should be added to the PRODUCT table as a foreign key referencing the SupplierID primary key column in the SUPPLIER table. Option E correctly places the foreign key in the PRODUCT table with the appropriate column name.

Given the Tables PRODUCT (ProductID,Description,Cost)