« previous next »

Author Question: Functional dependency Type --> OwnerID exists in the table VEHICLE. Indicate whether the ... (Read 59 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?

Complications of influenza include: bacterial pneumonia, ear and sinus infections, dehydration, and worsening of chronic conditions such as asthma, congestive heart failure, or diabetes.

Did you know?

By definition, when a medication is administered intravenously, its bioavailability is 100%.

Did you know?

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

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?

Adult head lice are gray, about ? inch long, and often have a tiny dot on their backs. A female can lay between 50 and 150 eggs within the several weeks that she is alive. They feed on human blood.

Vehicle transmission occurs through contamination of inanimate objects, such as milk. Vehicle transmission occurs through contamination of inanimate objects, such as milk.
Table of Ionic Charges Table of Ionic Charges
Hang the canister from the vehicle’s hood and adjust the air pressure regulator to full OPEN ... Hang the canister from the vehicle’s hood and adjust the air pressure regulator to full OPEN ...
Finish with bilateral stroking to the entire back. Stand at head of the table with fingers pointing ... Finish with bilateral stroking to the entire back. Stand at head of the table with fingers pointing ...
How to create a table of values from an equation and graph How to create a table of values from an equation and graph
Table - Analysis Table - Analysis
Video: Hormonal feedback loop components & Glucagon (glycogenolysis and gluconeogenesis)

For a complete list of videos, visit our video library