Regal Foreign Car Repair Shop Case (A) Regal Foreign Car Repair Shop is currently keeping track…

Regal Foreign Car Repair Shop Case (A)

Regal Foreign Car Repair Shop is currently keeping track of its repair orders using the work order history form shown in Figure CS3.2. Typically, a customer brings his or her car to the garage with a specific complaint. The customer service manager places the customer information in section A of the work order and the specifics of the vehicle in section B of the work order. The customer complaints are written in the comments area of section B. A unique repair order number is assigned, as shown in section B.
Based on the information provided by the customer, the service manager assigns a mechanic to investigate the complaint. The mechanic ID is placed in column C4. Every attempt is made to assign one mechanic to an automobile, but it is possible that, because of different skill sets, different complaints will require different mechanics. Thus, there may be different mechanics involved with different items on the work order. However, only one mechanic is assigned to each item. After investigating the complaint, the mechanic assigns a trouble code in column C2. The “trouble code” is a code that covers all types of repair work done on foreign cars. A sample list of trouble codes and their meanings are shown in the exhibit on the next page.
Each trouble code has a standard number of hours to complete the work (called flat hours, column C3). The service manager quotes the cost of the repairs to the customer based on flat hours multiplied by the labor rate of the mechanic skill required, plus an estimate of the cost of parts involved. The mechanic labor rate is placed in column C5. Finally, when the job is done, the mechanic lists actual hours worked on the task in column C6. Regal wants to record actual hours worked in order to rate the efficiency of mechanics and possibly revise the flat hours required for different jobs. If parts are involved in the service, the part numbers and descriptions are placed in section C7.
When all the work is done, the service manager summarizes the cost of the service. This is done at the bottom of section C. The invoice for the total cost is presented to the customer for immediate payment by cash or credit card. The customer is then given a copy of the paid bill, which includes a copy of the work order describing the work done.

Regal Foreign Car Repair Shop Case (A) Regal Foreign Car Repair Shop is currently keeping track of...

(a) Create an E-R data model based on the following description:

1. A customer may own one or more automobiles that are repaired at Regal.

2. An automobile is serviced using a repair order. Over its life cycle, an automobile may have several repair orders.

3. Each repair order contains one or more repair details, each detail based on a specific customer complaint.

4. A trouble code is associated with zero, one, or more repair details.

5. A mechanic is assigned to each repair detail. A mechanic will work on many repair details.

6. A part detail lists all the parts associated with a repair detail. The part detail includes the part IDs and quantities used in the repair. Some repair details have no part detail because no parts are involved in the repair.

7. A part is associated with zero, one, or many part details.

8. A repair order has a repair cost summary, which includes the labor costs, part costs, and total cost.

(b) Using the information in Figure CS3.2 and elsewhere in the description of this case, assign attributes to entities, indicating the primary and foreign keys.

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
error: Content is protected !!