What are the average total repair costs per month, Mathematics

An automobile manufacturer needs to build a data warehouse to store and analyze data about repairs of vehicles. Among other information, the date of repair, properties of the vehicle (e.g. model), information about the specific repair case (e.g. costs, number of garage employees involved, duration of the repair), data about the garage doing the repair, and data about the customer who owns the vehicle are stored.

Typical examples of business intelligence questions are:

  • What are the average total repair costs per month for garages in Boston by type of garage during the year 2011?
  • Identify five vehicle types that had the lowest average part costs.
  • Which factors (e.g., vehicle's age, mileage, model; customer's gender, age) contribute most to the repair costs?


The operational database keeps track of the repair costs (broken down by part costs, wages and total)for a specific vehicle (owned by a customer) for a specific garage on a dailybasis.

1. Draw a star schema for this data warehouse and specify all relevant attributes.

2. Identify any candidates for conformed dimensions that may be shared with other schemas (e.g., sales).

3. Identify any slowly changing dimensions and the attributes whose values may change from time to time.

4. Draw a lattice hierarchy for each dimension that has more than one level.

Posted Date: 3/21/2013 4:00:27 AM | Location : United States

Related Discussions:- What are the average total repair costs per month, Assignment Help, Ask Question on What are the average total repair costs per month, Get Answer, Expert's Help, What are the average total repair costs per month Discussions

Write discussion on What are the average total repair costs per month
Your posts are moderated
Related Questions
An educator placed 10 pebbles in a row and asked four-year-old Jaswant to count how many there were. She asked him to touch the pebbles .while counting them. Jaswant counted the pe

x+2y^2=63 and 4x+y^2=0; Find the area of the regions enclosed by the lines and curves.

theory about solving sequencing problem using graphical method

Max goes to the gym every fourth day. Ellen's exercise routine is to go every third day. Today is Monday and both Max and Ellen are at the gym. What will the day of the week be the

The perimeter of a rectangular swimming pool is 60m. The length of the pool is 4 m more than the width. What is the width of the pool?

Estimation of difference among two means We know that the standard error of a sample is given by the value of the standard deviation (σ) divided by the square root of the numbe

Prove that a m + n + a m - n  =2a m Ans:    a m + n = a 1 + (m + n - 1) d a m-n = a 1 + (m - n -1) d a m = a 1 + (m-1) d Add 1 & 2 a m+n + a m-n  =

Consider a person's decision problem in trying to decide how many children to have. Although she cares about children and would like to have as many as possible, she knows that chi