A simple project - 02/05/2018 04:32 EDT

Create a Project Report that will satisfy and answer the following: 1 Based on the above OLTP system, what dimensions can be identified? 2 What are the measures and grain? 3 Create a graphic diagram using either Visio or taking a screen shot 4 Create the SQL statements for the data base schema that will build the dimension and fact tables. 5 Populate the dimension tables with some sample data. The detailed are in the file.