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

  Draw the er diagram for the database described above

Consider a video game store. For each game, the database contains information about title, producing company name, designer(s) name(s), version of the game, type of the game and characters in the game

  Design program that displays table of contigrade temperature

Design a program that displays a table of the contigrade temperatures 0 through 20 and their Fahenheit equivalents. The formula for converting a temperature from centigrade to Fahrenheit is.

  Hsada systems analysis and design

Determine and confirm client business expectations and needs and determine and apply appropriate development methodologies

  How the difference between an outer join and an inner join

Give a primary key for each relation. Are there any relations for which there is an alternate candidate key which you have not chosen as the primary key? Why or why not?

  Create an erd from a business problem

List all the business rules for the ABS ( Business rules are important because they define the conditions that the database must meet. For example, every Order must be associated with a valid Product.This prevents invalid Orders being entered into..

  Produce an entity-relationship diagram

Produce an Entity-Relationship diagram which represents the above activities of the insurance company. Indicate the names and degrees of all the relationships. Give appropriate attributes for each entity shown, and identify the primary key for eac..

  Performance of a distributed database

How can replication help the performance of a distributed database and in what situations can replication hurt the performance of a distributed database?

  What rules have to be enforced based on entity type

What rules would have to be enforced based on entity type? Choose one entity type and discuss what enforcement is needed by the database or application.

  Create a new test02 class

Write a toString method that will return a String containing all the relevant data for each of your objects.

  Describe data modeling tool such as erwin or rational rose

Consider the UNIVERSITY database described in Exercise Build the ER schema for this database using a data modeling tool such as ERwin or Rational Rose.

  Write names and e-mail addresses showing foreign key columns

Illustrate all the data in each of four tables. Don't show foreign key columns. Write down the names and e-mail addresses for all customers who have had stove repair which cost more than $50.

  Write command to list all employees in descending order

Write a command to list all the employees hired in 2003 and 2004. Sort the rows by the hire_date column in descending order.

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