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

Over time, chronic hepatitis B virus and hepatitis C virus infections can progress to advanced liver disease, liver failure, and hepatocellular carcinoma. Unlike other forms, more than 80% of hepatitis C infections become chronic and lead to liver disease. When combined with hepatitis B, hepatitis C now accounts for 75% percent of all cases of liver disease around the world. Liver failure caused by hepatitis C is now leading cause of liver transplants in the United States.

Did you know?

Patients should never assume they are being given the appropriate drugs. They should make sure they know which drugs are being prescribed, and always double-check that the drugs received match the prescription.

Did you know?

The average human gut is home to perhaps 500 to 1,000 different species of bacteria.

Did you know?

Most fungi that pathogenically affect humans live in soil. If a person is not healthy, has an open wound, or is immunocompromised, a fungal infection can be very aggressive.

Did you know?

Asthma-like symptoms were first recorded about 3,500 years ago in Egypt. The first manuscript specifically written about asthma was in the year 1190, describing a condition characterized by sudden breathlessness. The treatments listed in this manuscript include chicken soup, herbs, and sexual abstinence.

For a complete list of videos, visit our video library