« previous next »

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

Looking at the sun may not only cause headache and distort your vision temporarily, but it can also cause permanent eye damage. Any exposure to sunlight adds to the cumulative effects of ultraviolet (UV) radiation on your eyes. UV exposure has been linked to eye disorders such as macular degeneration, solar retinitis, and corneal dystrophies.

Did you know?

People with alcoholism are at a much greater risk of malnutrition than are other people and usually exhibit low levels of most vitamins (especially folic acid). This is because alcohol often takes the place of 50% of their daily intake of calories, with little nutritional value contained in it.

Did you know?

People often find it difficult to accept the idea that bacteria can be beneficial and improve health. Lactic acid bacteria are good, and when eaten, these bacteria improve health and increase longevity. These bacteria included in foods such as yogurt.

Did you know?

To maintain good kidney function, you should drink at least 3 quarts of water daily. Water dilutes urine and helps prevent concentrations of salts and minerals that can lead to kidney stone formation. Chronic dehydration is a major contributor to the development of kidney stones.

Did you know?

The word drug comes from the Dutch word droog (meaning "dry"). For centuries, most drugs came from dried plants, hence the name.

Complete the table by dragging the white labels to the gray targets, the blue la Complete the table by dragging the white labels to the gray targets, the blue la
A heavily corroded radiator from a vehicle that was overheating. A visual inspection discovered that ... A heavily corroded radiator from a vehicle that was overheating. A visual inspection discovered that ...
A typical fuel pulsator used mostly with roller vane-type pumps to help even out the pulsation in ... A typical fuel pulsator used mostly with roller vane-type pumps to help even out the pulsation in ...
Structure of a complex of a type II DNA methylase with DNA Structure of a complex of a type II DNA methylase with DNA
The types of topological interconversions catalyzed by type II topoisomerases The types of topological interconversions catalyzed by type II topoisomerases
Handcrafted wooden coffee table Handcrafted wooden coffee table
Video: Enzyme-Catalyzed Reactions

For a complete list of videos, visit our video library