Which of the Following Tables Is in Third Normal Form

question 6

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

---

Definitions:

Demand Curve

An illustrative chart that depicts how the demand for a product varies with changes in its price.

Total Costs

The overall expenditure on the production of goods or services, covering both fixed and variable costs.

Flight Capacity

The maximum number of passengers or the amount of cargo that an airline can transport in a given period.

Collude

Cooperative behavior between firms in a market to set prices or output levels artificially high, typically in a way that is not in the best interests of consumers.