Task 1 6 Marks Intuitive Design Of A Data Cube From A Conceptual Schema Of An Operational Database Consider The Follow 1 (144.61 KiB) Viewed 85 times
Task 1 (6 marks) 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 ID1 phone-number ID2 first-name last-name BUYER phone-number ID first-name last-name country city 1 Involved in 1. .* REAL-ESTATE-PROPERTY bldg-number ID Interested in street ID 1..* city ID country ID price-asked date-when-on-market - Owns 1. .* OWNER phone-number ID first-name last-name country 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.
(2) Pick any three dimensions from a data cube found in the previous step and at least 4 values in each dimension and one measure to draw a sample three-dimensional data cube in a perspective view similar to a view included in a presentation 09 Data Warehouse Concepts, slide 6. Deliverables A file solution1.pdf that contains (1) a specification of data cube as a list of facts, measures, dimensions, and hierarchies obtained as a result of task (1), (2) a perspective drawing of three-dimensional data cube as a result of task (2).
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!