Extended star schema model, Database Management System

Assignment Help:

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.


Related Discussions:- Extended star schema model

Explain about data independence, Data Independence This brings us to ou...

Data Independence This brings us to our next topic: data independence. It is the property of the database which tries to make sure that if we make any change in any level of sc

Hardware failure-database recovery and security, Hardware failure :  Hardwa...

Hardware failure :  Hardware failures are the failures when some disk or hardware chip fails. This may result in loss of data. One such trouble can be that a disk gets damaged and

How many types of users works on database, How many types of users works on...

How many types of users works on database? Users are differentiated through the way they expect to interact along with the system (i) Application programmers-interact with

What is the full form of ddl, What is the full form of DDL? DDL is stan...

What is the full form of DDL? DDL is stand for Data Definition Language.

What is rdbms terminology for a row, What is RDBMS terminology for a row? ...

What is RDBMS terminology for a row? A tuple is a RDBMS terminology for a row

What is conceptual schema, What is conceptual schema? The schemas at th...

What is conceptual schema? The schemas at the view level are known as subschema that describe dissimilar views of the database.

Express the ways provided by mysql for pattern matching, Express the ways p...

Express the ways provided by MySQL for Pattern Matching? MySQL provides two kinds of pattern matching. 1) One is based on SQL patterns 2) Regular expressions.

What is the function of sql server agent windows service, What is the funct...

What is the function of SQL Server Agent Windows service? - It's a Windows service that handles tasks scheduled within SQL Server environment. These tasks are also known as job

Create an er diagram completely with attributes, A database is to be constr...

A database is to be constructed to remain track of the teams and games of a sport league. A team has a number of players, not all of whom participate in every game. It is desired

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd