« previous next »

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

Nearly all drugs pass into human breast milk. How often a drug is taken influences the amount of drug that will pass into the milk. Medications taken 30 to 60 minutes before breastfeeding are likely to be at peak blood levels when the baby is nursing.

Did you know?

Blood is approximately twice as thick as water because of the cells and other components found in it.

Did you know?

To maintain good kidney function, you should drink at least 3 quarts of water daily. Water dilutes urine and helps prevent concentrations of salts and minerals that can lead to kidney stone formation. Chronic dehydration is a major contributor to the development of kidney stones.

Did you know?

An identified risk factor for osteoporosis is the intake of excessive amounts of vitamin A. Dietary intake of approximately double the recommended daily amount of vitamin A, by women, has been shown to reduce bone mineral density and increase the chances for hip fractures compared with women who consumed the recommended daily amount (or less) of vitamin A.

Did you know?

A headache when you wake up in the morning is indicative of sinusitis. Other symptoms of sinusitis can include fever, weakness, tiredness, a cough that may be more severe at night, and a runny nose or nasal congestion.

Mitosis + Check Points 4 of 5 Mitosis + Check Points 4 of 5
The connector must be opened (disconnected) to check and/or adjust the ignition timing. On DIS/EDIS ... The connector must be opened (disconnected) to check and/or adjust the ignition timing. On DIS/EDIS ...
Prepare upper back for hot application. Undrape upper back. Check tissues visually and through ... Prepare upper back for hot application. Undrape upper back. Check tissues visually and through ...
Check heat source for temperature. Evaluate the amount of heat given off from the source using your ... Check heat source for temperature. Evaluate the amount of heat given off from the source using your ...
Remove the heat source, and check the skin for redness. Massage the area, and notice muscle ... Remove the heat source, and check the skin for redness. Massage the area, and notice muscle ...
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: Chemical Buffers - protein buffer, phosphate buffer system and bicarbonate buffer system

For a complete list of videos, visit our video library