« previous next »

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

Increased intake of vitamin D has been shown to reduce fractures up to 25% in older people.

Did you know?

If all the neurons in the human body were lined up, they would stretch more than 600 miles.

Did you know?

An identified risk factor for osteoporosis is the intake of excessive amounts of vitamin A. Dietary intake of approximately double the recommended daily amount of vitamin A, by women, has been shown to reduce bone mineral density and increase the chances for hip fractures compared with women who consumed the recommended daily amount (or less) of vitamin A.

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

Did you know?

More than 50% of American adults have oral herpes, which is commonly known as "cold sores" or "fever blisters." The herpes virus can be active on the skin surface without showing any signs or causing any symptoms.

Geoffroy's tamarin (Saguinus geoffroyi), also known as the Panamanian, red-crested or rufous-na Geoffroy's tamarin (Saguinus geoffroyi), also known as the Panamanian, red-crested or rufous-na
Consider using a foam pad on your table. Consider using a foam pad on your table.
The pad arm has dented the rocker panel on this vehicle because the pad was set too far inward ... The pad arm has dented the rocker panel on this vehicle because the pad was set too far inward ...
The Z lens, which was developed by Zaidel to study functional asymmetry in split-brain patients. It ... The Z lens, which was developed by Zaidel to study functional asymmetry in split-brain patients. It ...
Stretch the extensor muscles with flexion at the wrist. Reposition the palm to face the table. Apply ... Stretch the extensor muscles with flexion at the wrist. Reposition the palm to face the table. Apply ...
A GWAS study for Type 2 diabetes revealed 386,371 genetic markers, clustered here by chromosome numb A GWAS study for Type 2 diabetes revealed 386,371 genetic markers, clustered here by chromosome numb
Video: Bond in biological molecules (Ionic, Covalent and Hydrogen bonds)/ How atoms bond?

For a complete list of videos, visit our video library