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 correct placement of foreign key is to add SupplierID field in the Product Table to make it as the foreign key and reference it to the primary key SupplierID field in the Supplier Table. Therefore, the best choice is E which has the correct placement of foreign keys.

Given the Tables PRODUCT (ProductID, Description, Cost)