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

Case study, considring the concept of product life cycle,where would you pu...

considring the concept of product life cycle,where would you put viedo games in thier life cycle?

Squeeze theorem (sandwich theorem and the pinching theorem), Squeeze Theore...

Squeeze Theorem (Sandwich Theorem and the Pinching Theorem) Assume that for all x on [a, b] (except possibly at x = c ) we have,                                 f ( x )≤ h (

Find out the surface area of the solid - parametric curve, Find out the sur...

Find out the surface area of the solid acquired by rotating the following parametric curve about the x-axis. x = cos 3 θ y = sin 3 θ  0 ≤ θ ≤ ?/2 Solution We wil

Transportation problems vogel approximation method, if there is a tie betwe...

if there is a tie between two penalties then how to make allocations?

Subsets of real numbers, is it true or false that all whole numbers are rat...

is it true or false that all whole numbers are rational numbers

Find the interval of validity, Solve the subsequent IVP and find the interv...

Solve the subsequent IVP and find the interval of validity for the solution. y' + (4/x) y = x 3 y 2 ,       y(2) = - 1,  x > 0 Solution Thus, the first thing that we re

Explain lobachevskian geometry and riemannian geometry, Explain Lobachevski...

Explain Lobachevskian Geometry and Riemannian Geometry ? Nineteenth century mathematician Nicolai Lobachevsky assumed that the summit angles of a Saccheri quadrilateral are ac

Vertical tangent for parametric equations, Vertical Tangent for Parametric ...

Vertical Tangent for Parametric Equations Vertical tangents will take place where the derivative is not defined and thus we'll get vertical tangents at values of t for that we

How is probability distribution of random variable construct, How is the pr...

How is the probability distribution of a random variable constructed? Usually, the past behavior of the variable is studied and the frequency distribution of the past data is form

How much did he have in savings at the starting, Bill spent 50% of his savi...

Bill spent 50% of his savings on school supplies, and then he spent 50% of what was left on lunch. If he had $6 left after lunch, how much did he have in savings at the starting?

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