« previous next »

Author Question: When redesigning a database, how can we check assumptions about functional dependencies? What ... (Read 62 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 2006, a generic antinausea drug named ondansetron was approved. It is used to stop nausea and vomiting associated with surgery, chemotherapy, and radiation therapy.

Did you know?

Though methadone is often used to treat dependency on other opioids, the drug itself can be abused. Crushing or snorting methadone can achieve the opiate "rush" desired by addicts. Improper use such as these can lead to a dangerous dependency on methadone. This drug now accounts for nearly one-third of opioid-related deaths.

Did you know?

When blood is exposed to air, it clots. Heparin allows the blood to come in direct contact with air without clotting.

Did you know?

Adult head lice are gray, about ? inch long, and often have a tiny dot on their backs. A female can lay between 50 and 150 eggs within the several weeks that she is alive. They feed on human blood.

Did you know?

About 60% of newborn infants in the United States are jaundiced; that is, they look yellow. Kernicterus is a form of brain damage caused by excessive jaundice. When babies begin to be affected by excessive jaundice and begin to have brain damage, they become excessively lethargic.

Functional Functional
Example of a voucher check. Example of a voucher check.
When checking a coil-on-plug (COP) assembly, check that the primary and secondary wiring looks ... When checking a coil-on-plug (COP) assembly, check that the primary and secondary wiring looks ...
A general model of the sensorimotor system. Notice its hierarchical structure, functional ... A general model of the sensorimotor system. Notice its hierarchical structure, functional ...
Functional foods are being used by some health care professionals Functional foods are being used by some health care professionals
Bullfrog (Rana catesbiana), 6-legged frog with all legs functional . Bullfrog (Rana catesbiana), 6-legged frog with all legs functional .
Video: Segmentation and migrating motility complexes & Gastroileal reflex

For a complete list of videos, visit our video library