Note Hand writing Please Course IT Decision Support Systems Suppose that a data warehouse consists of the three dimensions, supplier sup name, type customer cust name, email, mobile , location street, city, country , and the two measures units sold , and sales amount (in SAR) Draw a Star schema diagram for the above data warehouse Include the appropriate attributes for dimension and factor tables (DT and FT) ( 0 5 marks ) Explain how Snowflake schema can provide better representation over Star schema In the given 3D warehouse above, determine which DT will be affected when implementing the Snowflake model ( 0 5 marks ) What specific OLAP operations (roll up, drill down, dice, slice) should be performed (based on the above schema (A)) in order to list the total sales of each supplier in Saudi Arabia ( 0 5 marks ) Note NEED A UNIQUE ANSWER AND NO HANDWRITING PLEASE

The Answer is in the image, click to view ...

Question: Note: Hand writing Please Course: IT Decision Support Systems Suppose that a data warehouse consists of the three dimensions, supplier[sup_name, type] customer[cust_name, email, mobile] ,

Note: Hand writing Please

Course: IT Decision Support Systems

Suppose that a data warehouse consists of the three dimensions, supplier[sup_name, type] customer[cust_name, email, mobile], location[street, city, country], and the two measures units_sold, and sales_amount (in SAR).

Draw a Star schema diagram for the above data warehouse. Include the appropriate attributes for dimension and factor tables (DT and FT). (0.5 marks)

Explain how Snowflake schema can provide better representation over Star schema. In the given 3D warehouse above, determine which DT will be affected when implementing the Snowflake model? (0.5 marks)

What specific OLAP operations (roll-up, drill down, dice, slice) should be performed (based on the above schema (A)) in order to list the total sales of each supplier in Saudi Arabia? (0.5 marks)

Note: NEED A UNIQUE ANSWER AND NO HANDWRITING PLEASE..

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!

Suppose that a data warehouse consists of the three dimensions, supplier[sup_name, type] customer[cust_name, email, mobile] , location[street, city, country] , and the two measures units_sold , and...

Suppose that a data warehouse consists of the three dimensions, supplier[sup_name, type] customer[cust_name, email, mobile], location[street, city, country], and the two measures units_sold, and...

Suppose that a data warehouse consists of the three dimensions, supplier[sup.name, type] customer[cust.name, email, mobile], location[street, city, country), and the two measures units. sold, and...

Q1 Decision makers in XYZ company need to analyze the organization's financial performance in order to determine whether departments' expenditures are over or under budget thus, deriving actionable...

's Suppose that a data warehouse consists of the three dimensions, supplier[sup_name type] customer [cust_name, email, mobile], location(street, city, country), and the two measures units sold and...

Who is chief knowledge officer? What the primary role? A senior executive in an organization responsible for ensuring that firm fully utilizes the value it gets through knowledge- which is the most...

I would like assistance with assignment 3 and 4 on the attached document I have been struggling with the subject and its my last AUI4863/102/0/2016 Tutorial letter 102/0/2016 ADVANCED INTERNAL AUDIT...

Hi Sara, Please find my attachments for your information. Thank you Masoumeh P 3-2 P 3-2 The following information was obtained from the accounts of Lukes, Inc., as of December 31, 2012. It is...

Misty Cumbie worked as a waitress at the Vita Caf in Portland, Oregon. The caf was owned and operated by Woody Woo, Inc. Woody Woo paid its servers an hourly wage that was higher than the states...

Prepare journal entries for the following month. (What debit/credit and what account?) August 1. Mindy invested $25,000 in cash and $3,500 worth of cleaning equipment. August 2nd. I rented office...

A financial crisis is likely to occur if there are sharp increases in financial fictions ( asymmetrical information problems ) and constant decilines in the proper functionaliy of financial markets (...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

1. The development of important skills in employees is always a concern for human resource professionals and managers. Skills gaps continue to challenge organizations, and proper steps need to be...

4. Job analysis enables human resource professionals and operating managers to identify the proper tasks, duties, and responsibilities of various organizational jobs. Given its importance, the...

LO1 Explain how the workforce is changing in unpredicted ways.