Assignment 3

You have to create one fact table with attributes and

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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. Project Originality This project is to be done individually. You are reminded of Policy #69 and other University Regulations that strictly prohibit non-...
View Full Document

Ask a homework question - tutors are online