User Account

All Pages

Question 1a explain the use of facts dimensions and

Assignment Help Database Management System
Reference no: EM13365809

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

Reference no: EM13365809

Questions Cloud

Organizational structure designthe organizational structure : organizational structure designthe organizational structure design of a firm is important. in fact structure describes
Reward structurethe organizations reward structure may : reward structurethe organizations reward structure may inadvertently cause individuals to act in inappropriate manner
Multidivisional structurea explain what types of : multidivisional structurea. explain what types of organizations use a multidivisional structure? give an example.b. why
In order to accomplish many of the lean concepts in a : in order to accomplish many of the lean concepts in a business environment the logical first step is to understand
Question 1a explain the use of facts dimensions and : question 1a explain the use of facts dimensions and attributes in a star schema model.b in relation to a fact table
Question about healthcare organizations service : question about healthcare organizations service strategyprepare and describe the healthcare organizations service
Values culture amp formations of long-term goalswhen : values culture amp formations of long-term goalswhen looking at a company what is the importance of values and
Long term objectives and valuescorporate culturefor an : long term objectives and valuescorporate culturefor an organization what is the importance of values and corporate
Differences between black and white consumption patternsare : differences between black and white consumption patternsare there really differences between black and white

Reviews

Write a Review

Database Management System Questions & Answers

  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.

  Find average number of books borrowed per member

Find the average number of books borrowed per member. Take into account that if a member does not borrow any books, then that member does not appear in the borrowed relation at all.

  Question 1 the systems analyst proposes the subsequent two

question 1. the systems analyst proposes the subsequent two relationships between the flight and pilot entities what

  Define the importance of various system analysis

By now you should have a "toolbox" full of useful design and analysis tools. List the tools in your toolbox and then write one short paragraph on how you can/will apply them in your careers, lives, etc.

  Identifies all the stakeholders relevant to the system

Analyse the Case Study documents and produce a Vision document for a software system to meet the needs identified in the Case Study. Make sure your Vision document.

  Question 1explain ten desirable features which may be

question 1explain ten desirable features which may be included in the design of a warehouse. question 2how have to a

  Relational database concepts and applications

Relational Database Concepts and Applications

  Create a list of managers and supervisors

Your company wants to encourage carpooling. Create an answer table listing employee name, city and street address (in that order) for employees who live in Crestline.

  Create a new database and name it orders

Purpose of this hands-on computer exercise is to have you learn how to use Microsoft Access to: create a database table, enter data into the table, create a report based on the data, and print the table and the report.

  Determine the functional dependencies

Using your knowledge of the college environment, determine the functional dependencies that exist in the following?

  Build a gantt chart using microsoft project

Discuss what it will take to build a Web architecture, move an existing Website with minimal downtime, and provide a disaster recovery solution to ensure the site is always available.

  Security associated with new project

Your company has put in the request for a new database system and you have been tasked with architecting the security associated with this new project.

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