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

Solving decimal equations, The distance around a square photograph is 12.8 ...

The distance around a square photograph is 12.8 centimeters. What is the langth of each side of the fotograph?

Complex eigenvalues, It is the last case that we need to take a look at. Th...

It is the last case that we need to take a look at. Throughout this section we will look at solutions to the system, x?' = A x? Here the eigenvalues of the matrix A are compl

Find the limit of given matrix, What is required: This assignment is to be ...

What is required: This assignment is to be resolved using Maple. You are to upload a single Maple worksheet with file name FamilynameFirstname.mw (e.g., CarrElliot.mw), using the A

Bricklayer estimates 6.5 how many bricks will he required, A bricklayer est...

A bricklayer estimates that he requires 6.5 bricks per square foot. He needs to lay a patio that will be 110 square feet. How many bricks will he required? Multiply 6.5 by 110;

Shares and dividends, suresh invested rs.1080 in shares of face value rs.50...

suresh invested rs.1080 in shares of face value rs.50 at rs.54.After receiving dividend on them at 8% he sold them at 52.In each of the transaction he paid 2 % brokerage.Hpw much d

Graphical method for interpolation, Graphical Method Whil...

Graphical Method While drawing the graph on a natural scale, the independent variables are marked along the horizontal line and corresponding dependen

Children learn maths by experiencing things, Children Learn By Experiencing...

Children Learn By Experiencing Things : One view about learning says that children construct knowledge by acting upon things. They pick up things, throw them, break them, join 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