The following questions relate to databases and Business Intelligence. Online transaction processing systems and business intelligence systems differ in several important aspects. Discuss two of these...

The following questions relate to databases and Business Intelligence.

1. Online transaction processing systems and business intelligence systems differ in several important aspects. Discuss two of these differences using the example of a university student-focused data warehouse and how it differs from the university student records system.

Data cleaning (cleansing) is particularly important in preparing data for a data warehouse. Explain, using the example of data being imported for a customer data warehouse from three different customer-focused operational systems that had been developed by different departments in the organisation.