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
Q3: Given the tables TABLE_A (Attribute1,Attribute2,Attribute3)<br>TABLE_B (Attribute4,Attribute5,Attribute6)<br>As shown
Q9: The ideal primary key is short,numeric,and fixed.
Q26: In relational database design,ID-dependent entities are used
Q37: An entity needs to be examined according
Q55: Which of the following is the correct
Q56: By default,when Microsoft Access creates a relationship
Q59: In certain circumstances,there may be a preference
Q68: Microsoft Access does not create N:M relationships
Q73: The first step of database design is
Q90: The ideal primary key is _.<br>A)short<br>B)numeric<br>C)fixed<br>D)A and