Question Details

Answered: - Dimension Modeling Problem Solving Please see PDF document


Dimension Modeling Problem Solving Please see PDF document below for the specific modeling problem. You are encouraged to discuss this problem with your classmates and then independently propose your own design schema and answer the questions in the homework. The discussion could be focus on the business process and measurement of the process.


Fort Bend Engine Shop

 

The Fort Bend Engine shop remanufactures automobile engines. It takes old engines, repairs

 

them and sells them as recondition engines when they are done. Mr. Boren, VP of

 

manufacturing wants a data warehouse to help manage processing. He showed you a report that

 

he requests every day.

 

ID

 


 

St.

 

Time

 


 

Name

 

ID

 

St. Time

 

Target Prod

 

Prod Rate

 

In Queue

 

Aw Start

 

In Process

 

In Test

 

Reject

 

In Paint

 

Compl.

 

Hrs Compl

 


 

Target

 

Prod

 


 

Prod

 

Rate

 


 

In

 

Queue

 


 

Aw

 

Start

 


 

In

 

Process

 


 

In

 

Test

 


 

Description

 

Type of motor

 

Expected number of hours needed to complete

 

an overhaul

 

Number of repairs overhauls targeted per month

 

Current number of overhauls accomplished per

 

month

 

Number of motors awaiting overhaul

 

Number of motors awaiting the start of

 

processing

 

Number of motors in the process of being

 

overhauled

 

Number of motors overhauled and in testing

 

Number of motors rejected after testing

 

Number of motors which passed testing and is

 

process of being painted and packaged for sale

 

Number of motors completed

 

Hours billable for completed overhauls

 


 

Reject

 


 

In

 

Paint

 


 

Compl.

 


 

Hrs

 

Compl

 


 

Representative Entry

 

Ford 325 V8

 

36.5

 

13

 

11

 

= (Aw Start) + (In Process) +

 

(In Test)

 


 

= (compl) * (St Time)

 


 

The report above is completed daily. Mr. Boren also creates similar reports on a weekly, monthly

 

and annual basis to track the work of his shop.

 

Create a data warehouse to support this reporting requirement. Add natural additional facts and

 

attributes based on your own judgment and experience.

 

Specify the grain.

 

Specify the dimensions

 

Specify the facts

 

Specify the attributes

 

Provide a dimensional model.

 


 

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001185441.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now