View the step-by-step solution to:

Question

dm.PNG

Phase 1. -

using the information shown in bus

matrix table, make a first-draft, high-level dimensional model to represent the fact table and dimensions tables that will form the data warehouse for the university.

phase 2 - Identify all dimension and fact attributes for the DM

Using the information in the BUS matrix table, produce a dimensional model as a star schema for the student module results business process. (only one DATA MART)

A. Based on your (assumed) knowledge of this business process as a current or past student, add a maximum of five (possible )attributes to each dimension table in your schema.

b.The star schema by adding a maximum of 10(possible) attributes to your fact table.

c. Describe how your choice of attributes can support the analysis of student result.

dm.PNG

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes