Suppose that a data warehouse for Big-University consists of the following four dimensions: student, course, semester, and instructor, and two measures count and avg grade.

1. Suppose that a data warehouse for Big-University consists of the following four dimensions: student, course, semester, and instructor, and two measures count and avg grade. When at the lowest conceptual level (e.g., for a given student, course, semester, and instructor combination), the avg grade measure stores the actual course grade of the student. At higher conceptual levels, avg grade stores the average grade for the given combination.

 

Required;

(a) Draw a snowflake schema diagram for the data warehouse. [10Marks]

 

(b) Starting with the base cuboid [student, course, semester, instructor], what specific OLAP operations (e.g., roll-up from semester to year ) should one perform in order to list the average grade of CS courses for each Big-University student. [3Marks]

 

 

(c) If each dimension has five levels (including all), such as “student

(show your workings)

 

2. The following table consists of training data from an employee database. The data have been generalized. For example, “31 . . . 35” for age represents the age range of 31 to 35. For a given row entry, count represents the number of data tuples having the values for department, status, age, and salary given in that row.

find the cost of your paper

The 4th Amendment

The 4th Amendment The Fourth Amendment to The Constitution of the United States reads: “The right of the people to be secure in their persons, houses, papers, and effects, against….

Execution, Monitoring, and Controlling

Execution, Monitoring, and Controlling Assignment Overview: For this assignment, you will be assessing a proposed change to the scope of the project, proposing an overview of a change management process,….

Law of Associations

Law of Associations assignment 2000 words excluding bibliography. Compulsory Assignment Question Bathroom Design Pty Limited (in liq) (Company) was wound up in September 2021. The Company operated a business of….