This topic contains a solution. Click here to go to the answer

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

kellyjaisingh

  • Hero Member
  • *****
  • Posts: 540
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



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

Mholman93

  • Sr. Member
  • ****
  • Posts: 328
Answer to Question 1

E

Answer to Question 2

E




kellyjaisingh

  • Member
  • Posts: 540
Reply 2 on: Jul 7, 2018
Excellent


tuate

  • Member
  • Posts: 332
Reply 3 on: Yesterday
Great answer, keep it coming :)

 

Did you know?

According to the National Institute of Environmental Health Sciences, lung disease is the third leading killer in the United States, responsible for one in seven deaths. It is the leading cause of death among infants under the age of one year.

Did you know?

Only 12 hours after an egg cell is fertilized by a sperm cell, the egg cell starts to divide. As it continues to divide, it moves along the fallopian tube toward the uterus at about 1 inch per day.

Did you know?

Thyroid conditions may make getting pregnant impossible.

Did you know?

Bacteria have been found alive in a lake buried one half mile under ice in Antarctica.

Did you know?

Fewer than 10% of babies are born on their exact due dates, 50% are born within 1 week of the due date, and 90% are born within 2 weeks of the date.

For a complete list of videos, visit our video library