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
integral 0 to 4 integral 0 to y root of 9+ysquredxdy

Differentiate following functions.                       h (t ) = 2t 5 + t 2 - 5 / t 2 We can simplify this rational expression as follows.                       h (t )

what is the advantage of dual linear problem programming when we maximize profit then what is need to minimize cost of the same problem

As noted, Euler's method is little used in practice, as there are much better ways of solving initial value problems. By better, we mean, "able to achieve a result of the same prec

Let G be a group acting on a set X. The action is called faithful if for any g ≠ 1 ∈ G there exists an x ∈ X such that gx ≠ x. That is, only the identity fi xes everything. Prov

give me the derivation of external division of sectional formula using vectors

1) find the maxima and minima of f(x,y,z) = 2x + y -3z subject to the constraint 2x^2+y^2+2z^2=1 2)compute the work done by the force field F(x,y,z) = x^2I + y j +y k in moving

Differentiate following. Solution : It requires the product rule & each derivative in the product rule will need a chain rule application as well. T ′ ( x ) =1/1+(2x) 2

The distance from the earth to the moon is approximately 240,000 miles. What is this distance expressed in scientific notation? To convert to scienti?c notation, place a decima