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, PhoneNumber)
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
Q22: After a 1:1 relationship has been created
Q23: What relationship pattern is illustrated in the
Q24: To create a 1:1 relationship between two
Q25: In many-to-many relationships in a relational database
Q26: What relationship pattern is illustrated in the
Q28: How are 1:1,1:N and N:M relationships handled
Q29: By default,when Microsoft Access creates a relationship
Q31: As far as Microsoft Access is concerned,there
Q32: Microsoft Access does not create N:M relationships
Q87: 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