Scenario: A large online company’s marketing department needs information to exa

Question

Scenario: 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. Provide examples from the answer I received earlier? Not understanding what has to be done. Believe I need tables (attribute and keys or dimensional table?) Unsure!

Dimensional Star Schema

Solution: You are already provided a star schema to organize the sales in the question itself, the star schema needs the below goals First need to identify business elements and models for the analysis of the business. Identify the facts those can be measured. Next identify the dimensions for the facts and then attributes of those dimensions. The fact tables will contain the numerical data associated with the events associated. Dimensions and their attributes The dimensions recognizes a higher domain The dimensions in the given star scheme are product, customer, Employee, Sales Facts, Sales and then demo. The attributes of the dimensions identified are the internal components resides in the dimension box. For example the customer dimension includes customer id, address, city, state, zipCode, etc. as the attributes. The dimensions are defined in terms of attributes and the dimensions required to identify the larger domains associated with the business. Since you are already provided a good star schema no need to design other

Explanation / Answer

The information of various dimensions are given in form of tables. These tables are given below with all attributes.

1) customer_dim_table(customer_id, address, city, state, zipcode, country, customer_age, customer_credit info)

Here in the above customer dimension we have customer_id is working as primary key.

2) product_dim_table(product_id, product_description, product_quantity, category_description, category_id)

Here product_id is primary key and category_id is foreign key

3) employee_dim_table(employee_id, first_name, last_name, birth_year, street_address, city, state, zipcode)

Here employee_id is primary key

Apart for these above given we have some more dimensions that are described in the diagram.

The various identified business elements are given below:

1) Customer: Its one of the important element in any business, customer is someone who purchase the product.

2) Product: Its the item that is being sold to the customer.

3) Employees: There are the core part of the business, as they are the one's who run the business.

The facts that can be measured here are listed below:

1) We need to measure the buying capacity of the customer, its required to measure to predict the growth of business.
2) We also need to major the stock capacity of the product we are going to sell.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.