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

Basic, 8l550ml - 1/4l =

8l550ml - 1/4l =

The normal approximation to the binomial , A certain flight arrives on time...

A certain flight arrives on time 78% of the time. Suppose 1000 flights are randomly selected. Use the normal approximation to the binomial to approximate the probability that

Mathematics- in our lives , MATHEMATICS - IN OUR LIVES : What is the mo...

MATHEMATICS - IN OUR LIVES : What is the most obvious example of mathematics in your life? To many of us it is the maths that we studied in school. But is that all the mathemat

Simple interest, write a program C++ programming language to calculate sim...

write a program C++ programming language to calculate simple interest, with it algorithm and it flowchart

Tent originally sold for $2 what is the percent of discount, A tent origina...

A tent originally sold for $260 and has been marked down to $208. What is the percent of discount? Find out the number of dollars off. $260 - $208 = $52. Further, determine wha

Factor expressions involving large powers, Factor Expressions Involving Lar...

Factor Expressions Involving Large Powers, Radicals, and Trig Functions You can use substitution to factor expressions involving large powers, radicals, and trig functions

Accuray and Precision, If an instrument has precision of +-1, can it detect...

If an instrument has precision of +-1, can it detect a value of 1.3?

Probability, There are 20 defective bulbs in a box of 100 bulbs.if 10bulbs ...

There are 20 defective bulbs in a box of 100 bulbs.if 10bulbs are choosen at random then what is the probability of there are just 3defective bulbs

Introducing counting, INTRODUCING COUNTING : From what you studied previou...

INTRODUCING COUNTING : From what you studied previous study, you know what it means to count. You would also agree that rote learning of number names does not always mean that the

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