DOCTOR
Observe the table DOCTOR:
DOCTOR
$$\begin{array} { c c c c }
\text { DoctorID } & \text { Name } & \text { Date OfMDGraduation } & \text { NumberOfPatients } \
\text { D111 } & \text { John } & 1 / 1 / 1999 & 100 \
\text { D222 } & \text { Tina } & 1 / 2 / 2003 & 117 \
\text { D333 } & \text { Ellen } & 1 / 1 / 2001 & 117 \
\text { D444 } & \text { Tina } & 1 / 1 / 2003 & 144
\end{array}$$

This table will be used for the following questions citing table DOCTOR.
-Table DOCTOR is:
A)Not in 1NF
B)In 1NF but not in 2NF
C)In 2NF but not in 3NF
D)In 3NF

Question

DOCTOR
Observe the table DOCTOR:
DOCTOR
 $$\begin{array} { c c c c } 
\text { DoctorID } & \text { Name } & \text { Date OfMDGraduation } & \text { NumberOfPatients } \
\text { D111 } & \text { John } & 1 / 1 / 1999 & 100 \
\text { D222 } & \text { Tina } & 1 / 2 / 2003 & 117 \
\text { D333 } & \text { Ellen } & 1 / 1 / 2001 & 117 \
\text { D444 } & \text { Tina } & 1 / 1 / 2003 & 144
\end{array}$$

This table will be used for the following questions citing table DOCTOR.
-Table DOCTOR is:
A)Not in 1NF
B)In 1NF but not in 2NF
C)In 2NF but not in 3NF
D)In 3NF

Quizplus · Accepted Answer

Table DOCTOR is in 3NF because it is in 2NF and every non-prime attribute is fully functionally dependent on the primary key.

DOCTOR Observe the Table DOCTOR: DOCTOR This Table Will Be Used for the Following Questions Citing

DOCTOR
Observe the Table DOCTOR:
DOCTOR This Table Will Be Used for the Following Questions Citing