MIS 350 QUIZ 3

Q1. [30 points] a. What does GUST’s Star schema look like if the analysis aims at answering the following

questions: b. Study the reasons behind students’ deteriorating performance. c. What kind of queries the schema in (a) can answer? Make a list.

Q2. [30 points] Given the following table of weather transaction entries, you need to derive

at least 4 rules to predict the classification variable “class”

Q3. [20 points] Discuss 3 businesses that utilize business intelligence solutions in their organizations. You need to explain how the BI tools have been used within those businesses.

Q4. [20 points] Given the transaction table below, extract all associations that have support above 80% (see

the lecture video)