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 is the minimum number of students, Question 1: What is the minimum...

Question 1: What is the minimum number of students each of whom comes from one of the 50 different states, enrolled in a university to guarantee that there are at least 100 who

How many gumdrops, Will has a bag of gumdrops. If he eats 2 of his gumdrops...

Will has a bag of gumdrops. If he eats 2 of his gumdrops, he will have among 2 and 6 of them left. Which of the subsequent represents how many gumdrops, x, were originally in his b

Multiplication of complex numbers, Multiplication of complex numbers Af...

Multiplication of complex numbers After that, let's take a look at multiplication.  Again, along with one small difference, it's possibly easiest to just think of the complex n

Math Help, 1. Which of the following is greater than 4.3 x 10^9 a. 2.1 x ...

1. Which of the following is greater than 4.3 x 10^9 a. 2.1 x 10^9 b. 3.2 x 10^9 c. 5.3 x 10^9 d. 7.4 x 10^8 2. Which of the following is less than 6.5 x 10^-5 a. 1.4 x 10

Subtraction - vector arithmetic, Subtraction - Vector arithmetic Compu...

Subtraction - Vector arithmetic Computationally, subtraction is very similar.  Given the vectors a → = (a 1 , a 2 , a 3 ) and b → = (b 1 , b 2 , b 3 ) the difference of the t

Line plots, how to you find the difference between different line plots

how to you find the difference between different line plots

#title.algebra., how do i understand algebra? whats the formula i just dont...

how do i understand algebra? whats the formula i just dont get it

Hcf and lcm, The HCF & LCM of two expressions are respectively (x+3) and (x...

The HCF & LCM of two expressions are respectively (x+3) and (x cube-7x+6). If one is x square+2x-3 , other is? Solution) (x+3) * (x^3-7x+6) = (x^2+2x-3) * y      ( ) (HCF*LCM=

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