Business Intelligence (BI) assignment using SQL Server

Business Intelligence (BI) Assignment using SQL Server 2008 or 2012 versions If you have experience with SQL server and Kimball’s Business Dimensional Lifecycles, then this will be simple for you. The database has already been created including all tables with all data inside, but the diagram for needs to be created and add these tables to it. I will send you this database. There are 4 parts; the part 1 has already been answered. The part 2’s first 2 questions are answered too. I’m using SQL Server 2008, when you complete the work you need to send me the database to attach to my server. Most of the parts have a helpful example inside which I will send you later. I will also send you an answer of a same assignment done before for a different company which is 90% same as this one. Description and all the questions for the assignment in pdf attached below: