« previous next »

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

In 2010, opiate painkllers, such as morphine, OxyContin®, and Vicodin®, were tied to almost 60% of drug overdose deaths.

Did you know?

Critical care patients are twice as likely to receive the wrong medication. Of these errors, 20% are life-threatening, and 42% require additional life-sustaining treatments.

Did you know?

Less than one of every three adults with high LDL cholesterol has the condition under control. Only 48.1% with the condition are being treated for it.

Did you know?

Approximately 25% of all reported medication errors result from some kind of name confusion.

Did you know?

The word drug comes from the Dutch word droog (meaning "dry"). For centuries, most drugs came from dried plants, hence the name.

Some common functional groups of biomolecules Some common functional groups of biomolecules
Mitosis + Check Points 5 of 5 Mitosis + Check Points 5 of 5
Assumptions of race-ethnicity can have unusual consequences. In this photo, Ethiopian Jews in ... Assumptions of race-ethnicity can have unusual consequences. In this photo, Ethiopian Jews in ...
Like other aspects of culture, religion is filled with background assumptions that usually go ... Like other aspects of culture, religion is filled with background assumptions that usually go ...
Touch the test light to the negative (–) terminal of the battery or a good engine ground to check ... Touch the test light to the negative (–) terminal of the battery or a good engine ground to check ...
A schematic diagram of the functional cycle of the Na+–K+ pump A schematic diagram of the functional cycle of the Na+–K+ pump
Video: Introduction to Sickle Cell Anemia

For a complete list of videos, visit our video library