Computer repair erd case

Assignment Help Operation Management
Reference no: EM13785148

Computer Repair ERD Case

ABC Computers has been serving all of Acadiana's Computer Repair, Service and Sales needs since 2001! Their Services include: Computer Repair, Laptop Screen Repair, Virus Removal, On Site Compute Services, and iPhone Repair & iPad Repair.

The owners of ABC Computers would like to keep track of the repair jobs for all the equipment they repair, the parts used for each repair job, and the customer’s information. Each repair job refers to only one equipment, but the customer could bring in more than one equipment. Each repair job could entail the use of many parts but doesn’t necessarily use one every time. A part could be used in many different equipment.

You have identified the following Business Rules so far:

1. A customer can have one or many equipment.

2. An equipment is owned by one or and only one customer.

3. An equipment is brought in for one or many repair jobs.

4. A repair job entails one and only one equipment.

5. A repair job uses zero or many parts

6. Each part is used in zero or many repair jobs

Phase 1: Define Entity Classes and Primary Keys

Phase 2: Define Relationships among entity classes

Phase 3: Define the cardinality among entity classes

Phase 4: Create an Intersection Relation

Phase 5: Create the final structure

Reference no: EM13785148

Questions Cloud

About certainty-uncertainty and risk when making decisions : Discuss your attitude about certainty, uncertainty, and risk when making decisions. How has your attitude helped or hindered your ability to make rational decisions?
Cost necessary to handle-ship different types of inventories : The successful management of supply chains supporting Internet commerce is based on two cornerstones. One is inventory management operations and the cost necessary to handle and ship different types of inventories. What is the other cornerstone?
Highlight key strategic hrm challenges and solutions : Highlight key strategic HRM challenges and solutions in the region; Describe strategic HRM opportunities in the region;
What kinds of people make good project champions : What kinds of people make good project champions? How can a firm ensure that it gets the benefits of championing while minimizing the risks?
Computer repair erd case : ABC Computers has been serving all of Acadiana's Computer Repair, Service and Sales needs since 2001! Their Services include: Computer Repair, Laptop Screen Repair, Virus Removal, On Site Compute Services, and iPhone Repair & iPad Repair.
Difficult personal decision about laying off valued employee : In this exercise you will examine how to weigh a set of facts and make a difficult personal decision about laying off valued employees during a time of financial hardship. You will also examine your own values and criteria used in the decision-making..
Provide real-life examples of small groups : Identify three types of small groups. Locate and provide real-life examples of small groups (such as support groups, community groups, education groups, and parent support groups) in your community.
Conduct monitoring and auditing : Conduct Monitoring and Auditing
Calculate the standard deviation : Expect the distribution of the data to be skewed to the left - Calculate the standard deviation

Reviews

Write a Review

Operation Management Questions & Answers

  Determine two potential opportunities specific

Discuss a situation where you were influenced by an infomercial, attractive packaging, and a discount flyer to purchase a product, and explain why you think the promotional method made such an impact on you.

  How much time will it take to perform

The time to perform the first instance of a task is 6 hours. How much time will it take to perform the 5th repetition if the learning rate is 80%?

  An organization recently developed a new intrinsic

An organization recently developed a new intrinsic recognition program (Plaques, Certificates, Nominal amounts of money that is savings bond and designated parking space for a 30-day period).

  Work breakdown structure-tasks-subtask and work package

What was the most complex project that you have been involved in? Give examples of the following as they pertain to the project: the work breakdown structure, tasks, subtask, and work package. Were you on the critical path? Did it have a good project..

  Calculate the total annual cost and economic order quantity

A local nursery, Greens, uses 2184 bags of plant food annually. Greens works 52 weeks per year. It costs $8 to place an order for plant food.

  How might company adjust for projects of differing risk

If a company, with a normal payback requirement of two years or less, uses subsequent techniques, explain how might company adjust for projects of differing risk in approval process.

  What happened at the rana plaza and other workplace accident

What were the causes of the weak safety record of the Bangladesh garment industry? Do Western companies that import garments from Bangladesh bear any responsibility for what happened at the Rana Plaza and other workplace accidents?

  Most of hr performance issues result from underlying

many hr performance issues result from underlying motivational problems external to the work environment health career

  Analyze the implementation process and identify problems

What do you think will happen as a result of the highway administrator's goal-setting program. Analyze the implementation process and identify problems of the program with the relevant concepts and theories.

  Discuss importance of succession planning

Why is succession planning important? How do large businesses do it and how to small business handle it?

  Describe the role of probability concepts in business

what are the differences between probability and coincidence? can the probability be more than 1 or less than 0?

  How will you add value to se core competencies

Being a marketing manager of a pharmaceutical company at domestic scale, list down core competencies of your firm & advice explain how will you add value to se core competencies in order to sustain for a longer period of time.

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