SQL database the yellow box is the Order data mentioned in the Q

CoursHeroTranscribedText

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?