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
Evolve a game to help children remember basic multiplication facts. In this section we have looked at ways of helping children absorb some simple multiplication facts. But what

Find out a series solution for the following differential equation about x 0 = 0 y′′ + y = 0.   Solution Note that in this case p(x)=1 and therefore every point is an or

i m making a project on share and dividend. will u pls give the all of 10pages information ?


how to explain this strategy? how to do this strategy in solving a problem? can you give some example on how to solve this kind of strategy.

advantages oh north west corner rule

the size of my sitting room is 7metres by 6metres . i bought a rug for covering the centre of its floor. one metre of the floor around the edge of the room is not to be covered by

how many times can u put 10000 into 999999

what is 24 diveded by 3

1. His favorite current carrot drink contain 40%. but h eneeds add to 80 quarts wife brought his perfect drink mix.