« previous next »

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

Common abbreviations that cause medication errors include U (unit), mg (milligram), QD (every day), SC (subcutaneous), TIW (three times per week), D/C (discharge or discontinue), HS (at bedtime or "hours of sleep"), cc (cubic centimeters), and AU (each ear).

Did you know?

Persons who overdose with cardiac glycosides have a better chance of overall survival if they can survive the first 24 hours after the overdose.

Did you know?

About one in five American adults and teenagers have had a genital herpes infection—and most of them don't know it. People with genital herpes have at least twice the risk of becoming infected with HIV if exposed to it than those people who do not have genital herpes.

Did you know?

GI conditions that will keep you out of the U.S. armed services include ulcers, varices, fistulas, esophagitis, gastritis, congenital abnormalities, inflammatory bowel disease, enteritis, colitis, proctitis, duodenal diverticula, malabsorption syndromes, hepatitis, cirrhosis, cysts, abscesses, pancreatitis, polyps, certain hemorrhoids, splenomegaly, hernias, recent abdominal surgery, GI bypass or stomach stapling, and artificial GI openings.

Did you know?

Famous people who died from poisoning or drug overdose include, Adolf Hitler, Socrates, Juan Ponce de Leon, Marilyn Monroe, Judy Garland, and John Belushi.

Functional Groups of Vitamin C Functional Groups of Vitamin C
Always connect an exhaust hose to the tailpipe of a vehicle to be run inside a building. Always connect an exhaust hose to the tailpipe of a vehicle to be run inside a building.
Table Salt Is Composed of Sodium and Chloride Table Salt Is Composed of Sodium and Chloride
List transformations and Create a table of values for the following log function: List transformations and Create a table of values for the following log function:
Table - Correlation Analysis Table - Correlation Analysis
Table Table
Video: Labor and Childbirth - The Three Stages of Labor: Dilation, Expulsion & Placental مراحل الولادة

For a complete list of videos, visit our video library