Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q5. With reference to the star schema below: a. Describe the granularity of the fact table. (1 marks) b. What is the benefit associated with

image text in transcribed
image text in transcribed
Q5. With reference to the star schema below: a. Describe the granularity of the fact table. (1 marks) b. What is the benefit associated with the granularity of the fact table below. (2 marks) c. What is the drawback associated with the granularity of the fact table below. (2 marks) CALENDAR PRODUCT Calendarkey ProductKey FullDate ProductID DayOfWeek ProductName DayOfMonth SALESPerDPCS Fact table ProductPrice Month CalendarKey (FK) ProductVendorName Quarter StoreKey (FK) ProductCategoryName Year ProductKey (FK) CustomerKey (FK) CUSTOMER STORE DollarsSold UnitsSold CustomerKey StoreKey CustomerID StoreID CustomerName StoreZip CustomerZip StoreRegionName CustomerGender StoreSize CustomerMarital Status StoreCSystem CustomerEducationLevel StoreLayout CustomerCreditScore

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Hospitality Management

Authors: John R Walker

3rd Edition

0135061385, 9780135061381

More Books

Students also viewed these General Management questions

Question

1. Offer surprise rewards for good participation in class.

Answered: 1 week ago

Question

1. A Ana no le gusta la nieve. 2. El clima de Panam es muy c

Answered: 1 week ago

Question

Do not come to the conclusion too quickly

Answered: 1 week ago

Question

Engage everyone in the dialogue

Answered: 1 week ago