CSPP 53017: Assignment 3
Due by 11:59pm on Friday, February 15, 2013
Project proposal (revised) and data model
Your revised proposal should contain the following parts:
- Project description (1-2 paragraphs)
- Star schemas (revised) and notes on any interesting design decisions you had to make
- What are the key questions that can be analyzed using your
proposed data warehouse? For each question, identify the appropriate
fact table and dimension tables from your star schemas.
- What are the data sources that you would like to use? For each
data source, identify the tables in your star schemas that will likely
be populated using its data. Are there any tables that will likely be
populated from multiple data sources?
For you star schema you can use any design or drawing software tools but we recommend the
online tool ERDPlus: https://erdplus.com/.
You will submit your revised project proposal and data model by emailing them as PDF documents (a single document that contains both the proposal and the star schemas is also ok) to the instructor. Please, use the following title for your
submission CSPPDW_P3.
There is no Gradiance Problem Set