Star Schema Model Assignment Help
Are you searching for Star Schema Model Assignment Homework Help from Professionals? We provide the best assignment in Australia at Assignmenthelpaus.com. If you want Star Schema Model Assignment Help, contact our 100+ PhD/MBA writers. They provide the best assignment writing help without any Plagiarism at an affordable price. Our 24/7 live service always provides guidance for students. Hurry up; place your order now!
Assignment 3: Star Schema Model (15%)
Instructions
The below model is not complete and violates some modeling rules. Please complete a proper star schema model.
1. Make a Sales fact (complete attributes, at least 2 measures) and 4 Dimensions (Surrogate Key, Business Key, and at least more than one attribute in each dimension)
2. Complete Time Dimension: Try to come up with 8 attributes with a hierarchy structure (proper ordering of hierarchy)
3. Denormalize and Correct relationship
Please refer to the rubric at the end of this document for evaluation details.
Requirements
1. Formatting: no restriction
Any modeling aid tools, PPT, Visio or handwriting will be allowed.
2. Upload your completed paper to the Assignment 3 Star Schema Dropbox.
Evaluation
This assignment is graded out of 12 points using the following rubric and is worth 15% of the final grade.
Learners may receive partial scores or a zero for unacceptable work.
| Criteria | Does Not Meet Expectations 1 |
Partially Meets Expectations 2 |
Meets Expectations 3 |
Exeeds Expectations 4 |
Max Points |
| Fact and Dimensions | Inadequate completion of 1 sales fact and 4 dimensions | Partial completion of 1 sales fact and 4 dimensions | Completion of 1 sales fact and 4 dimensions. | Completion of 1 sales fact and 4 dimensions PLUS adding relevant extra attributes properly. | 4 |
| Time Dimension | Complete 3 or less attributes and no hierarchy in time dimension. | Complete 4-8 attributes and define a hierarchy in time dimension with all required components. | Add 8 attributes and define a hierarchy in time dimension with all required components. | Complete 8 attributes and define a hierarchy in time dimension with all required components PLUS add extra attributes. | 4 |
| Denormalize and Relationship | Complete denormalized dimensions with more than 5 violations of the modeling. | Complete denormalized dimensions with 3-5 violations of the modeling. | Complete denormalized dimensions with 1-2 violations of the modeling | Completed denormalized dimensions with no error in the modeling. | 4 |