CSPP 53017: Assignment 2

Due by 1:59am on Tuesday, February 5, 2013

Star schema (first draft)

Based on your draft proposal, design a draft star schema for at least 4 different subjects (at most 2 can be aggregated). The actual model will depend on your project but normally you should have between 3 and 10 dimensions. Note that not all dimensions will be relevant to each subject.

You can use any design or drawing software tools but we recommend the online tool ERDPlus: https://erdplus.com/.

You will submit your draft star schema by emailing your first draft as a PDF to the instructor. Please, use the following title for your submission CSPPDW_P2.


There is no Gradiance Problem Set