User Account

All Pages

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

  Explaining controls for database to execute transaction

Controls which need a database to either execute transaction completely or not at all.

  Create an e-r diagram

You have probably seen that already when you tried to create an E-R diagram. Visio uses notation and graphical shapes that are not the same as those in your text. If you look at some of the links to schemas, you will see a similar sort of thing.

  Evaluate maximum rate at which data can be read from disk

What is the maximum rate at which data can be read from disk, assuming that we can only read data from one surface at a time? What is the average rotational latency?

  Explaining software measurement related to software metrics

Is software measurement equivalent to software metrics? What makes them different?

  Determine columns that make up the primary key

Carry out the following tasks below by using the correct SQL statements. Create the statements in Oracle by using the following steps (SQL > SQL commands > Enter Command). Determine the columns that make up the primary key of the l_lunch_items tabl..

  Sales transaction in retail clothing

Examine different sales transactions. Design a context diagram and a level-0 diagram that represent the selling system at the store.

  Choose a data storage problem of storing data in database

You should choose a data storage problem of your interest and identify the different pieces of data that should be stored in database.

  Drawing active directory hierarchy in terms of forests

Draw Active Directory hierarchy in terms of forests, trees, domains, organizational units, and sites which are most suitable for this company and their security concerns.

  Recognize business processes evaluated-dw-bi application

Identify the business processes which would be evaluated and tracked with a DW/BI application and state your reasoning or justification for including these in the DW/BI.

  Practice on topic of normalization

Practice on topic of Normalization

  Method to change column name

Hhow can you change column name or what is a different way to write statement in SQL so it displays the amount column as money.

  Description of the relationship represented by scatterplot

Produce a scatterplot of Rent vs. Size (square meters of the apartment) for the rental data in rent.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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