Given the tablesPRODUCT (ProductID, Description, Cost)SUPPLIER ...

[kellyjaisingh]

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

[Mholman93]

Answer to Question 1

E

Answer to Question 2

E

[kellyjaisingh]

Gracias!

[amcvicar]

Great answer, keep it coming