Author Question: Functional dependency OwnerID --> VehicleID exists in the table VEHICLE. Indicate whether the ... (Read 90 times)

dbose

  • Hero Member
  • *****
  • Posts: 597
Functional dependency OwnerID --> VehicleID exists in the table VEHICLE.
 
  Indicate whether the statement is true or false

Question 2

Write an SQL query for the HAPPY INSURANCE database that will retrieve the name of each agent that has no supervisor and has a rating higher than 100.
 
  What will be an ideal response?



Pariscourtney

  • Sr. Member
  • ****
  • Posts: 352
Answer to Question 1

FALSE

Answer to Question 2

SELECT agentname
FROM agent
WHERE supervisedby IS NULL and agentrating > 100;



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

As of mid-2016, 18.2 million people were receiving advanced retroviral therapy (ART) worldwide. This represents between 43–50% of the 34–39.8 million people living with HIV.

Did you know?

In most climates, 8 to 10 glasses of water per day is recommended for adults. The best indicator for adequate fluid intake is frequent, clear urination.

Did you know?

The effects of organophosphate poisoning are referred to by using the abbreviations “SLUD” or “SLUDGE,” It stands for: salivation, lacrimation, urination, defecation, GI upset, and emesis.

Did you know?

Vampire bats have a natural anticoagulant in their saliva that permits continuous bleeding after they painlessly open a wound with their incisors. This capillary blood does not cause any significant blood loss to their victims.

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.

For a complete list of videos, visit our video library