Solved

Given the Tables PRODUCT (ProductID,Description,Cost)

Question 1

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?
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)


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)

Correct Answer:

verifed

Verified

Related Questions