Describe the normal forms violated in the following design and fix them to the t

Describe the normal forms violated in the following design and fix them to the third normal form.
Basic NormalizationDescribe 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 keyDescribe 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 keyFor both questions you will need to submit:
A listing of all the violations of normalization
A three-stage set depicting the normalization process showing the tables after first second and third normal form. Basic NormalizationDescribe 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 keyDescribe 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 keyFor both questions you will need to submit:
A listing of all the violations of normalization
A three-stage set depicting the normalization process showing the tables after first second and third normal form.
Attachments: