« previous next »

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

dbose

  • Hero Member
  • *****
  • Posts: 597
on: Jul 7, 2018
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
Reply #1 on: Jul 7, 2018
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
« previous next »
 

Did you know?

The tallest man ever known was Robert Wadlow, an American, who reached the height of 8 feet 11 inches. He died at age 26 years from an infection caused by the immense weight of his body (491 pounds) and the stress on his leg bones and muscles.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates’s recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

Bacteria have been found alive in a lake buried one half mile under ice in Antarctica.

Did you know?

In 1886, William Bates reported on the discovery of a substance produced by the adrenal gland that turned out to be epinephrine (adrenaline). In 1904, this drug was first artificially synthesized by Friedrich Stolz.

Did you know?

The Food and Drug Administration has approved Risperdal, an adult antipsychotic drug, for the symptomatic treatment of irritability in children and adolescents with autism. The approval is the first for the use of a drug to treat behaviors associated with autism in children. These behaviors are included under the general heading of irritability and include aggression, deliberate self-injury, and temper tantrums.

Periodic Table Periodic Table
Functional magnetic resonance image (fMRI). This image illustrates the areas of cortex that became ... Functional magnetic resonance image (fMRI). This image illustrates the areas of cortex that became ...
Stretch the extensor muscles with flexion at the wrist. Reposition the palm to face the table. Apply ... Stretch the extensor muscles with flexion at the wrist. Reposition the palm to face the table. Apply ...
Layers of sheets and towels on the table for a body wrap. Layers of sheets and towels on the table for a body wrap.
DOT placarding requirements: Table 1 materials must be placarded in any quantity, and Table 2 ... DOT placarding requirements: Table 1 materials must be placarded in any quantity, and Table 2 ...
table table
Video: DNA fingerprinting Animation

For a complete list of videos, visit our video library