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, ProductI
C) PRODUCT (ProductID, Description, Cost, SupplierI
D) SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductI
D) PRODUCT (ProductID, Description, Cost, ContactName) SUPPLIER (SupplierID, ContactName, PhoneNumber)
E) PRODUCT (ProductID, Description, Cost, SupplierI
D) SUPPLIER (SupplierID, ContactName, PhoneNumber)

Question

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, ProductI
C) PRODUCT (ProductID, Description, Cost, SupplierI
D) SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductI
D) PRODUCT (ProductID, Description, Cost, ContactName) SUPPLIER (SupplierID, ContactName, PhoneNumber) 
E) PRODUCT (ProductID, Description, Cost, SupplierI
D) SUPPLIER (SupplierID, ContactName, PhoneNumber)

Quizplus · Accepted Answer

The foreign key should be placed in the table that has the many-side of the one-to-many relationship. In this case, each product can have only one supplier, but a supplier can supply multiple products. Therefore, the foreign key (SupplierID) should be added to the PRODUCT table to establish the relationship. The PRODUCT (ProductID, Description, Cost, SupplierID) and SUPPLIER (SupplierID, ContactName, PhoneNumber) tables should be linked with the SupplierID column as the foreign key.

Given the Tables PRODUCT (ProductID,Description,Cost)