Given the tablesPRODUCT (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, ProductID)
C) PRODUCT (ProductID, Description, Cost, SupplierID)
SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductID)
D) PRODUCT (ProductID, Description, Cost, ContactName)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
E) PRODUCT (ProductID, Description, Cost, SupplierID)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
E
You might also like to view...
From the perspective of control, the direct materials efficiency variance should be isolated at the time of
a. purchase. b. use. c. completion of the entire product. d. sale of the product.
What is any form of sponsor-identified, paid mass communication?
a. publicity b. promotion c. public relations d. advertising