
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
Q9: By default,Microsoft Access creates 1:1 relationships between
Q31: As far as Microsoft Access is concerned,there
Q62: In a relational database design,all relationships are
Q62: The first step of database design is
Q64: The identifier of the entity becomes the
Q75: A surrogate key should be considered when
Q76: After a 1:1 relationship has been created
Q78: In many-to-many relationships in a relational database
Q88: Which of the following is not true
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