Which of the Following Tables Is in Third Normal Form

Multiple Choice

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) )