MPCS 53017: Dimensional Modeling 1
Due on Monday, February 17, 2014
Dimensional Model (Star schema)
Based on your revised proposal, design a draft star schemas 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/.
Please, name the schema file star.pdf or, if there are
multiple files, star1.pdf, start2.pdf, etc.
Address the following points in a separate document, named dm1:.
- Did you have to make any interesting design decisions while designing your star schema.
- Connect key questions with star schemas: Review the key
questions that you listed as candidates to be analyzed using your
proposed data warehouse. For each question, identify the appropriate
fact table and dimension tables from your star schemas. For bonus
points, write several SQL queries that find the answers to
some of questions.
- Connect data sources with dimension and fact tables:
Review the data sources you listed in your proposal. 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?
You will submit your proposal via phoenixforge. Please, add all of
the relevant files in the reports directory and commit them.