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

Perform algebraic operation , Perform each of the following algebraic expr...

Perform each of the following algebraic expression as instruction says;- I.Multiply 5x+6m+4y by5 II.Divide 4ax+6ay-10az by 2a

Defining real numbers, The numbers used to measure quantities such as lengt...

The numbers used to measure quantities such as length, area, volume, body temperature, GNP, growth rate etc. are called real numbers. Another definition of real numbers us

Melisa and jennifer threw a fiftieth how much is a 20% tip, Melisa and Jenn...

Melisa and Jennifer threw a fiftieth birthday party for their father at a local restaurant. While the bill came, Melisa added a 15% tip of $42. Jennifer said in which the service w

Determine boolean conjunctive query are cyclic or acyclic, Are the followin...

Are the following Boolean conjunctive queries cyclic or acyclic? (a) a(A,B) Λ b(C,B) Λ c(D,B) Λ d(B,E) Λ e(E,F) Λ f(E,G) Λ g(E,H). (b) a(A,B,C) Λ b(A,B,D) Λ c(C,D) Λ d(A,B,C,

Negative three and positive eight inclusive represent y, The value of y is ...

The value of y is among negative three and positive eight inclusive. Which of the subsequent represents y? This inequality displays a solution set where y is greater than or eq

Rate -categories of multiplication, Rate - when we know how many objects...

Rate - when we know how many objects are in a set, and need to find out the total number in several copies of that set. (e.g., if a child uses 4 copybooks in a year, how many co

Exponential and logarithm equations, Exponential and Logarithm Equations ...

Exponential and Logarithm Equations : In this section we'll learn solving equations along with exponential functions or logarithms in them. We'll begin with equations which invol

Steps for alternating series test, Steps for Alternating Series Test Su...

Steps for Alternating Series Test Suppose that we have a series ∑a n and either a n = (-1) n b n or a n = (-1) n+1 b n where b n > 0 for all n.  Then if,   1.

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