Question 4
Read the following scenario:
Foundry University is a university based in London, UK. The university keeps student records on its Student Records System, a multi-user relational database. This has such information as the local authority that the student originated in, the type of school that they attended as well as their modules, grades and eventually their final degree classification. Once students have left, their record is kept on the live system for two years before being archived unto a Student Archive System which is a duplicate of the student record system in terms of its structure.
The Alumni (former student) Office sends out a magazine to all ex-students and keeps information about them such as what they have done since leaving the university and what their current job is. The Alumni Office has built itself a small stand-alone database, with data being gathered from a report from the Student Archive System and from a regular questionnaire it sends out to ex-students.
In order to make decisions about the allocation of resources, the government has asked that the university provide information on certain trends. The government needs to know how current students are progressing, and what sort of jobs past students got and how this is affected by such factors as their local authority, their school, and what degree subject they followed.
Critically assess the advantages and disadvantages that the implementation of a data warehouse might have for Foundry University.
Students succeed in their courses by connecting and communicating with an expert until they receive help on their questions
Consult our trusted tutors.