Data Model and Data Warehouse Design Architecture & XML - Essay Example

be fully compliant with all the building laws and regulations, the company certifies the application and changes the status of the application to ‘Certified’. After certifying the plans, the company lodges the plans with the relevant Council for approval; the status of the application at this stage is changed to ‘Lodged’. Once the plans are approved by the Council, the status of the application becomes ‘Approved’, indicating that the building work can commence. Upon completion of the building work, the company inspects the building to ensure that the building work has strictly followed the plans.

In case if the building work in not found satisfactory, the company gives instructions to the client that must be followed in order to make the building work satisfactory. The company inspects the building until the work is found satisfactory – means any building work can be inspected several number of times. Once all the building work is finalized and found satisfactory by the company, the status of the application changes to ‘Closed’. A single application may cover multiple building works, and each building work may have a different type (which may be residential house, car port, shed, commercial building etc.), and a class (which may be 1A, 1B, 1C, 2, 3, 4 or 5).

The Director of the company is interested to deploy a data warehouse system which can provide analytical views in form of reports, containing data, graphs, and charts, to help the top management in making effective business decisions to increase the productivity, in other words, sales of the company. The company already has a centralized database in which it maintains all the information related to its staff, customers, councils, and applications. This centralized database is a relational database which will represent the information source for the data warehouse in this