Purpose: In this home work, you will practice normalization of data.

Save your answer in a file name CIS64A-HW6-XXXXX where XXXXX are the last 5 digits of your ID.

Submit your document in Canvas.

Sample example

You are given the following data for a pet health care clinic. Perform the normalization process and show the 4 results.

Provide answers for the following:

1- What is the Un-Normalized Form:

2- What is First Normal Form:

3- What is Second Normal Form:

4- What is Third Normal Form:

PET HEALTH CARE REPORT PET NAME ROVER PET TYPE PET AGE OWNER DOG VISIT DATE JAN 13/2016 MAR 27/2016 APR 02/2016 PET ID 12 01 - RABIES VACCINATION 10 - EXAMINE and TREAT WOUND 05- HEART WORM TEST 246 SAM COOK 298 SPOT DOG TERRY KIM JAN 21/2016 MAR 10/2016 08 TETANUS VACCINATION 05- HEART WORM TEST 341 MORRIS CAT 01 - RABIES VACCINATION 01 - RABIES VACCINATION SAM COOK JAN 23/2016 JAN 13/2016 519 TWEEDY BIRD TERRY KIM APR 30/2016 APR 30/2016 20 - ANNUAL CHECK UP 12- EYE WASH