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

What percent of the figure below is shaded, What percent of the figure belo...

What percent of the figure below is shaded? Break the rectangle into eighths as shown below. The shaded part is 6/8 or 3/4; 3/4 is 75%.

Algorithm for division, ALGORITHM FOR DIVISION : If you ask a 10 or 1 1-ye...

ALGORITHM FOR DIVISION : If you ask a 10 or 1 1-year-old child to solve, say, 81 + 9, the chances are that she will correctly do it. But if you ask her to solve, say 72 + 3, t

The mean value theorem for integrals, The Mean Value Theorem for Integrals ...

The Mean Value Theorem for Integrals If f(x) is a continuous function on [a,b] then here is a number c in [a,b] thus, a ∫ b f(x) dx = f(c)(b -a) Proof Let's begin

Mathematics is all around us-mathematics- in our lives, Mathematics Is All ...

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

Practical geometry, Ask question draw a line parallel to given line xy at a...

Ask question draw a line parallel to given line xy at a distance of 5cm from it #Minimum 100 words accepted#

Shares and divident, A man invest ?13500 partly in shares paying 6% at ?140...

A man invest ?13500 partly in shares paying 6% at ?140 and partly in 5% at 125.If he is tolal income is 560, how much has he invested in each?

Sketch the plot first-order integrated rate, Show that the first-order inte...

Show that the first-order integrated rate expression can be written as [A] t = [A] 0 e -n(in)t where n represents the number of elapsed halftimes. Sketch the plot of [A] 1

Reason why we start division, Reasons why we start division : The reason w...

Reasons why we start division : The reason we start division by considering the digit in the leftmost place is efficiency and ease . For instance, suppose we divide 417 by 3, we

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