Answered! A star schema is a type of data warehouse design that optimizes multidimensional query performance (Poolet, 2007)….

A star schema is a type of data warehouse design that optimizes multidimensional query performance (Poolet, 2007).

Your reading gives a case example and a high-level overview of modeling an information system. The first step in designing an information system is to construct a data model. The data model you use is a star schema.

A large online company’s marketing department needs information to examine sales, predict future directions, and determine how and what to advertise. Design a star schema to organize the sales information to meet the marketing department needs. Identify the dimensions first, and then identify the attributes of those dimensions.

Please use your own word ,no plagrisum and need some reference too

Expert Answer

Hi,

Below is the answer-

Star Schema – Star schema is used to store warehouse information in the form of dimensions and facts. A fact table consists of business mesaures that can quantify the things. For Example- the sales amount for the products. The Dimension tables describes the various entities/dimensions in the start schema.

I have created the Star schema that contains the Fact and dimension tables and this diagram also list down the various attributes as well.

A large online company’s marketing department needs information to examine sales, predict future directions, and determine how and what to advertise-

To perform this we would have to follow a 2 step process-

1. Firstly, we need to create the Facts and dimension tables in the warehouse and then establish the link between the tables based on the primary keys of dimension tables.

2. A well-designed schema provides dimension tables allows a user to browse a database to become familiar with the information in it and then to write queries with constraints so that only the information that satisfies those constraints is returned from the database.

3. Below information can be collected to analyse-

A salesperson analyzes revenue by customer, product and time period.
A financial analyst tracks actuals and budgets by line item, product, and time period.
A marketing person reviews shipments by product, market, and time period.

Star Schema for Sales –

Regards,

Vinay Singh

Still stressed from student homework?

Get quality assistance from academic writers!

Order now