Data Sheet 5
Exercise1
1. FillinwithrecordsthetablesdescribedintheschemafromAnnex1(drawthetableswith thedata yourdatain them).
2. WriteanSQLselectquery,whichappliestheCubeoperatoronall3dimensions,Cube(Week,Store,Group)ofthedatabaseinAnnexe1withtherecordsyouhave filledatExercise1, andthenpresenttheresult ofthequeryasatable.
3. WriteanSQLquerywhichretrievesthetop3sellingproductgroupsinFebruary,inBraunschweig.
4. WriteanMDXqueryperformingthesametaskasexercise1.3(thepreviousexercise).
Exercise2
5. What kindofaschemaispresented inAnnex1?
6. Inwhichcaseshouldweconsidermigratingfromasnowflakeschematoastarschema?
7. Consideringthattheproductdimensionissubjecttooftenchange,howwouldyou transform(draw)theschemainAnnex1,intoaStarflakeone?
10 years ago 15
Purchase the answer to view it
- exercise_three.docx
- BUSINESS STATS HOMEWORK HELP DUE IN ONE HOUR!
- week 4 discussion 2 POL 201
- Analytics Case 2
- Pastina Company manufactures and sells various types of pasta to grocery chains as private label brands.
- principle or disease
- The skin
- sales Management Powerslides
- Project4
- “The Capital Asset Pricing Model (CAPM)’ has dominated academic literature and greatly influenced the practical world of finance and business...
- In order to answer this question you will need to have the text book, Fundamentals of Corporate Finance, 11th Edition...