SQL database the yellow box is the Order data mentioned in the Q CoursHeroTranscribedText Orders (cust, date,
Fantastic news! We've Found the answer you've been seeking!
Question:
SQL database the yellow box is the Order data mentioned in the Q
CoursHeroTranscribedText
Transcribed Image Text:
Orders (cust, date, proc, memory, hd, od, quant, price) Exercise 7.4: In Exercise 6.1 we spoke of PC-order data organized as a fact table with dimension tables for attributes cust, proc, memory, hd, and od. That is, each tuple of the fact table Orders has an ID for each of these attributes, leading to information about the PC involved in the order. Write a SQL query that will produce the data cube for this fact table. Exercise 7.5: Answer the following queries using the data cube from Exer- cise 7.4. If necessary, use dimension tables as well. You may invent suitable names and attributes for the dimension tables. a) Find, for each processor speed, the total number of computers ordered in each month of the year 2007. b) List for each type of hard disk (e.g., SCSI or IDE) and each processor type the number of computers ordered. c) Find the average price of computers with 3.0 gigahertz processors for each month from Jan., 2005. ! Exercise 7.6: The cube tuples mentioned in Example 32 are not in the rollup of Example 33. Are there other rollups that would contain these tuples? Orders (cust, date, proc, memory, hd, od, quant, price) Exercise 7.4: In Exercise 6.1 we spoke of PC-order data organized as a fact table with dimension tables for attributes cust, proc, memory, hd, and od. That is, each tuple of the fact table Orders has an ID for each of these attributes, leading to information about the PC involved in the order. Write a SQL query that will produce the data cube for this fact table. Exercise 7.5: Answer the following queries using the data cube from Exer- cise 7.4. If necessary, use dimension tables as well. You may invent suitable names and attributes for the dimension tables. a) Find, for each processor speed, the total number of computers ordered in each month of the year 2007. b) List for each type of hard disk (e.g., SCSI or IDE) and each processor type the number of computers ordered. c) Find the average price of computers with 3.0 gigahertz processors for each month from Jan., 2005. ! Exercise 7.6: The cube tuples mentioned in Example 32 are not in the rollup of Example 33. Are there other rollups that would contain these tuples?
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...
-
Design a Java class that represents a cache with a fixed size. It should support operations like add, retrieve, and remove, and it should evict the least recently used item when it reaches capacity.
-
Michael Mayfield, the president of Mendo Mill and Lumber Co., in California, received a notice of a legal claim from Edward Starski. The claim alleged that a stack of lumber had fallen on a customer...
-
For each function in below Problems find the relative maxima, relative minima, horizontal points of inflection, and sketch the graph check your graph with a graphing utility. 1. y = 1/3x3 - x2 + x 1...
-
The monthly payments on both graduated-payment loans and growing-equity loans increase over time. Despite this similarity, the two types of loans have different purposes. What is the motivation...
-
Recall the facts in Leonard v. Pepsico Had this been a contract, would it have been subject to the Statute of Frauds?
-
In January 2014, the management of Weast Company concludes that it has sufficient cash to purchase some short-term investments in debt and stock securities. During the year, the following...
-
15. A simple LR circuit is connected to a battery at t = 0. The time instant at which rate of energy storage in inductor is half of power delivered by battery (a) In 2 (c) In 2 (b) In () (d) In 3 16....
-
Crane Library, a nonprofit organization, presented the following statement of financial position and statement of activities for its fiscal year ended February 28, 2024. Assets Current Assets Cash...
-
An amusement park ride consists of a rotating circular platform 10.2 m in diameter from which 10 kg seats are suspended at the end of 1.55 m massless chains. When the system rotates, the chains make...
-
18) A physician prescribes one 0.7 mg tablet of a medication to be taken twice a day for 15 days. How many total mcg of the medication will the patient have taken after 15 days?
-
Robert purchased US$15,000 from a bank in America, which charged him a commission of 0.9%, and sold the US dollars to a bank in Canada, which charged him a 0.24% commission. How much money did he...
-
Before boarding her flight to Zurich, Switzerland, Mary purchased CHF850 from her bank when the exchange rate was C$1 = CHF0.9651. However, Mary had to cancel the trip. Mary returned to the bank to...
-
4. Ethan bought new car worth $60 000. After 5 years, the car was worth $35 429.40. Calculate the depreciation rate of the Ethan's car. [T4] [C2]
-
A commercial building has 120 office spaces. Each office space has one, two, or three filing cabinets. There is one filing cabinet in 45 percent of the office spaces, and two filing cabinets in 35...
-
A certain device for analyzing electromagnetic radiation is based on the Bragg scattering of the radiation from a crystal. For radiation of wavelength 0.149 nm, the first-order Bragg peak appears...
-
Describe basic managerial approaches to implementing controls and how these are implemented.
-
Skyler is covered by his company's health insurance plan. The health insurance costs his company $3,500 a year. During the year, Skyler is diagnosed with a serious illness and the health insurance...
-
Marty is a sales consultant. Marty incurs the following expenses related to entertainment of his clients in 2012: Dues to a country club......................................................$4,500...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Let \(\left(B_{t} ight)_{t \geqslant 0}\) be a \(\mathrm{BM}^{1}\), denote by \(\mathcal{H}_{T}^{2}\) the space used in Lemma 19.10 and pick \(\xi_{1}, \ldots, \xi_{n} \in \mathbb{R}\) and \(0=t_{0}...
-
Let \(X_{t}\) be as in Problem 19.5 and set \(\widehat{\tau}_{b}:=\inf \left\{t \geqslant 0: X_{t}=b ight\}\). a) Use Problem 19.5 to find the probability density of \(\widehat{\tau}_{b}\) if...
-
Show that, in Theorem 19.17, the quadratic variation \(\langle Mangle_{t}\) is a \(\mathscr{G}_{t}\) stopping time.Direct calculation, use Lemma 19.16.c) and A. 15 Data From Theorem 19.17 19.17...
Study smarter with the SolutionInn App