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

If field of his patio is 195 what is the length of diagonal, Patrick has a ...

Patrick has a rectangular patio whose length is 5 m less than the diagonal and a width which is 7 m less than the diagonal. If the field of his patio is 195 m 2 , what is the lengt

Test of hypothesis about the population mean, Test of hypothesis about the ...

Test of hypothesis about the population mean When the population standard deviation (S) is identified then the t statistic is defined as             t = ¦(x¯ - µ)/ S x¯ ¦

Compute projection scale factor, 1. A survey line on campus is measured to ...

1. A survey line on campus is measured to be 1000.00 ft long on horizontal ground. The elevation of the line is 700.00 feet and the geoid separation from ellipsoid to geoid is -110

Cartesian graph of density of water - temperature, Cartesian Graph of Densi...

Cartesian Graph of Density of Water - Temperature: Example:  The  density  of  water  was  measured  over  a  range  of  temperatures.   Plot the subsequent recorded data on

Chanllenge, apzza driver delivered 27 pizzas in one night he delivered more...

apzza driver delivered 27 pizzas in one night he delivered more then one pizza to only one house . every other hhouse he only delivered pizza to 18 houses . how many pizzas did he

How many different words can be formed out from varanasi, Determine how man...

Determine how many different words can be formed out of the letters of the word VARANASI? Ans: 720 different words can be formed out of the letters of the word VARANASI.

Chanllenge, a pizza driver delivered 27 pizzas in one night he delivered mo...

a pizza driver delivered 27 pizzas in one night he delivered more then one pizza to only one house . every other house he only delivered pizza to 18 houses . how many pizzas did he

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