Extended star schema, Database Management System

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:  Students 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

1839_Extended Star Schema.png

Posted Date: 3/5/2013 7:27:21 AM | Location : United States







Related Discussions:- Extended star schema, Assignment Help, Ask Question on Extended star schema, Get Answer, Expert's Help, Extended star schema Discussions

Write discussion on Extended star schema
Your posts are moderated
Related Questions
What is a view?  Make a view of EMP table named DEPT 20, to display the employees in department 20 and their annual salary.  Ans:  View is a virtual table that does not consist

What is the use of with clause in SQL? The with clause gives a way of defining a temporary view whose explanation is available only to the query in which the with clause occurs

(a) Design a query plan for the following distributed query: An application at site B wants to compute a join of STUDENT ? Id=StudId TRANSCRIPT where STUDENT (Id,Major) is at site

Assignment #1 Data Management The questions on this exam are based on the Baxter Aviation case scenario. 1. (5 points) The systems analyst proposes the following two relationshi

What is average response time? The average response time is that the average time for a transaction to be done after it has been submitted.

Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible? Yes. Because Transact-SQL supports recursion, you can write kept proced

Write short note on Data models? Data models: A data model is an abstract model which elaborates how data is represented and accessed. The term data model has two commonly ac

Section A:  Use the following tables to create a database called College.  Use SQL commands. Student stuid(primary) lastName firstName

Explain the concept of Modeling With Objects A model is a conceptual representation of a specification, design or system from a particular point of view. A modelling language

What are the two types of indices? The two types of indices are:- A)     Dense index B)      Sparse index