This preview shows page 1. Sign up to view the full content.
Unformatted text preview: rehouse. You have to create
one fact table (with attributes) and at least four dimension tables (with attributes). You can assume
additional attributes (not mentioned in the project description) in the dimension and fact tables. Marks
will be awarded based on impact on decision making (i.e. coming up with truly useful dimension tables
and selecting the appropriate attributes so management can make powerful and useful decisions).
The assignment can be hand drawn or be drawn using Visio/Microsoft Access.
You need NOT populate the schema with any data. Just show the “tables” and attributes. Please state
clearly the meaning of each attribute if not immediately clear. Also state clearly your assumptions.
This project is to be done individually. You are reminded of Policy #69 and other University Regulations
that strictly prohibit non-...
View Full Document
- Spring '14