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
What do you mean by value delivery

a) Choose a topic in measurement, and design two activities in your context to help your pupils explore and learn the concept. b) Try these activities out on a few children, and

Unit Vector and Zero Vectors Unit Vector Any vector along with magnitude of 1, that is || u → || = 1, is called a unit vector. Zero Vectors The vector w → = (


Mathematics Is All Around Us :  What is the first thing you do when you get up? Make yourself a nice cup of tea or coffee? If so, then you're using mathematics! Do you agree? Cons

1. Build an equation for a hyperboloid of two sheets with the following properties: a. The central axis of the hyperboloid is the y-axis b. The two sheets are 4 units apart, an

What other activities can you suggest to help a child understand the terms 'quotient' and 'remainder'? Once children understand the concept and process of division, with enough

solve for x: logx9

Prove that if f and g are functions, then f intersect g is a function by showing f intersect g = glA A={x:g(x)=f(x)}

What were the two main political parties that formed in the majority of the new nations of Latin America post independence? In what ways were they different? Which party ascended t