Examlex

Solved

Given the Tables

question 19

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 (<u>ProductID</u>, Description, Cost)  SUPPLIER (<u>SupplierID</u>, ContactName, PhoneNumber)  As shown in the figure below,which of the following would represent the correct placement of foreign keys?   A)  PRODUCT <u>(ProductID</u>,Description,Cost)  SUPPLIER <u>(SupplierID</u>,ContactName,PhoneNumber)  B)  PRODUCT <u>(ProductID</u>,Description,Cost,SupplierID)  SUPPLIER .<u>(SupplierID</u>,ContactName,PhoneNumber,ProductID) . C)  PRODUCT <u>(ProductID</u>,Description,Cost)  SUPPLIER ,<u>(SupplierID</u>,ContactName,PhoneNumber)  PRODUCT_SUPPLIER <u>(ProductID</u>,SupplierID) ..  D)  PRODUCT <u>(ProductID</u>,Description,Cost,SupplierID)  SUPPLIER <u>(SupplierID</u>,ContactName,PhoneNumber) , E)  PRODUCT <u>(ProductID</u>,Description,Cost)  SUPPLIER <u>(SupplierID</u>,ContactName,PhoneNumber)  PRODUCT_SUPPLIER <u> ( ProductID  , SupplierID) </u>,.


Definitions:

Related Questions