Answer each of the following questions using the KimTay Pet Supplies data shown in Figure 2-1. pres - Open a new MicrosoftQ Word document and answer the following question. - Save the file on your computer with your last name in the file name. (Example: Case_Exercise_ 1 _ Jones.doc) - Click the Choose Flle button to find and select your saved document. Indicate the changes (using the shorthand representation) that you would need to make to the original KimTay Pet Supplies database design in the event that the original Requirement 3 is changed as follows. For an item, store the item's ID, description, category, and price. In addition, for each location in which the item is located, store the value of the location, the description of the location, and the number of units of the item stored in the location. Draw an E-R diagram for the new design. - Open a new Microsotie Word document and answer the following quiestion. - Save the file on your computer with your last name in the file name. (Example: Case_Exercise_1_Jones,doc) - Cick the Choose File botton to find and select your saved document. Using your knowledge of KimTay Pet Supplies, determine the functional dependencies that exist in the following table. After determining the functio dependencies, convert this table to an equivalent collection of tables that are in third normal form. ITKM (ITEM ID, DEECRIPTION, ON HAND, CATRGORY, LOCATION, PRICE, (IHYOICE NUM, IHVOICE - DATE, CUST ID, FIRST MAME. LAOT NAME, QUANTITX, QUOTED VRICE)) Indicate the changes you need to make to the KimTay Pet Supplies database to support the following additional requirement. Each location has a mar. who is identified by a manager ID, a manager first name, and a manager last name