Question: Download the file Task_2_Code.sql to your computer and import it to your LDD account. The file will create a data warehouse for a sales schema

 Download the file "Task_2_Code.sql" to your computer and import it to

Download the file "Task_2_Code.sql" to your computer and import it to your LDD account. The file will create a data warehouse for a sales schema with five dimension tables (W_CUSTOMERS, W_PRODUCTS, W_STORES, W_SUPPLIERS, W_TIME) and one fact table (W_FACTS). The data warehouse covers the time period from January to December 2014. Use this schema to answer the following questions: 1- Write several queries to display the number of records in each table. 2- Which product generated maximum sales in Dec, 2014? 3- Which store produced highest sales in the whole year

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!