(Solved): data and make decisions. Figure 1. Northwind 5 and 6 OLTP Schema Your task is to perform the follow ...

data and make decisions. Figure 1. Northwind 5 and 6 OLTP Schema Your task is to perform the following tasks to design and populate a data warehouse with a DQ assurance embedded ETL process. Task 1: Design an OLAP Schema what columns, PKs, and FKs are needed. You are not required to submit your schema. It is highly recommended that you: - De-normalize Suppliers into Products table, as the suppliers are not needed in the OLAP analysis. - Have a dimension table for Categories.