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

Triangle treat, what letters to fill in the boxes

what letters to fill in the boxes

Compute steady state value of capital - solow growth model, Consider the So...

Consider the Solow growth model as given in the lecture notes using the Cobb-Douglas production function Y t = AK 1-α t L α t a) Set up the underlying nonlinear differen

Find the total cost of the shop of arithmetic progressions, Raghav buys a s...

Raghav buys a shop for Rs.1,20,000.He pays half the balance of the amount in cash and agrees to pay the balance in 12 annual instalments of Rs.5000 each. If the rate of interest is

Find the solution to initial value problem, Illustration:   Find the soluti...

Illustration:   Find the solution to the subsequent IVP. ty' + 2y = t 2 - t + 1,      y(1) = ½ Solution : Initially divide via the t to find the differential equation in

Numerical analysis, Please,I Want to know and study for stability on predi...

Please,I Want to know and study for stability on predictor -corrector for numerical integration method

Ratios, a doctor sees 3 boys to 5 girls in one week . If he sees 40 boys in...

a doctor sees 3 boys to 5 girls in one week . If he sees 40 boys in one day then how many girls does he see that day

Fractions, What fraction could you add to 4/7 to get a sum greater than 1

What fraction could you add to 4/7 to get a sum greater than 1

Area and perimeter, a garden is constructed with a 3ft patio all around how...

a garden is constructed with a 3ft patio all around how would you give the expression for the area of the garden, excluding the patio

Determine the property of partial ordered relation, Determine the property ...

Determine the property of Partial ordered relation Question: Partial ordered relation is transitive, reflexive and  Answer: antisymmetric

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