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)
Correct Answer:

Verified
Correct Answer:
Verified
Q24: The identifier of the entity becomes the
Q31: Explain the representation of a one-to-many strong
Q38: By default,Microsoft Access creates 1:1 relationships between
Q40: What is denormalization and why can it
Q41: The ideal primary key is short,numeric,and nonchanging.
Q42: Explain the representation of ID-dependent weak entities
Q44: The key for an intersection table is
Q45: To create a 1:1 relationship between two
Q46: As far as Microsoft Access is concerned,there
Q48: An example of a join in SQL