Functional dependency Type --> OwnerID exists in the table ...

[ashley]

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]

Answer to Question 1

FALSE

Answer to Question 2

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

[ashley]

TY

[31809pancho]

Happy to Help