Designing a Data Warehouse Managers in Purchasing department, asked you (the analytics department) to provide information on a. How many purchase orders was authorized by your company buyers? b. What was the total amount of purchases or discount for a specific year/month or years/months authorized by your company buyers? c. What was the total amount of purchases from vendors and who authorized the purchases? You know that for providing the requested information, you need to build a data warehouse from purchasing database and then providing requested information by using a pivot table tools. Use the purchasing database shown below and build the required data warehouse. PO PO NO Document Date Posting Date Status Delivery Date Total Amount Discount Vendor ID (FK) Buyer ID (FK) PO No Item No Quantity PO Line (FK) Unit Price Line total Vendor Vendor ID Vendor Name Buyer Buyer ID Buyer Name Item No Item Desc Item