Data Sheet 5

profilemaryal11
Home>Homework Answsers>Computer Science homework help

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?

 

 

 

 

 

Text Box: Annex 1:   

  • 10 years ago
  • 15
Report issue
Answer(1)
profile
nyamaimule
4.5 (435)
5.0 (4)
Chat

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    exercise_three.docx
Bids(1)