Question 6 (9 points) You are designing a database for KW Humane Society. The result is the following set of relations where the type of each relations attribute is given following the attribute (c.g., ID: integer): Animals (ID: integer, Name: string, PrevOwner:string, DateAdmitted: date, Type: string) Adopter(SIN: integer. Name: string, Address: string, Other Animals: integer) Adoption(Animal Dinteger, SIN: integer, AdoptDate: date, chip No: integer) where (a) The primary keys are underlined. (b) Animals stores information about the animals currently at the Humane Society. Each is given an ID, and their names together with the SIN of their previous owners (attribute PrevOwner), and their date of admission is recorded. Type refers to the type of animal (dog, cat, etc). (e) Adopter is the relation that holds information about animal adopters. The at- tributes are self-descriptive, except Other Animals which records the number of other animals that the adopter currently has at home. (d) Animalls in Adoption refers to the ID of Animals. Similarly, SIN in Adoption refers to the SIN of Adopter. Attribute chipNo stores the number on the microchip that is implanted on the animal for tracking. Owner in Animals refers to the SIN of Adopter (in this case the previous adopter). Formulate the following queries in SQL: (3 points each) (3) Retrieve the total number of dogs that were brought to the Humane Society on 18 April 2000. (b) For each animal type, list the animal type and total number of adoptions on 14 June 1999. (For each adopter who has made at least two adoptions, list their names and addresses