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.