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

Author Question: Given the tablesPRODUCT (ProductID, Description, Cost)SUPPLIER (SupplierID, ContactName, ... (Read 59 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
Thanks for the timely response, appreciate it


31809pancho

  • Member
  • Posts: 317
Reply 3 on: Yesterday
Gracias!

 

Did you know?

Hip fractures are the most serious consequences of osteoporosis. The incidence of hip fractures increases with each decade among patients in their 60s to patients in their 90s for both women and men of all populations. Men and women older than 80 years of age show the highest incidence of hip fractures.

Did you know?

Although puberty usually occurs in the early teenage years, the world's youngest parents were two Chinese children who had their first baby when they were 8 and 9 years of age.

Did you know?

As of mid-2016, 18.2 million people were receiving advanced retroviral therapy (ART) worldwide. This represents between 43–50% of the 34–39.8 million people living with HIV.

Did you know?

In 1835 it was discovered that a disease of silkworms known as muscardine could be transferred from one silkworm to another, and was caused by a fungus.

Did you know?

There are more sensory neurons in the tongue than in any other part of the body.

For a complete list of videos, visit our video library