1. [10 pts.] Consider the following database which keeps track of State and City information: CITY table: State CityName Abbrev STATE table: State Abbrev CT Mi SD TN TX StateName Union StateBird Order Connecticut S Michigan 26 40 South Dakota Tennessee Texas American robin Robin Pheasant State Population 3,287,116 9,295,297 696,004 16 Mocking bird 4,877,185 28 Mocking bird 16,986,510 CT CT CT MI 1 SD 50 TN TX TX Hartford Madison Portland Lansing Madison Pierre Nashville Austin Portland City Population 139,739 14,031 8,418 127,321 6,257 12.906 488,374 465,622 12,224 In which normal form it is given to you? Normalize it to its 3rd normal form and do this by drawing bubble diagrams in every step, clearly specifying the nature of the dependencies (Assume that the union order is not unique). 2. [5 pts.] Consider the following database which keeps track of client, veterinary, and pet information: Client ID Client Name 2173 4519 8005 8112 Barbara Hennessey 27 Vernon Noordsy Sandra Amidon VetID Helen Wandzell 31 27 24 VetName PetID PetVet PetCare PetVet PetsRUs 1 2 3 2 1 2 3 PetName Sam. Hoober Tom Charlie Sam Kirby Kirby PetType Bird Dog Hamster Cat Dog Dog Hamster In which normal form it is given to you? Normalize it to its 3rd normal form and do this by drawing bubble diagrams in every step, clearly specifying the nature of the dependencies.