Create a data warehouse to track book sales activity

Assignment Help Operation Management

Reference no: EM131645987

Consider the following scenario.

A bookseller would like to create a data warehouse to track book sales activity.

The bookseller has books. Books are identified by a publisher, a genre, an author or authors, and the date the book was published.

Purchases take place on a date at a specific time at a specific store in a specific region. A purchase has a specific amount and a quantity of books associated with it. Purchases are associated with a customer.

A customer has an age (a demographic), a profession, a gender and lives in a particular region.

The bookseller would like to know what type of customer (their demographic, their gender) is buying what books. More specifically, the bookseller would like to be able to run a report which provides information on sales by profession, by gender, by geographic region, by publisher, by author(s).

Identify fact table(s) and associated dimension tables. Note that you are not required to submit an ERD for this question. You can submit a text document which identifies entities and attributes, and identifies primary keys and foreign keys, and identifies fact tables and dimension tables. The primary keys exported as foreign keys should be named consistently, that is, the foreign key should have the same name as the primary key.

Reference no: EM131645987

Questions Cloud

Discusses a topic involving some aspect of business : Each student will be required to complete a review over an article in which the author discusses a topic involving some aspect of business.

Calculate the optimal total annual inventory cost : Calculate the economic order quantity (EOQ). Calculate the optimal total annual inventory cost.

Which constraints are binding : What is the optimal solution? Which constraints are binding?

Can you think of current examples where legislation : Can you think of current examples where legislation that is popular with the majority of Americans is held up in the Senate,

Create a data warehouse to track book sales activity : A bookseller would like to create a data warehouse to track book sales activity.

Considering the benefits of customer-oriented strategy : Considering the benefits of customer-oriented strategy to the organization, should there a limit to the practice of the phenomenon?

Explain how the front desk process provides means : In a healthcare setting, explain how the front desk process provides means for greater precision of patient data and improved management controls within clinic.

What are the key outputs of a risk assessment process : What are the key outputs of a risk assessment process? What should be done with these outputs?

Trade union movement by american business management : Why has there been (and is still) such strong opposition to the trade union movement by American business management?

User Account

All Pages