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 are the two approaches to store relations in distributed database? a) Replication b) Fragmentation

Using the questions found at the end of Chapter 9 in your textbook, complete this homework activity. Students will submit a Word document answering questions 2, 3, and 4.

What is a view? A view is a logical view on one or more tables.  A view on one or more tables i.e., the data from a view is not actually physically kept instead being derived f

Explain Interblock gap? Interblock Gap - A track of a disk is separated into equal-sized disk blocks. Blocks are separated through fixed-size gaps, called as interblock gaps th

List some security violations (or) name any forms of malicious access. A) Unauthorized reading of data B) Unauthorized modification of data C) Unauthorized destruction of

Company Database: a-)Here is the ER Model b-)Here is the Relational Model:     IMPORTANT NOTICE FOR SOLUTION TYPE: ***THIS ASSIGNMENT WILL BE SOLVED BY THE

Describe Object Relational model ? Object Relational Model - This model combines the characteristics of both relational model and object oriented model. It extends the tradit

Define What are the desirable properties of a decomposition Ans: What are the desirable properties of decomposition - dependency preserving.  Because Lossless join and dependen

Define access time. Access time is the time from when a read or write request is issued to when data transfer starts.

Security And Integrity After Reading the concepts of database recovery in the last section, let us now deal with a vital concept that helps in minimizing consistency errors in