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
#questiRegional Gardens has many nurseries, including Wagga Wagga, Bathurst, Albury, Orange, and Dubbo. Each nursery is known by its campus code, eg WW, B, A, O and D respectively.


define locking in simple language and decribed it

An example of a weak entity is Staff because the availabilityID cannot be uniquely identified unless it is used in conjunction with the foreign key known as availabilityID in the A

What is meant by Physical blocks? The input and output operations are completed in block units. The blocks residing on the disk are referred to as physical blocks.

The Database Approach In order to overcome the limits of a file system, a new approach was needed. Hence a database approach emerged. A database is a persistent collection of

What is Relational DBMS This is our subject of study. A DBMS is relational if the data is organized into relations, that is, tables. In RDBMS, all data are kept in the well-kno

please describe the data base management with the easy example &give the application?

Domain Constraint It shows that each attribute in a relation has to contain an atomic value only from the corresponding domains. The data types associated with commercial RDBMS

in case of functional dependencies how we get the higher normal form.