PART 2: PROBLEM-SOLVING QUESTIONS Problem 1: (ERD Model) Assume that you are a database specialist far Technology Visionaries LLC. You are required to create a conceptual data model for Animal Humane Society. The following are the data requirements gathered: a. The Animal Humane society has a few animal shelters. Each shelter is identified by an identification number and has an address, a phone number, ond a set of days on which it is open. A shelter is managed by one employee. b. An employee has an identification number, name, address, phone number, and a poy rote. An employee may work at more than one shelter. c. A volunteer has an identification number, name, address, phone number, and a meal aliowance. A volunteer may work at more than one shelter. d. An animal is housed at one shelter. Each animal has an identification number that is unique to its shelter, a name, a birth date, and a species. Draw a SINGLE (one) integrated ER diagram to represent the data requirements for the Animal Humane Society. You must include in your diagram ALL the entities, attributes, primary keys, relationships and constraints (multiplicity, participation). You should also describe the relationship direction and gives an appropriate name to describe the meaning of the relationship. Problem 2: Convert the following relation to an equivalent collection of relations that is in 3NF. This is relation concerns invoice information. For a given Invoice (INV), identified by invoice number, there will be a single Customer (CUST). INVOICE UINVNumber, CUSINumber, CUSIName, CUSTAddresss, INVDate, \{PARTNumber, PARTDescription, UNITPrice, NumberShipped\}) The primary key (P.K.) and the Foreign Key (F.K.) of each relation must be identified in each normal form step. Hints: At the end, there should be 4 tables in the 3 NF column