Wholesale Electronics Exercise Data Warehouse design for a wholesale furniture

onsourt91l

Design the data warehouse for a wholesale furniture company. The data warehouse has to allow to analyze the company’s situation at least with respect to the Furniture, Customers and Time. Moreover, the company needs to analyze:
1.the furniture with respect to its type (chair, table, wardrobe, cabinet. . . ),
category (kitchen, living room, bedroom, bathroom, office. . . ) and
material (wood, marble. . . )
2.the customers with respect to their spatial location, by considering at least cities, regions and states
The company is interested in learning at least the quantity, income and discount of its sales.
1. Identify facts, dimensions and measures
2. For each fact:
. produce the attribute tree and fact schema
. design the star or snowflake schema and write the following
SQL queries:
1. Find the quantity, the total income and discount with respect to each city, type of furniture and the month
2. Find the average quantity,Wholesale Electronics, income and discount with respect to each country, furniture material and year
3. Determine the 5 most sold furnitures during the May month
你的解决方案是：
-------------------------by Mirjana Mazuran.
相关的主题文章：

  
   China Wholesale Electronics Why are Australian Banks exposed to bad US mortgages
  
   Wholesale Electronics Wholesale prices rising at fastest pace since 1981
  
   Wholesale Video Games Wholesale prices rising at f
  
   Wholesale Video Games Wholesale prices rising at fastest pace since 1981
  
   Video Games Accessories Wholesale prices rising at fastest pace since 1981

luluquan

A sow that is washed goes back to her wallowing in the mire.

juntakashi

语法错漏百出
The data warehouse “has to be allowed” to analyze ...............吧

PS：SQL database queries 这种东西真不是人学的，不是一般的难懂