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

cdr_15 · **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?

ryrychapman11 · **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.