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
How to Insert data in your table from another table? insert into e.g, To insert tuples from employee into N_emp created above, use following statement Insert into N_emp

What are the failures of Controlling Events Between Objects  Failure Unintentional termination of system. Several possible causes: failure of system hardware, o

Explain Strict Two-Phase locking A transaction T does not release any type of its exclusive (X) locks until that transaction commits or aborts. In this method no other transact

A student entity type has the following attributes,name..

A distributed database is defined as "a collection of multiple logically interrelated database which are physically distributed over a computer network" (a) Give any three advan

Define Boyce codd normal form A relation schema R is in BCNF with respect to a set F of functional dependencies if, for all functional dependencies in F + of the form.α ->β.

Competition entrants can be either Individuals, or Teams. A Team is usually sponsored by a business, and, in that case, the team members would all wear T-shirts with the sponsoring

Extend your CREATE TABLE statement from problem 3 with referential integrity constraints. Updates and deletes on related rows are restricted. 6. From examination of the sample data

Having Clause with sub queries: First we have to recollect the GROUP BYclause. The following query searches the minimum salary in every department. SELECT DEPTNO, MIN (SAL)

Write a short note on oracle Instance? Oracle Instances: An instance is the (executed) Oracle software and the memory they use. It is the instance which manipulates the data s