« previous next »

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

Hyperthyroidism leads to an increased rate of metabolism and affects about 1% of women but only 0.1% of men. For most people, this increased metabolic rate causes the thyroid gland to become enlarged (known as a goiter).

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

The U.S. Preventive Services Task Force recommends that all women age 65 years of age or older should be screened with bone densitometry.

Did you know?

HIV testing reach is still limited. An estimated 40% of people with HIV (more than 14 million) remain undiagnosed and do not know their infection status.

Did you know?

Once thought to have neurofibromatosis, Joseph Merrick (also known as "the elephant man") is now, in retrospect, thought by clinical experts to have had Proteus syndrome. This endocrine disease causes continued and abnormal growth of the bones, muscles, skin, and so on and can become completely debilitating with severe deformities occurring anywhere on the body.

Consider using a foam pad on your table. Consider using a foam pad on your table.
A symbol used on a Chrysler vehicle indicating a fault with the electronic throttle control. A symbol used on a Chrysler vehicle indicating a fault with the electronic throttle control.
Clear the inguinal catchment area. Face the side of the table at recipient’s waist. Place your ... Clear the inguinal catchment area. Face the side of the table at recipient’s waist. Place your ...
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 ...
How to solve an exponential problem using a table of values (Question 2) How to solve an exponential problem using a table of values (Question 2)
table table
Video: Dorsal Recumbent Position

For a complete list of videos, visit our video library