Basic Normalization

1. Describe the normal forms violated in the following design and fix them to the third normal form.

PATIENT
PATIENT_ID*
FIRST_NAME
LAST_NAME
STREET
CITY
STATE
ZIP
PHONE
DOCTOR_ID
DOC_FNAME
DOC_LNAME
DOC_CONTACT_PHONE_NUMBERS

*Primary key

2. Describe the normal forms violated in the following design, and fix them to the third normal form.

PATIENT
PATIENT_ID*
INSURANCE_CO*
FIRST_NAME
LAST_NAME
STREET
CITY
STATE
ZIP
PHONE
INS_CO-CONTRACT_FNAME
INS_CO_CONTACT_LNAME
INS_CO_PHONE

*Primary key

For both questions, you will need to submit:
1. A listing of all the violations of normalization
2. A three-stage set depicting the normalization process, showing the tables after first, second, and third normal form.