Author Question: Given the tablesPRODUCT (ProductID, Description, Cost)SUPPLIER (SupplierID, ContactName, ... (Read 62 times)

kellyjaisingh · **on:** Jul 7, 2018

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)

Question 2

Which SQL keyword can be used in conjunction with wildcards to select partial values?

A) SELECT
B) SEARCH
C) FIND
D) SUBSTRING
E) LIKE