[Solved]-Question 1 14 Marks International Technology Company Eg Apple Inc Uses Data Mart Analyze R Q37205904
Question 1. (14 marks) An international technology company (e.g. Apple Inc.) uses a data mart to analyze registered customers’ purchase in its retail stores in cities all over the world. The diagram below shows the fact schema of the Sales fact in the data mart. The fact records the sales event for a certain customer buying a certain product in a certain retail store on a certain day. The data mart keeps basic customer information (gender, marital status and home city), which are provided by customers when they registered an account in the company web site. The products are organized in a hierarchy with three levels (category type and individual product). The fact has three measures: sales amount, sales quantity and cost of goods sold. brand maritalStatus Sales customer gender category type productamount ity quantity cost store city state country year quarter month date dow Suppose that the data mart administrator wants to include sales events from unregistered customers in retail stores, and sales events from registered customers in the online store. a) Describe how the data mart can incorporate sales events from unregistered customers in the logical schema of your answer for Question 1 b) Describe how the data mart can incorporate sales events from registered customers in the online store in the logical schema of your answer for Question 1 Show transcribed image text Question 1. (14 marks) An international technology company (e.g. Apple Inc.) uses a data mart to analyze registered customers’ purchase in its retail stores in cities all over the world. The diagram below shows the fact schema of the Sales fact in the data mart. The fact records the sales event for a certain customer buying a certain product in a certain retail store on a certain day. The data mart keeps basic customer information (gender, marital status and home city), which are provided by customers when they registered an account in the company web site. The products are organized in a hierarchy with three levels (category type and individual product). The fact has three measures: sales amount, sales quantity and cost of goods sold. brand maritalStatus Sales customer gender category type productamount ity quantity cost store city state country year quarter month date dow Suppose that the data mart administrator wants to include sales events from unregistered customers in retail stores, and sales events from registered customers in the online store. a) Describe how the data mart can incorporate sales events from unregistered customers in the logical schema of your answer for Question 1 b) Describe how the data mart can incorporate sales events from registered customers in the online store in the logical schema of your answer for Question 1
Expert Answer
Answer to Question 1. (14 marks) An international technology company (e.g. Apple Inc.) uses a data mart to analyze registered cust… . . .
OR
