Given the Tables

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

D)
PRODUCT (ProductID,Description,Cost,SupplierID) SUPPLIER (SupplierID,ContactName,PhoneNumber) ,
E)
PRODUCT (ProductID,Description,Cost) SUPPLIER (SupplierID,ContactName,PhoneNumber)
PRODUCT_SUPPLIER ( ProductID , SupplierID) ,.

Correct Answer:

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Access For Free