Database concepts

Q4: A veterinary practice maintains its records of all animal checkups in a single report as follows. HEALTH HISTORY REPORT PETID PET NAME PET TYPE PETAGE OWNER VISIT DATE PROCEDURE 246 ROVER 01- RABIES VACCINATION 10-EXAMINE and TREAT WOUND 05 - HEART WORM TEST 12 JAN 13/2002 MAR 27/2002 APR 02/2002 DOG SAM COOK JAN 21/2002 08 TETANUS VACCINATION MAR 10/2002 05-HEART WORM TEST 298 SPOT DOG 2 SAM COOK 01-RABIES VACCINATION JAN 23/2001 JAN 13/2002 01-RABIES VACCINATION 341 MORRIS CAT APR 302002 APR 30/2002 20-ANNUAL CHECK UP 12-EYE WASH 519 TWEEDY BIRD 2 TERRY KIM Create a new relation structure using record layout in: a) Create un-normalize form of relational schema b) First Normal Form (INF)