Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Design an e-commerce data warehouse for a nationwide chain of superstores of Bangladesh. There are many suppliers for the chain shop. The suppliers has sup-id,

image text in transcribed

Design an e-commerce data warehouse for a nationwide chain of superstores of Bangladesh. There are many suppliers for the chain shop. The suppliers has sup-id, name, type of products to supply (clothes, machineries, food etc. ), address (street, city, district). The chain shops serves the customers physically from the superstores and each superstore has its own system for all kinds of transactions (sale, procurement from the suppliers etc.). There are 10 million registered customers and each customer has customer id, name, NID, address (House no., street, thana, city, district, division and agegroup. A customer can purchase many items in a single transaction with transaction id, transaction type (cash or card), timestamp id, time of the day, day of the week, date, week, month, year, quantity, unit price and total price. Each item has an item id, name, type, country of manufacture. You have to design and implement a warehouse for this chain of superstores to support policy decision process and knowledge discovery. The following reports will be generated from the warehouse. Task 1: Design the architecture of the warehouse and explain the sources, preprocessing, noise reduction, transformation and uploading. Task 2: Design the star schema for the warehouse and explain how the data of the superstore database will be collected to the DW (source driven or destination driven). Task 3: Write three different cross tabulation for three different dimensions using total price/ quantity. Write SQL to find the cross-tabs. Task 4: Show the structure of a 4 dimension data cube and explain. Design an e-commerce data warehouse for a nationwide chain of superstores of Bangladesh. There are many suppliers for the chain shop. The suppliers has sup-id, name, type of products to supply (clothes, machineries, food etc. ), address (street, city, district). The chain shops serves the customers physically from the superstores and each superstore has its own system for all kinds of transactions (sale, procurement from the suppliers etc.). There are 10 million registered customers and each customer has customer id, name, NID, address (House no., street, thana, city, district, division and agegroup. A customer can purchase many items in a single transaction with transaction id, transaction type (cash or card), timestamp id, time of the day, day of the week, date, week, month, year, quantity, unit price and total price. Each item has an item id, name, type, country of manufacture. You have to design and implement a warehouse for this chain of superstores to support policy decision process and knowledge discovery. The following reports will be generated from the warehouse. Task 1: Design the architecture of the warehouse and explain the sources, preprocessing, noise reduction, transformation and uploading. Task 2: Design the star schema for the warehouse and explain how the data of the superstore database will be collected to the DW (source driven or destination driven). Task 3: Write three different cross tabulation for three different dimensions using total price/ quantity. Write SQL to find the cross-tabs. Task 4: Show the structure of a 4 dimension data cube and explain

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Database Administration The Essential Reference

Authors: Brian Laskey, David Kreines

1st Edition

1565925165, 978-1565925168

More Books

Students also viewed these Databases questions

Question

Define Administration?

Answered: 1 week ago

Question

Define Decision making

Answered: 1 week ago

Question

What are the major social responsibilities of business managers ?

Answered: 1 week ago

Question

Were all members comfortable brainstorming in front of each other?

Answered: 1 week ago

Question

4. What will the team agreement contain?

Answered: 1 week ago