« previous next »

Author Question: Functional dependency Type --> OwnerID exists in the table VEHICLE. Indicate whether the ... (Read 54 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 tallest man ever known was Robert Wadlow, an American, who reached the height of 8 feet 11 inches. He died at age 26 years from an infection caused by the immense weight of his body (491 pounds) and the stress on his leg bones and muscles.

Did you know?

More than 20 million Americans cite use of marijuana within the past 30 days, according to the National Survey on Drug Use and Health (NSDUH). More than 8 million admit to using it almost every day.

Did you know?

During the twentieth century, a variant of the metric system was used in Russia and France in which the base unit of mass was the tonne. Instead of kilograms, this system used millitonnes (mt).

Did you know?

Acute bronchitis is an inflammation of the breathing tubes (bronchi), which causes increased mucus production and other changes. It is usually caused by bacteria or viruses, can be serious in people who have pulmonary or cardiac diseases, and can lead to pneumonia.

Did you know?

It is difficult to obtain enough calcium without consuming milk or other dairy foods.

The target lambda on this vehicle is slightly lower than 1.0 indicating that the PCM is attempting ... The target lambda on this vehicle is slightly lower than 1.0 indicating that the PCM is attempting ...
Hookup for testing fuel-pump current draw on any vehicle equipped with a fuel-pump relay. Hookup for testing fuel-pump current draw on any vehicle equipped with a fuel-pump relay.
Induration measurement in a tuberculin skin test, a type IV hypersensitivity. Induration measurement in a tuberculin skin test, a type IV hypersensitivity.
Redrape the back, face the head of the table, and apply passive touch as finishing technique. Gently ... Redrape the back, face the head of the table, and apply passive touch as finishing technique. Gently ...
High stress, by household type (age-standardized), age 18+, Canada, 1994-1995 High stress, by household type (age-standardized), age 18+, Canada, 1994-1995
The periodic table and its creator, Dmitry Mendeleyev. The periodic table and its creator, Dmitry Mendeleyev.
Video: Endocytosis -Types and Phagocytosis

For a complete list of videos, visit our video library