Extended star schema model, Database Management System

A customer places orders for parts and belongs to a particular industry group. An individual order is taken by a particular sales representative on a specific date and the sales representative is employed by a specific department and works in a given region. Parts are assigned to a unique category.

Tables

tblCustomer( CustomerNO, Name, Street, Suburb, Postcode, IndustryNOfk, Balance)

tblOrder( OrderNO, OrdDate, CustomerNOfk, SalesPersonNOfk )

tblOrderLine( OrderNO, PartNO, QtyPurchased, UnitSalePrice,)

tblPart( PartNO, PartDescription, QtyOnHand, UnitPrice, CategoryNOfk)

tblIndustry( IndustryNO, IndustryName)

tblCategory ( CategoryNO, CategoryName)

tblSalesPerson( SalesPersonNO, SalesPersonName, DepartmentNOfk, RegionNOfk)

tblDepartment( DepartmentNO, DepartmentName,)

tblRegion( RegionNO, RegionName)


Instructions

The company wants to improve its decision making processes by creating an OLAP system that satisfies the following requirements. The company wants to analyse its sales (revenue) information. It would to analyse its sales by the following criteria; Industry, PartNo and PartDescription, Category, SalesPerson, Region, Department and Customer. It needs to analyse this information on a yearly, monthly and daily basis

(a) Students are required to design a standard star scheme to meet the above requirements

(b) Students are required to transform their design in part (a) to match SAP's extended star schema model.

(c) A sales person over time can move to different regions and the company would like to record this fact. Indicate two ways this situation can be modelled in you design. You may need to redesign your model.

Posted Date: 3/5/2013 7:25:20 AM | Location : United States







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

Write discussion on Extended star schema model
Your posts are moderated
Related Questions
What is the meaning of Data independence? Data independence means a programs that are not dependent on the physical attributes of data and a programs that are not dependent on

Strict 2PL :Though, this basic 2PL suffers from the trouble that it can result into loss of isolation / atomic property of transaction as theoretically speaking once a lock is rele

a method named WonGame that checks each letter in the word is matched by its label

Briefly describe the different kinds of users of a DBMS.  Ans: Different sorts of DBMS users are: (a)  Software Engineers: These are the people accountable for developing ap

What is the error handling Traditionally, bits have been sent over line lacking any error correcting scheme in physical layer. The presence of the CPU in each modem makes it po

Need a sample of a clinic database relationships

what is file organization? what are file organization techniques.explain in detail? explain random file organization technique, multikey file organization technique?what is indexin

Explain Data Sublangauges ? Data sublanguage: In relational database theory, the term sublanguage, first used for this purpose through E. F. Codd in the year of 1970, refers t

Differentiate between the object oriented decomposition and the structured decomposition? Process-oriented (structural) decomposition divides a complex process, function or tas

Describe association design of an object by giving one suitable example of it. The Design of Associations Associations are "glue" of advanced object oriented analysis and