London Metropolitan University is composed of various departments with each department offering a variety of courses....

Transcribed Image Text:

London Metropolitan University is composed of various departments with each department offering a variety of courses. Each course consists of a set of modules, which are taken in either of the semesters. The university library provides services to students that enable books, journals, videos, etc. to be borrowed upon validation of their registration details (i.e. Student ID). This can either be done online through the university's website or directly from the library counter. The library ensures a vast and comprehensive array of study materials (books, journals, videos, etc.) is provided for each course module. Students are then allowed to keep the book for a specified period after which a fine is incurred if the deadline is exceeded. The borrowed materials can however be renewed before the expiry date. However, library management needs a data warehouse application that can help support various key decisions that will, in turn, improve services offered to students. (a) In line with a data warehouse being subject-oriented, using the above scenario, identify what the "key focus" of this data warehouse application should be. (7 Marks) (b) Identify all the dimensions for the data warehouse application. Considering your answer from question (a), identify at least 2 facts (or measures) that will be contained in the fact table. (NOTE: Any assumptions should be clearly stated.) (8 Marks) (c) Draw a simple star schema for the above data warehouse showing only the primary key- foreign key relationships. (10 Marks) London Metropolitan University is composed of various departments with each department offering a variety of courses. Each course consists of a set of modules, which are taken in either of the semesters. The university library provides services to students that enable books, journals, videos, etc. to be borrowed upon validation of their registration details (i.e. Student ID). This can either be done online through the university's website or directly from the library counter. The library ensures a vast and comprehensive array of study materials (books, journals, videos, etc.) is provided for each course module. Students are then allowed to keep the book for a specified period after which a fine is incurred if the deadline is exceeded. The borrowed materials can however be renewed before the expiry date. However, library management needs a data warehouse application that can help support various key decisions that will, in turn, improve services offered to students. (a) In line with a data warehouse being subject-oriented, using the above scenario, identify what the "key focus" of this data warehouse application should be. (7 Marks) (b) Identify all the dimensions for the data warehouse application. Considering your answer from question (a), identify at least 2 facts (or measures) that will be contained in the fact table. (NOTE: Any assumptions should be clearly stated.) (8 Marks) (c) Draw a simple star schema for the above data warehouse showing only the primary key- foreign key relationships. (10 Marks)

Answer rating: 100% (QA)

Solution a The key focus of the data warehouse application for London Metropolitan University should be supporting decisionmaking related to library services and materials availability for students Th... View the full answer