What changes would you need to make to the normalized tables in Exercise 3 to support the following additional requirements:

a. TAL needs to keep track of the price a supplier charges for an item. Different suppliers can charge different prices for the same item.

b. Each storehouse has a manager who is identified by a manager number, a manager last name, and a manager first name.

Item(ItemNum, Description, Category, Price)

Storehouse(StoreHouseNum, StoreHouseName, OnHand)

Suppliers(SupplierName, LeadTime)