Draw a lattice hierarchy for dimension, Mathematics

Assignment Help:

New England University maintains a data warehouse that stores information about students, courses, and instructors. Members of the university's Board of Trustees are very much interested in students' academic performance as well as instructors' teaching effectiveness. For example, they may like to know:

  • The average grades for different courses taught by different instructors.
  • The grade distribution for a particular course in a particular semester (e.g., a newly offered MBA course).
  • The average ratings of teaching effectiveness for instructors at different ranks (e.g., Lecturer, Assistant Professor, Full Professor, etc.).
  • The correlation between students' grades and their ratings for instructors' teaching effectiveness.

 

Note that each undergraduate student must declare his/her major and up to two minors by the end of the junior year. A graduate student may have a major (e.g., MBA) and a minor or concentration (e.g., IT).  Some courses (e.g., undergraduate GB courses) may be "co-offered" by several departments. An instructor may be affiliated with more than one department.

1. Draw the two star schemas and specify all relevant attributes.

2. Identify conformed dimensions.

3. Identify any slowly changing dimensions and the attributes whose values may change from time to time.

4. Draw a lattice hierarchy for each dimension that has more than one level.


Related Discussions:- Draw a lattice hierarchy for dimension

Homogeneous odes, how do you solve a homogeneous ode that''s not in a multi...

how do you solve a homogeneous ode that''s not in a multiplication or division form

What was the original price of the frying pan, Cory purchased a frying pan ...

Cory purchased a frying pan which was on sale for 30% off. She saved $3.75 along with the sale. What was the original price of the frying pan? Use a proportion to ?nd out the o

Harmonic progression (h.p.), Three quantities a, b and c are said to ...

Three quantities a, b and c are said to be in harmonic progression if, In this case we observe that we have to consider three terms in o

Reflection matrix, how do i solve reflection matrix just looking at the num...

how do i solve reflection matrix just looking at the numbers in a matrix

Trignometry, whta are the formulas needed for proving in trignometry .

whta are the formulas needed for proving in trignometry .

Algebra function., problem to understand an problem; f(X-2)=X+3 / X-4

problem to understand an problem; f(X-2)=X+3 / X-4

Methods of sampling, a.      Random or probability sampling methods they in...

a.      Random or probability sampling methods they involve: Simple random sampling Systematic sampling Stratified sampling Multi stage sampling   b.

Relationship between the graph and inverse function, Interesting relationsh...

Interesting relationship between the graph of a function and the graph of its inverse : There is one last topic that we have to address quickly before we leave this section.  Ther

Intervals of validity, I've termed this section as Intervals of Validity si...

I've termed this section as Intervals of Validity since all of the illustrations will involve them. Though, there is many more to this section. We will notice a couple of theorems

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd