- Intuitive Design Of A Data Cube From A Conceptual Schema Of An Operational Database Consider The Following Conceptual Sc 1 (147.84 KiB) Viewed 67 times
hierarchies, and therefore find the data cube.
Intuitive design of a data cube from a conceptual schema of an operational database Consider the following conceptual schema of an operational database owned by a multinational real estate company. The database contains information about the real estate properties offered for sale, owners of the properties, potential buyers who are interested in the properties and real estate agents involved in selling of the properties. AGENT employee-number ID phone-number ID2 first-name last-name 1 Involved in 1..* BUYER phone number ID first-name last-name country city Owns REAL-ESTATE-PROPERTY bldg-number ID Interested in street ID 1..* city ID country ID price-asked date-when-on-market OWNER phone number ID first-name last-name country * 1..* city Whenever a property is put on a market by an owner, a description of the property is entered into an operational database. Whenever a property is purchased, its description is removed from an operational database. The real estate company would like to create a data warehouse to keep information about the finalized real estate transactions, properties involved in the transactions, sellers/owners, and agents involved in the real estate transactions. The real estate company would like to use a data warehouse to implement the following classes of analytical applications. (1) Find the total number of real estate properties sold per month, year, street, city, country, agent involved. (2) Find an average asked price of real estate properties sold per month, year, street, city, country, agent involved. (3) Find an average final price of real estate properties sold per month, year, street, city, country, agent involved. (4) Find an average period of time on the marked of real estate properties sold per month, year, street, city, country, agent involved. (5) Find the total number of times each real estate property has been sold in a given period of time. (6) Find the total number of buyers interested in purchases of real estate properties sold per day, month, year, street, city, country, agent involved. Note, the operational database does not contain all information necessary to implement the classes of applications listed above. Additional information must be added when data is transferred from an operation database to a data warehouse. (1) Use a short explanation of a database domain and a conceptual schema given above, to find a data cube, that should be implemented by the multinational real estate company to create a data warehouse. In your specification of a data cube, list the facts, the measures, the names of dimensions and the hierarchies.