« previous next »

Author Question: When redesigning a database, how can we check assumptions about functional dependencies? What ... (Read 56 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?

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?

Cucumber slices relieve headaches by tightening blood vessels, reducing blood flow to the area, and relieving pressure.

Did you know?

Patients who have been on total parenteral nutrition for more than a few days may need to have foods gradually reintroduced to give the digestive tract time to start working again.

Did you know?

Historic treatments for rheumatoid arthritis have included gold salts, acupuncture, a diet consisting of apples or rhubarb, nutmeg, nettles, bee venom, bracelets made of copper, prayer, rest, tooth extractions, fasting, honey, vitamins, insulin, snow collected on Christmas, magnets, and electric convulsion therapy.

Did you know?

Asthma is the most common chronic childhood disease in the world. Most children who develop asthma have symptoms before they are 5 years old.

With the vehicle raised one foot (30 cm) off the ground, push down on the vehicle to check if it ... With the vehicle raised one foot (30 cm) off the ground, push down on the vehicle to check if it ...
To check for voltage at terminal 30, use a test light or a voltmeter. Start by connecting the ... To check for voltage at terminal 30, use a test light or a voltmeter. Start by connecting the ...
Horizontal, sagittal, and coronal functional MRIs show areas of increased activity in the primary ... Horizontal, sagittal, and coronal functional MRIs show areas of increased activity in the primary ...
Functional Groups of Carbon Functional Groups of Carbon
The general description of allele and genotype frequencies under Hardy–Weinberg assumptions The general description of allele and genotype frequencies under Hardy–Weinberg assumptions
Orientation and structure of a nephron, the functional unit of the kidney. Orientation and structure of a nephron, the functional unit of the kidney.
Video: The Krebs Cycle Animation

For a complete list of videos, visit our video library