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
Eliminate Columns Not Dependent On Key The Employee Relation satisfies - First normal form - As it has no repeating groups. Second normal form - As it do not have multi-a

What is the difference between a key and a superkey? Key - A key a single attribute or a combination of two or more attributes of an entity set which is used to identify one

What is SQL, and why is it important? SQL stands for Structured Query Language, and is the most significant data processing language in use today. It is not a complete programm

Guidelines for creation of table: Table name should begin with an alphabet. In table name, single quotes and blank spaces are not allowed. Reserve words of that DBM

When are two schedules said to be view equivalent?     Ans: Two schedules that is denoted as S and S' are said to be view equivalent if the subsequent three conditions are met

Explain natural join? Natural Join - Similar as equi-join except in which the join attributes (having similar names) are not involved in the resulting relation. Only one sets

After the completion of the logical model the physical model is to be made. The oracle 10 G will be used as a database server and all the tables with their column are created and i

Unrepeatable reads : Assume T7 reads X twice during its implementation. If it did not update X itself it could be very disturbing to see a dissimilar value of X in its next read. B

What is a database graph? The partial ordering implies that the set D may now be viewed as a directed acyclic graph, known as a database graph.

Determine the OBJECTIVES of  object design After passing through this unit, you should be able to: describe and apply concept of generalisation; understand and appl