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
Q5: Which of the following is the correct
Q11: Which of the following is the correct
Q23: What relationship pattern is illustrated in the
Q26: What relationship pattern is illustrated in the
Q44: What relationship pattern is illustrated in the
Q53: Given the tables PRODUCT (ProductID,Description,Cost)
SUPPLIER (SupplierID,ContactName,PhoneNumber)
As shown
Q62: The first step of database design is
Q65: When transforming an E-R data model into
Q88: Which of the following is not true
Q90: When transforming an ID-dependent E-R data model
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents