« previous next »

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

Drying your hands with a paper towel will reduce the bacterial count on your hands by 45–60%.

Did you know?

Glaucoma is a leading cause of blindness. As of yet, there is no cure. Everyone is at risk, and there may be no warning signs. It is six to eight times more common in African Americans than in whites. The best and most effective way to detect glaucoma is to receive a dilated eye examination.

Did you know?

Though Candida and Aspergillus species are the most common fungal pathogens causing invasive fungal disease in the immunocompromised, infections due to previously uncommon hyaline and dematiaceous filamentous fungi are occurring more often today. Rare fungal infections, once accurately diagnosed, may require surgical debridement, immunotherapy, and newer antifungals used singly or in combination with older antifungals, on a case-by-case basis.

Did you know?

Nearly 31 million adults in America have a total cholesterol level that is more than 240 mg per dL.

Did you know?

The people with the highest levels of LDL are Mexican American males and non-Hispanic black females.

Scientists have demonstrated functional hair regeneration from adult stem cells Scientists have demonstrated functional hair regeneration from adult stem cells
Table 6.1 illustrates the main regime types and their differences. It breaks the regimes into four Table 6.1 illustrates the main regime types and their differences. It breaks the regimes into four
Label the four mutated DNA segments shown below according to the type of point mutation each ... Label the four mutated DNA segments shown below according to the type of point mutation each ...
A charcoal canister can be located under the hood or underneath the vehicle. A charcoal canister can be located under the hood or underneath the vehicle.
Action of a type II topoisomerase Action of a type II topoisomerase
Table - Analysis Table - Analysis
Video: Pressure volume relationships - Normal inspiration and expiration

For a complete list of videos, visit our video library