The requirements for TAL distributors have changed. A number and a name now identify each storehouse. Units of each item may be stored in multiple storehouses, and it is important to know precisely how many items are stored in each storehouse. I addition, TAL Distributors needs to know the number view full and anme of each supplier as well as the expected lead time for delivering each item. (Lead time is the amount of time a suppliers, and each supplier can supply many items. Using this information, convert the following unormalized relation to fourth normal form: Item( ItemNum, Description, Category, Price, (StorehouseNum, StorehouseName, OnHand), (SupplierNum, SupplierName, LeadTime))
4. What changes would you need to make to the normalized table 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 manger last name, and a manager first name.
5. TAL distributors is considering changing its business model so that many sales reps can represent one customer and one sales rep can represent many cutomers. Using this information, convert the following unnormalized relation to fourth normal form.
Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, (RepNum, LastName, FirstName, Street, City, State, PostalCode, Comission, Rate))
6. Convert the following unnormailzed relation to fourth normal form using the same requirements as in Question 5 (many sales reps can represent one customer and one sales rep can represent many customers)
Rep (RepNum, LastName, FirstName, Street, City, State, Postalcode,Commission, Rate, (CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit))
7. Is there any difference between the tables you created in Question 5 and 6? Why or Why not?