« previous next »

Author Question: When redesigning a database, how can we check assumptions about functional dependencies? What ... (Read 27 times)

kshipps

  • Hero Member
  • *****
  • Posts: 571
on: Jul 7, 2018
When redesigning a database, how can we check assumptions about functional dependencies?
 
  What will be an ideal response?

Question 2

SQL query results are displayed:
 
  A) in a tabbed results window.
  B) in a tabbed Results1 window.
  C) in a tabbed Document window.
  D) in a tabbed Messages window.
  E) in a tabbed Finished window.


billybob123

  • Sr. Member
  • ****
  • Posts: 336
Reply #1 on: Jul 7, 2018
Answer to Question 1

There are two related SQL techniques that we can use to check assumptions about functional dependencies in an existing database. The first is to use a correlated subquery with the SQL IN keyword, and the second is to use a correlated subquery structure using the SQL EXISTS and/or NOT EXISTS keywords.

Answer to Question 2

A


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

If you use artificial sweeteners, such as cyclamates, your eyes may be more sensitive to light. Other factors that will make your eyes more sensitive to light include use of antibiotics, oral contraceptives, hypertension medications, diuretics, and antidiabetic medications.

Did you know?

Vital signs (blood pressure, temperature, pulse rate, respiration rate) should be taken before any drug administration. Patients should be informed not to use tobacco or caffeine at least 30 minutes before their appointment.

Did you know?

Giardia is one of the most common intestinal parasites worldwide, and infects up to 20% of the world population, mostly in poorer countries with inadequate sanitation. Infections are most common in children, though chronic Giardia is more common in adults.

Did you know?

Many people have small pouches in their colons that bulge outward through weak spots. Each pouch is called a diverticulum. About 10% of Americans older than age 40 years have diverticulosis, which, when the pouches become infected or inflamed, is called diverticulitis. The main cause of diverticular disease is a low-fiber diet.

Did you know?

In 2012, nearly 24 milliion Americans, aged 12 and older, had abused an illicit drug, according to the National Institute on Drug Abuse (NIDA).

Some common functional groups of biomolecules Some common functional groups of biomolecules
A functional renal unit. A functional renal unit.
Be sure that the clips are properly installed. Start the engine and check for proper operation. Be sure that the clips are properly installed. Start the engine and check for proper operation.
When checking a waste spark-type ignition system, check that the secondary wires are attached to the ... When checking a waste spark-type ignition system, check that the secondary wires are attached to the ...
Functional Groups of Carbon Functional Groups of Carbon
Functional categories of human genes Functional categories of human genes
Video: Types of disease resistance: innate defenses & immunity

For a complete list of videos, visit our video library