Examine the bus matrix for a university shown in Figure 32.12. The university is organized as schools such as the School of Computing, School of Business Studies and each school has a portfolio of programs and modules. Students apply to university to join a program but only some of those applications are successful. Successful applicants enrol on university programs, which are made up of six modules per year of study. Student attendance at module classes is monitored as well as student results for each module assessment.

(a) Describe what matrix shown in Figure 32.12 represents.

(b) Using the information shown in bus matrix of Figure 32.12, create a first-draft, high-level dimensional model to represent the fact tables and dimensions tables that will form the data warehouse for the university.

(c) Using the information in Figure 32.12 produce a dimensional model as a star schema for the student module results business process. Based on your (assumed) knowledge of this business process as a current or past student, add a maximum of five (possible) attributes to each dimension table in your schema. Complete your star schema by adding a maximum of 10 (possible) attributes to your fact table. Describe how your choice of attributes can support the analysis of student result.