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.
(a) Following the establishment of analytical themes, the business processes that are associated with them (e.g. capture data) are identified. For example, analysis of student attendance will be possible using the business process that records attendance of each student at each module class. The university may have a KPI (Key Performance Indicator) that requires that students must attend at least 80% of classes for each of their modules. The university’s business processes are listed down the x-axis , while the columns of the y-axis represent the objects (dimensions) that participate in the business processes and can be used to support multi-dimensional analysis of these process.
(b) The student should present a rough design that shows each business process (listed down first column) represented by a fact table and each fact table surrounded by associated dimensional tables (listed across the top row). For example the Student Module Attendance fact table will be linked to Time, Student, Program, University School, Staff and Module dimension tables.
(c) factStudentModuleResult(resultID (PK), date (FK), studentID (FK), programID (FK), universitySchoolID (FK), staffID (FK), moduleID (FK), courseworkMark, examMark, totalMark, grade, attempt) dimDate(date (PK), dayOfWeek, week, month, trimester, season, year) dimStudent(studentID (PK), studentNo, studentName, studentHomeAddress, studentDOB, studentGender, campus)
dimProgram(programID (PK), programCode, programName, programLeader,
programSchoolName, programDuration) dimUniversitySchool(universitySchoolID (PK), universitySchoolName, universityHeadOfDepartment) dimStaff(staffID (PK), staffName. staffGender, staffPosition, staffJoin, staffCampus, staffDOB)
dimModule(moduleID (PK), moduleCode, moduleName, moduleCreditLevel,
moduleCreditValue, moduleLeader, universitySchoolID, universitySchoolName)
You might also like to view...
Answer the following questions true (T) or false (F)
1. size and capacity of a vector are two names for the same thing. 2. Assignment behaves essentially the same for vectors as for arrays.
________ are database objects that provide a method of automating routine database tasks
Fill in the blank(s) with correct word
In a(n) ____ loop, the condition is tested before any statements in the loop are executed.
a. posttest b. pretest c. prior d. early-test
A chipset goes with one or more particular processors
Indicate whether the statement is true or false