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 registered customers and each customer has customer id, name, NID, address (House no., street, thana, city, district, division and age-group. 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 the policy decision process and knowledge discovery. The following reports will be generated from the warehouse. Task 1: three different cross-tabulation for three different dimensions using total price/ quantity. Write SQL to find the cross-tabs.
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 registered customers and
each customer has customer id, name, NID, address (House no., street, thana,
city, district, division and age-group. 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 the policy decision process and knowledge discovery. The following reports
will be generated from the warehouse.
Task 1: three different cross-tabulation for three different dimensions using total price/ quantity. Write SQL to find the cross-tabs.
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 1 images