« previous next »

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

By definition, when a medication is administered intravenously, its bioavailability is 100%.

Did you know?

Bacteria have flourished on the earth for over three billion years. They were the first life forms on the planet.

Did you know?

The term bacteria was devised in the 19th century by German biologist Ferdinand Cohn. He based it on the Greek word "bakterion" meaning a small rod or staff. Cohn is considered to be the father of modern bacteriology.

Did you know?

There used to be a metric calendar, as well as metric clocks. The metric calendar, or "French Republican Calendar" divided the year into 12 months, but each month was divided into three 10-day weeks. Each day had 10 decimal hours. Each hour had 100 decimal minutes. Due to lack of popularity, the metric clocks and calendars were ended in 1795, three years after they had been first marketed.

Did you know?

Methicillin-resistant Staphylococcus aureus or MRSA was discovered in 1961 in the United Kingdom. It if often referred to as a superbug. MRSA infections cause more deaths in the United States every year than AIDS.

Methicilli ...
Functional classes of neurons. Functional classes of neurons.
Raster is the best scope position to view the spark lines of all the cylinders to check for ... Raster is the best scope position to view the spark lines of all the cylinders to check for ...
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 .
The functional consequences of mutation The functional consequences of mutation
Video: Regulation of GFR: three methods, autoregulation & autoregulation via myogenic mechanism

For a complete list of videos, visit our video library