4) (30 pts) A local veterinarian hospital keeps record about the different pets they see over time as well as information about treatment provided. The following tables represent a sample of the information recorded about pets and treatments. Pets PetName Type Breed Weight ANNNNNNN King Dog Std. Poodle 25.5 Teddy Cat Cashmere 10.5 Fido Dog Std. Poodle 28.5 King Horse Border Collie 25.0 Treatments Name Anesthesia Required Vaccine No Dental Yes Surgery Yes a. (20 pts) This veterinarian hospital wants to set up a data warehouse containing various information about the business. One section of this data warehouse focuses on recording data about each pet visit. For each visit, it is essential to record the various data represented in the tables above about the pet and treatment. It is also essential to record data about the date of the visit, including the day, month and year. Finally, the visit fee should be recorded. Consider that the visit fee varies depending on the pet and treatment Based on all these information, draw a star schema for this specific part of data warehouse focusing on recording data related to each visit. b. (10 pts) Based on your start schema in a., write a SQL query displaying the pet name, pet type, treatment name, visit day and visit fee for all the pets who visited the hospital in 2021