This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Normalizing table DOCTOR to 3NF will result in: A) No changes (table DOCTOR remains as is, no ... (Read 150 times)

cdr_15

  • Hero Member
  • *****
  • Posts: 546
on: Jul 7, 2018
Normalizing table DOCTOR to 3NF will result in:
 
  A) No changes (table DOCTOR remains as is, no additional tables)
  B) Two separate tables
  C) Three separate tables
  D) Four separate tables

Question 2

What is a correlated query and how is it used in conjunction with the EXISTS operator?
 
  What will be an ideal response?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

ryrychapman11

  • Sr. Member
  • ****
  • Posts: 334
Reply #1 on: Jul 7, 2018
Answer to Question 1

A

Answer to Question 2

In queries where the inner query (nested query) uses columns from the relations listed in the SELECT part of the outer query, the inner query is referred to as a correlated subquery. In such cases, the EXISTS operator can be used to check if the result of the inner correlated query is empty.


cdr_15

  • Member
  • Posts: 546
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review

okolip

  • Member
  • Posts: 362
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

Asthma cases in Americans are about 75% higher today than they were in 1980.

Did you know?

People often find it difficult to accept the idea that bacteria can be beneficial and improve health. Lactic acid bacteria are good, and when eaten, these bacteria improve health and increase longevity. These bacteria included in foods such as yogurt.

Did you know?

Though the United States has largely rejected the metric system, it is used for currency, as in 100 pennies = 1 dollar. Previously, the British currency system was used, with measurements such as 12 pence to the shilling, and 20 shillings to the pound.

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.

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

Table 6.1 illustrates the main regime types and their differences. It breaks the regimes into four Table 6.1 illustrates the main regime types and their differences. It breaks the regimes into four
Consider using a foam pad on your table. Consider using a foam pad on your table.
Fluidization - Calibration Table Pump #2 Fluidization - Calibration Table Pump #2
Finish with bilateral stroking to the entire back. Stand at head of the table with fingers pointing ... Finish with bilateral stroking to the entire back. Stand at head of the table with fingers pointing ...
How to determine if a table of values represents a function How to determine if a table of values represents a function
This table shows the growth of a crowd at a rally over a 3 h period. This table shows the growth of a crowd at a rally over a 3 h period.
Video: Premenstrual Syndrome

For a complete list of videos, visit our video library