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

kshipps

  • Hero Member
  • *****
  • Posts: 571
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
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
 

Did you know?

The heart is located in the center of the chest, with part of it tipped slightly so that it taps against the left side of the chest.

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?

The most common childhood diseases include croup, chickenpox, ear infections, flu, pneumonia, ringworm, respiratory syncytial virus, scabies, head lice, and asthma.

Did you know?

Urine turns bright yellow if larger than normal amounts of certain substances are consumed; one of these substances is asparagus.

Did you know?

On average, the stomach produces 2 L of hydrochloric acid per day.

For a complete list of videos, visit our video library