Which of the following tables is in third normal form, given that DOC_ID determines DOC_FIRST_NAME and DOC_LAST_NAME?
A) PATIENT (PATIENT_ID, FIRST_NAME, LAST_NAME, DOC_ID, DOC_FIRST_NAME, DOC_LAST_NAME)
B) PATIENT (PATIENT_ID, FIRST_NAME, LAST_NAME, VISIT_DATE, (SERVICE, BILLING_CODE))
C) PATIENT (PATIENT_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NO, DOC_ID)
D) PATIENT (PATIENT_ID, DOC_ID, FIRST_NAME, LAST_NAME, (ADMIT_DATE, RELEASE_DATE))

Question

Quizplus · Accepted Answer

Option C is in third normal form because it does not contain transitive dependencies or repeating groups. DOC_ID is used without including DOC_FIRST_NAME and DOC_LAST_NAME, which are determined by DOC_ID and would otherwise cause a transitive dependency.

Which of the Following Tables Is in Third Normal Form