Local veterinarian storing the pet details and treatment as below. Your task this to migrate this...

Transcribed Image Text:

Local veterinarian storing the pet details and treatment as below. Your task this to migrate this excel sheet to database objects and store it in RDBMS. PET NAME PET TYPE PET AGE ROVER DOG 11 SPOT MORRIS TWEEDY DOG CAT BIRD Expected Results: OWNER SAM COOK 2 TERRY KIM 4 SAM COOK 2 Terry Kim Visit Date JAN 13/2010 MAR 27/2012 DEC 14/2012 JAN 21/2019 Mar 10/2019 JAN 23/2018 JAN 13/2019 APR 10/2018 APR 10/2019 Identify entities involved here. • Use Normalization technique to convert this to up 3NF. UNF: 1NF: 2NF: 3NF: • Create an ERD diagram. Procedure 01 - RABIES VACCINATION 10 - EXAMINE and TREAT WOUND 05- HEART WORM TEST 08 - TETANUS VACCINATION 05 - HEART WORM TEST 01- RABIES VACCINATION 01- RABIES VACCINATION 20 - ANNUAL CHECK UP 12- EYE WASH Local veterinarian storing the pet details and treatment as below. Your task this to migrate this excel sheet to database objects and store it in RDBMS. PET NAME PET TYPE PET AGE ROVER DOG 11 SPOT MORRIS TWEEDY DOG CAT BIRD Expected Results: OWNER SAM COOK 2 TERRY KIM 4 SAM COOK 2 Terry Kim Visit Date JAN 13/2010 MAR 27/2012 DEC 14/2012 JAN 21/2019 Mar 10/2019 JAN 23/2018 JAN 13/2019 APR 10/2018 APR 10/2019 Identify entities involved here. • Use Normalization technique to convert this to up 3NF. UNF: 1NF: 2NF: 3NF: • Create an ERD diagram. Procedure 01 - RABIES VACCINATION 10 - EXAMINE and TREAT WOUND 05- HEART WORM TEST 08 - TETANUS VACCINATION 05 - HEART WORM TEST 01- RABIES VACCINATION 01- RABIES VACCINATION 20 - ANNUAL CHECK UP 12- EYE WASH