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
Discuss the problem of Spurious tuples and how we may prevent it.    Ans:  A spurious tuple is, mainly, a record in a database that gets created while two tables are joined bad

Heap files (unordered file) Mostly these files are unordered files. It is the easiest and most basic type. These files having of randomly ordered records. The records will have

#ques Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a p

Question 1 Indexes are ocasionally defines on a single field of a file called an indexing field. List and describe the different types of indexes Question 2 Consider a book i

Discuss the differences among the candidate keys and the primary key of a relation. Give instance to describe your answer? A candidate key is one that can be used as primary ke

Differance between internal and external schema? Internal and external schema: Internal Schema • Describes the physical storage structure • Uses a physical data model External

Vertical Fragmentation- Vertical fragmentation groups together only those attributes in a relation that are used jointly by various important transactions. A vertical fragment is d

Define the terms i) Key attribute ii) Value set Key attribute: An entity type usually has an attribute whose values are exact from each individual entity in the collection. Su

A video rental company has several branches. The data held on each branch is the branch address made up of street, city, state, and zip code, and the telephone number. Ea

Horizontal Fragmentation- Horizontal fragmentation groups together the tuples in a relation that are collectively used by the main transactions. A horizontal fragment is produced b