A snowflake schema is usually heavily aggregated. Indicate ...

[Mr3Hunna]

A snowflake schema is usually heavily aggregated.
 
  Indicate whether the statement is true or false

Question 2

The automotive tire supply company you work for, Tires4U, has noticed that one of its brands of tires is not selling nearly as well as anticipated at most of its locations.
 
  For each of the four main types of information systems found in a business, identify a query that might help understand this development. Of the four types of systems, which do you think will be the most helpful and why?

[stanleka1]

Answer to Question 1

FALSE

Answer to Question 2

You might query operational level TPS to make sure that the product is actually getting to the stores and being restocked. You could query MIS to see average sales levels according to geography, location, and other factors to see if there are any specific factors affecting the sales. You might query ESS to see if the same tires are being sold by competitors and what these prices are. You might use DSS to see what factors could increase sales. Assuming that the tires are being properly stocked at the stores, the most important system to query is the MIS for summaries of sales records to help pinpoint any other factors, sales and marketing to assure that promotion and pricing is accurate.