Question: In this task you will take an OLTP data source and convert it into an OLAP design. Please note the deliverables below and the questions

In this task you will take an OLTP data source and convert it into an OLAP design. Please note the deliverables below and the questions your OLAP must be able to answer. Deliverables 1. A word document containing 1. Database Table Design This should be done in draw io or another graphical program. DO NOT USE THE GRAPHCAL PROGRAM IN WORKBENCH 2. The SQL queries that answer the questions below 3. Statement of Granularity for the fact tables 4. Statement of Dimensional History applied to each dimension table. NOTES/HINTS 1. Please do a one fact table design. Questions to answer via SQL from your OLAP 1. The number of products sold by a given category 2. Total Amount sold by buyer for a given month

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

This assignment supports the research project that will be completed in Assignments 3 and 4 by developing analytical skills and a greater familiarity with nonexperimental research designs,...

FORMATIVE ASSESSMENT 2 [100 Marks] Answer ALL the questions in this section. QUESTION 1 Study the extract below and on the basis of the requirements specified for the proposed study answer all the...

PROJECT SCOPE [Instructions for what to include in this section: Define the scope of work that will be undertaken to provide the deliverable(s) mentioned in the Project Charter (PC). Craft this...

1 of 6 Assign-02: Writing a Linux Utility (encodeInput) Description This assignment has you writing a different utility for Linux. This utility (officially called a filter in UNIX / Linux) could be...

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

Assessment Details Qualification Code/Title ICT50220 Diploma of Information Technology Assessment Type Assessment -01 (Written Questions) Time allowed Due Date Location AHIC Term / Year Unit of...

KINGS OWN INSTITUTE* Success in Higher Education ICT106 DATA COMMUNICATIONS AND NETWORKS T223 Page 1 of 18 AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD ABN: 72 132 629 979 CRICOS 03171A...

Instructions to the Candidates This assessment is to be completed according to the instructions given below in this document. Should you not answer the tasks correctly, you will be given feedback on...

This is a individual assignment, which is due on 27th of jan, wed, 1pm. Can u help me to do it? Financial Accounting 2 ACG 27, Study Period 4, 2015 Case Study for Annual Report Assignment The...

BNS Company has been expanding rapidly. Its last two acquisitions were Best Choice Limited and Designers Limited. Both acquisitions are firms engaged in production and distributive of famous lines of...

Use the Lagrange interpolation formula to show that if a polynomial in Pn has n + 1 zeros, then it must be the zero polynomial.

MC Ou . 4 0 - 1 3 The process by which the... The process by which the board of diectors corverts the corporation's assets into cash and distributes them among the comporation's creditors and...

8:37 * N. 80% i ... OBJECTIVES: Create relationships Create a Pivot Table from Related Tables Create a PivotChart Modify the PivotChart The major section in this chapter :ontinuation is: Data...