Author Question: A snowflake schema is usually heavily aggregated. Indicate whether the statement is true or ... (Read 41 times)

Mr3Hunna

  • Hero Member
  • *****
  • Posts: 536
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

  • Sr. Member
  • ****
  • Posts: 325
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.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

If you use artificial sweeteners, such as cyclamates, your eyes may be more sensitive to light. Other factors that will make your eyes more sensitive to light include use of antibiotics, oral contraceptives, hypertension medications, diuretics, and antidiabetic medications.

Did you know?

In 1835 it was discovered that a disease of silkworms known as muscardine could be transferred from one silkworm to another, and was caused by a fungus.

Did you know?

According to the American College of Allergy, Asthma & Immunology, more than 50 million Americans have some kind of food allergy. Food allergies affect between 4 and 6% of children, and 4% of adults, according to the CDC. The most common food allergies include shellfish, peanuts, walnuts, fish, eggs, milk, and soy.

Did you know?

The people with the highest levels of LDL are Mexican American males and non-Hispanic black females.

Did you know?

The horizontal fraction bar was introduced by the Arabs.

For a complete list of videos, visit our video library