What are the average total repair costs per month, Mathematics

Assignment Help:

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.


Related Discussions:- What are the average total repair costs per month

Circle, Circle Well, let's recall just what a circle is. A circle is al...

Circle Well, let's recall just what a circle is. A circle is all the points which are the similar distance, r - called the radius, from a point, ( h, k ) - called the center. I

Functions, The figure shows the sketch graphs of the functions

The figure shows the sketch graphs of the functions

Pair of st line, #qu Given the equation through what angle should the axes...

#qu Given the equation through what angle should the axes be rotated so that the term in xy be waiting from the transformed equation. estion..

Solve the differential equation, Solve the subsequent differential equation...

Solve the subsequent differential equation and find out the interval of validity for the solution. Let's start things off along with a fairly simple illustration so we can notic

Determine radicals in exponent form, Evaluate following.               ...

Evaluate following.                √16 and Solution To evaluate these first we will convert them to exponent form and then evaluate that since we already know how to

Velocity of derivation, Velocity : Recall that it can be thought of as sp...

Velocity : Recall that it can be thought of as special case of the rate of change interpretation. If the situation of an object is specified by f(t ) after t units of time the vel

Describe about arithmetic and geometric series, Describe about Arithmetic a...

Describe about Arithmetic and Geometric Series? When the terms of a sequence are added together instead of separated by commas, the sequence becomes a series. You will use seri

First order linear differential equation, Newton's Second Law of motion, wh...

Newton's Second Law of motion, which recall from the earlier section that can be written as: m(dv/dt) = F (t,v) Here F(t,v) is the sum of forces which act on the object and m

Show that the height h of the tower, The angle of elevation of the to...

The angle of elevation of the top of a tower from a point on the same level as the foot of the tower is α. On advancing 'p' meters towards the foot of the tower, the angle of eleva

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd