Given the Tables PRODUCT (ProductID, Description, Cost)

Multiple Choice

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,ProductID)
C) PRODUCT (ProductID,Description,Cost,SupplierID) SUPPLIER (SupplierID,ContactName,PhoneNumber,ProductID)
D) PRODUCT (ProductID,Description,Cost,ContactName) SUPPLIER (SupplierID,ContactName,PhoneNumber)
E) PRODUCT (ProductID,Description,Cost,SupplierID) SUPPLIER (SupplierID,ContactName,PhoneNumber)