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

There can actually be a 25-hour time difference between certain locations in the world. The International Date Line passes between the islands of Samoa and American Samoa. It is not a straight line, but "zig-zags" around various island chains. Therefore, Samoa and nearby islands have one date, while American Samoa and nearby islands are one day behind. Daylight saving time is used in some islands, but not in others—further shifting the hours out of sync with natural time.

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 newest statin drug, rosuvastatin, has been called a superstatin because it appears to reduce LDL cholesterol to a greater degree than the other approved statin drugs.

Did you know?

Limit intake of red meat and dairy products made with whole milk. Choose skim milk, low-fat or fat-free dairy products. Limit fried food. Use healthy oils when cooking.

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.

For a complete list of videos, visit our video library