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
How to Converting Decimals to Percents ? To convert a decimal to a percent: Move the decimal point two decimal places to the right. Place a percent sign after the resulting

Question Write a short note on the following: 1 The weekly salaries of a group of employees are given in the following table. Find the mean and standard deviation of the

First, a solution to an equation or inequality is any number that, while plugged into the equation/inequality, will satisfy the equation/inequality. Thus, just what do we mean by

A man sold an item for Rs 6,750 at a loss 25%. What will be the selling price of same item if he sells it at a profit of 15%?

In the view below of the robot type of Cartesian Coordinates, is not the "Z" and "Y" coordinates reversed? http://www.expertsmind.com/topic/robot-types/cartesian-coordinates-91038

#question.areas of applications of linear program mes to solution to engineering problems.

Consider this. You have four units A, B, C and D. You are asked to select two out of these four units. How do you go about this particular task? Will your methodo

These can be expressed in terms of two fundamental operations of addition and multiplication. If a, b and c are any three real numbers, then;     1.

Utilizes the definition of the limit to prove the given limit. Solution Let M > 0 be any number and we'll have to choose a δ > 0 so that, 1/ x 2   > M

Michael scored 260 points during his junior year on the school basketball team. He scored 20% more points during his senior year. How many points did he score during his senior yea