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, 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
Correct Answer:
Verified
Q2: In many-to-many relationships in a relational database
Q17: All recursive relationships are 1:1.
Q35: The key for an intersection relation is
Q35: As far as Microsoft Access is concerned,there
Q54: The technique for representing E-R relationships in
Q60: When applied to 1:N relationships,the term "parent"
Q61: What relationship pattern is illustrated in the
Q62: Microsoft Access uses the same pure N:M
Q77: There are cases where it is possible
Q99: By default,the identifier of the entity becomes