Briefly describe the main purpose of normalization in database design. (3 marks) (6 marks) (b) Describe the rules of one normal form (INF), 2 NF and 3 NF. (c) You work as an administrator in UCSI Pet shop, and your task is to record health history of pets that visited your shop. Evaluate each entity against the rules of normalization (from first normal form to third normal form) and present your answer in the form of relations. Figure 1 is the health history report. (16 marks) Pet ID 111 222 333 444 Pet Name Robby Spotty May Tweedy Figure 1. Health History Report Pet Age Pet Owner Pet Type Rabbit Cat Cat Dog 1 3 5 Tim Cook Monica Lee Wayne Terry Kim Visit Date & Time 1/3/2021, 3,30 pm 2/4/2021,2.00 pm 3/3/2021, 11.10 am 1/6/2021, 9.00 am Procedure 01- Rabies Vaccination 05-Heart Worm Test 08-Tetanus Vaccination 05- Heart Worm Test 01-Rabies Vaccination 01-Rabies Vaccination 20-Annual Check up 12-Eye Wash [Total: 25 Marks]