« previous next »

Author Question: Functional dependency Type --> OwnerID exists in the table VEHICLE. Indicate whether the ... (Read 67 times)

ashley

  • Hero Member
  • *****
  • Posts: 584
on: Jul 7, 2018
Functional dependency Type --> OwnerID exists in the table VEHICLE.
 
  Indicate whether the statement is true or false

Question 2

Write an SQL statement for the HAPPY INSURANCE database that creates a view that contains, for each agent, the agent name and the headquarter city of his or her area.
 
  What will be an ideal response?


31809pancho

  • Sr. Member
  • ****
  • Posts: 317
Reply #1 on: Jul 7, 2018
Answer to Question 1

FALSE

Answer to Question 2

CREATE VIEW agentsandhqcities AS
SELECT agentname, areahq
FROM agent, area
WHERE areaid = agentarea;


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question

ashley

  • Hero Member
  • *****
  • Posts: 584
Reply #2 on: Jul 7, 2018
TY


31809pancho

  • Sr. Member
  • ****
  • Posts: 317
Reply #3 on: Jul 7, 2018
Happy to Help


« previous next »
 

Did you know?

The first oral chemotherapy drug for colon cancer was approved by FDA in 2001.

Did you know?

Opium has influenced much of the world's most popular literature. The following authors were all opium users, of varying degrees: Lewis Carroll, Charles, Dickens, Arthur Conan Doyle, and Oscar Wilde.

Did you know?

The cure for trichomoniasis is easy as long as the patient does not drink alcoholic beverages for 24 hours. Just a single dose of medication is needed to rid the body of the disease. However, without proper precautions, an individual may contract the disease repeatedly. In fact, most people develop trichomoniasis again within three months of their last treatment.

Did you know?

The most dangerous mercury compound, dimethyl mercury, is so toxic that even a few microliters spilled on the skin can cause death. Mercury has been shown to accumulate in higher amounts in the following types of fish than other types: swordfish, shark, mackerel, tilefish, crab, and tuna.

Did you know?

As the western states of America were settled, pioneers often had to drink rancid water from ponds and other sources. This often resulted in chronic diarrhea, causing many cases of dehydration and death that could have been avoided if clean water had been available.

An onager, one type of wild ass An onager, one type of wild ass
Example of the Table of Neoplasms. Example of the Table of Neoplasms.
In a gear-type oil pump, the oil flows through the pump around the outside of each gear. This is an ... In a gear-type oil pump, the oil flows through the pump around the outside of each gear. This is an ...
How to create a table of values displaying commission and earnings (Question 1) How to create a table of values displaying commission and earnings (Question 1)
Table showing comparing between Parental Plants vs. Offspring Table showing comparing between Parental Plants vs. Offspring
The Type of Blood Vessel Injury Often Affects the Nature of the Hemorrhage The Type of Blood Vessel Injury Often Affects the Nature of the Hemorrhage
Video: Alternative Energy Sources

For a complete list of videos, visit our video library