Question 1. A building maintenance company has installed a decision support system to support various activities of this building maintenance company and its customers. Part of the decision support system of this building maintenance company is an expert system to provide information and advice to customers that wish to renovate their buildings. The database of this building maintenance company contains the costing for building renovation and maintenance of all buildings completed by this company in the past ten years.
1.1 Describe the data and knowledge that is required for this expert system to assist customers in their building renovations. Provide an example to clarify your answer.
(5 marks)
1.2 A data warehouse is created as part of the decision support system of this building maintenance company. This data warehouse contains all data collect by this company in the past ten years about renovation cost and time taken to renovate a building based on the required renovation work for each building that is renovated by this company. Explain how the data stored in this data warehouse of the decision support system of this building maintenance company can assist this company to provide time estimation to complete required renovations for its customers?
(5 marks)
1.3 Describe the importance of data quality for the data stored in a data warehouse of this company.
(5 marks)
Question 2. A university stores its student enrolment data in its student database and its staff performance data in its staff database. The university housing database has a database that contains data about student housing and the maintenance of the students housing buildings of this university. All databases are separate and unintegrated in this university. This university has purchased a decision support system to assist in its decision making about its student, staff and all its student housing and building maintenance. The university intends to use data visualization and data mining to assist the university in its decision making about student, staff and its building maintenance.
2.1 Explain problems that can occur in obtaining data from different university databases to support complex decisions relating to the university student, staff and its student housing and building maintenance. Provide an example to clarify your answer.
(5 marks)
2.2 This university intends to create a data warehouse to store all its student, staff and its student housing and building maintenance data in that data warehouse. Explain how a data warehouse containing such data can assist the university in its decision making and data visualization about student, staff and its student housing and building maintenance as well as monitoring of university staff performance.