Dimensions and attributes in a star schema model

Assignment Help Database Management System
Reference no: EM1353997

Question 1

(a) Explain the use of facts, dimensions and attributes in a star schema model.

(b) In relation to a fact table, what does the term granularity refer to? What are the implications of implementing either high or low granularity?

Question 2

(a) Why did SAP introduce the extended star schema? Explain why it is reported to be better than the traditional schema model?

(b) What is the difference between a dimension used in a traditional star schema and Saps' extended star schema?

Question 3

(a)  What are slow changing dimensions and describe the three methods that can be used to cater for slowly changing dimensions.

 Question 4

(a)  When designing an extended star schema what are the design considerations for the Fact Table and Dimensions in terms of size?  Why?

Question 5

Case Study

Northwind Pty Ltd sells a variety of food products throughout the world.  They want to use the reporting features of SAP's Business Information Warehouse to better understand their sales. 

In the Kick-off Meeting the Steering Committee provides the SAP Consultants with the necessary information about reporting requirements for the Northwind prototype to be installed:

The prototype should make it possible to analyze the sales as per the specified reports below.

Instructions: You are required to develop an Extended Star Schema that includes a fact and dimension tables in addition to the necessary Master Data in order to solve the problem outlined above.

Report 1 – Sales per customer

2412_table_1.png

Report 2 – Total value of Sales per category by country

1878_table_2.png

Report 3 – Sales for Boston Crab Meat by Country

922_table_3.png

The structure of the data available is as follows:

Order

Order Date

Customer

Product

Unit Price

Quantity

Category

Country

Category

Category

Category Name

Customer City

Customer

City

Customer

Customer ID

Customer Name

Supplier

Product

Supplier

Verified Expert

Reference no: EM1353997

Questions Cloud

What is meant by artificial intelligence : What is meant by artificial intelligence? What are two essential differences between human brains and the central processing unit of a computer.
Auditing-material weakness-change control risk : Prepare a memo that you will present to the CEO in which you do the following: Suggest the sources from which you can obtain information that would be needed to prepare the description of internal control in the audit working papers.
Introduction to persuasive communicator : Explain what needs to be done to become a more persuasive communicator. Describe how you can improve your listening skills with people around you in the workplace and life.
Value stream mapping to gain a solid baseline : QUESTION What alternative first steps could you use instead of value stream mapping to gain a solid baseline prior to innovating the process?
Dimensions and attributes in a star schema model : Explain the use of facts, dimensions and attributes in a star schema model. Explain the use of facts, dimensions and attributes in a star schema model.
Illustrate which currently operates out of an office : Illustrate which currently operates out of an office in a small town near Boston, just discovered a vacancy in an office building in downtown Boston
However you agree to meet with him and possibly negotiate : Explain some concerns about a single guy living in your house and taking care of it the way you would however you agree to meet with him and possibly negotiate a lease.
Elucidate which of the following us policies : Elucidate which of the following U.S. policies and institutions may negatively influence U.S. long-run economic growth.
Illustrate was the present value these future profits : A firm will have constant profits of $100,000 per year for the next four years and the interest rate is six percent. Assuming these profits are realized at the end of each year, what is the present value these future profits?

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd