(solution) The RR University provides tuition to degree level to 12,000 students, both on campus and by

(solution) The RR University provides tuition to degree level to 12,000 students, both on campus and by

The RR University provides tuition to degree level to 12,000 students, both on campus and by distance learning courses. The University has 34 different departments, each specialises in one specific area, such as economics, geography or astronomy. Over the past 10 years, information systems have been developed in each department to meet the specific needs of that department. However, the systems are incompatible with each other and use a wide range of software applications. The information systems are becoming expensive to operate, as well as requiring duplication of input where students study in more than one department. Additional duplication occurs when student details have to be entered into the central University database, which is used for monitoring total student numbers. The Board of Management of the University has decided that the University should develop and implement an integrated database for future information requirements and place all existing data into a single data warehouse. Moreover, any new system must meet the information requirements of the central database as well as those of the individual departments. Requirements (i) Evaluate the use of data within the University. (ii) Explain how the Board of Management should use Critical Success Factors (CSFs) in revising the current information system. Discuss the disadvantages of data warehousing with specific reference to the situation at the RR University.