Design the data warehouse for a wholesale sports items company. The data warehouse has to allow...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Design the data warehouse for a wholesale sports items company. The data warehouse has to allow to analyse the company's situation at least with respect to the sport items, Customers and Time. Moreover, the company needs to analyse: The sports items with respect to its type (ball, bat, hockey, racket, gloves, shoes, table....), sport_category (cricket, football, basketball, hockey, table tennis.... .) and item_material (plastic, wood, glass, iron..) The sport_items usage with respect to their spatial location, by considering at least cities, regions and states The company is interested in learning at least the a. Quantity of each items b. Total profit the company earned Question No 1 Identify facts, dimensions and measures? ➤ For each fact: a. Produce the attribute tree and fact schema b. Design the snowflake schema and write the following SQL queries i. Find the quantity, the total profit and discount with respect to each city, type of sport_items and the month ii. Find the average quantity, profit and discount with respect to each country, items material and year iii. Determine the 3 most sold sports Design the data warehouse for a wholesale sports items company. The data warehouse has to allow to analyse the company's situation at least with respect to the sport items, Customers and Time. Moreover, the company needs to analyse: The sports items with respect to its type (ball, bat, hockey, racket, gloves, shoes, table....), sport_category (cricket, football, basketball, hockey, table tennis.... .) and item_material (plastic, wood, glass, iron..) The sport_items usage with respect to their spatial location, by considering at least cities, regions and states The company is interested in learning at least the a. Quantity of each items b. Total profit the company earned Question No 1 Identify facts, dimensions and measures? ➤ For each fact: a. Produce the attribute tree and fact schema b. Design the snowflake schema and write the following SQL queries i. Find the quantity, the total profit and discount with respect to each city, type of sport_items and the month ii. Find the average quantity, profit and discount with respect to each country, items material and year iii. Determine the 3 most sold sports
Expert Answer:
Answer rating: 100% (QA)
How about we separate the means for planning the information stockroom and making the SQL questions Stage 1 Distinguish Realities Aspects and Measures ... View the full answer
Related Book For
Smith and Roberson Business Law
ISBN: 978-0538473637
15th Edition
Authors: Richard A. Mann, Barry S. Roberts
Posted Date:
Students also viewed these finance questions
-
Read the case study and answer the question below with a one page response. What does a SWOT analysis reveal about the overall attractiveness of Under Armours situation? Founded in 1996 by former...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Ultimate Consulting is a management consulting firm that offers a wide range of services to companies in many industries. To stay on the cutting edge of developments in the business world and to...
-
Apple, Inc. Section 2, Analytical Procedures Based on TABLE 8-1, p. 220 Examples of Planning Analytical Procedures and the sections on Analytical Procedures in the text, select three ratios (e.g....
-
Sonya Huffman, the accountant, is a perfectionist. No one can do the job as well as she can. Indeed, she has found budget information provided by the various departments to be worthless. She must...
-
Use equation (17.2) to establish the following distributional relationships that are helpful for calculating quantiles. a. Assume that \(y_{0}=\alpha_{1} F / \alpha_{2}\), where \(F\) has an...
-
Emerson St. Paul Book Shops accounts at June 30, 2012, included the following unadjusted balances: The physical count of inventory on hand on June 30, 2012, was $5,000. Requirements 1. Journalize the...
-
The total factory overhead for Big Light Company is budgeted for the year at $739,820. Big Light manufactures two different products: night lights and desk lamps. Night lights are budgeted for 19,700...
-
Salmon Limited reported profit of $465,325 for its November 30, 2021, year end. Cash dividends of $90,000 on the common shares and $65,000 on the noncumulative preferred shares were declared and paid...
-
Assume you are long the gold future contract. In six months, the price of gold is $1300. Spot Price of Gold Future Price in 6 month contract $1200 $1275
-
Post a brief explanation of your critical question. Then, synthesize the 4-5 articles you identified that address your critical question. Using the same language you would use with stakeholders,...
-
Bob, a customer service manager at a call center, prides himself on being able to "read" people. He says he can tell whether someone will make a good employee as soon as he meets them and "sizes"...
-
Thoughts on Responding: Do you think evaluations are fair for both students and instructors? Do they or can they capture the performance properly? In what ways is your performance as a student...
-
How can telemedicine programs reduce health disparities and inequalities for patients in underserved areas of the community or of lower economic status? Despite the technological advances in health...
-
Berger points out that "While we may be overloaded, we are also gaining increased control." In his example, the VCR gave people in the 80s the ability to choose when they would consume a television...
-
Locate the centroid of the region bounded by the given curves. y = e", y = e, x = 2 y = e x = 2 y = e*
-
Subprime loans have higher loss rates than many other types of loans. Explain why lenders offer subprime loans. Describe the characteristics of the typical borrower in a subprime consumer loan.
-
Discuss the contract liability of a partnership and the partners.
-
The parties entered into an oral contract in June, under which plaintiff agreed to construct a building for defendant on a time and materials basis, at a maximum cost of $56,146, plus sales tax and...
-
[On October 1, 1995, Disney hired as its president Michael S. Ovitz, who was a long-time friend of Disney Chairman and CEO Michael Eisner. At the time, Ovitz was an important talent broker in...
-
What are the differences among an onsite team, a virtual team, a task force, and a committee? What are some of the potential differences in dynamics between people in these different groups?
-
What are the benefits of implementing programs to address cultural competence within a health care organization? What are the costs of not implementing such programs?
-
Over the past month, every member of the Intravenous (IV) Therapy Team has complained to you about the IV Team supervisor. Her direct reports, all RNs, agree that she is technically superb. However,...
Study smarter with the SolutionInn App