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

  Define integrated marketing communications

Regarding "Make Your Dealers Your Partners," why do you think the Caterpillar system works? Identify characteristics that seem to be unique to Caterpillar and make their system successful. Explain how these unique characteristics contribute to the..

  Explain how the design of the distribution network affects

explain how the design of the distribution network affects the cost of the four supply chain drivers.

  What are the preffered out comes to each problem

What are the seperate problems, along with what are the issues? What are the preffered out comes to each problem? As the president of the bank, what should be done and why?

  Use apa style and submit your proposal to the instructor

Use non-course materials to support your contentions and incorporate pro-rata financial statements and supporting documentation. Use APA style and submit your proposal to the instructor by the last day of class.

  Discuss cost and schedule baselines

Discuss cost and schedule baselines. How are these baselines used to track and assess project performance? Explain how you will use the project baselines in your project audit.

  Importance of the project life cycle to project management

Explain the importance of the project life cycle to project management. Identify and define the phases within the project life cycle and explain their importance to the project being successful.

  American executive finds that a foreign subsidiary

A visiting American executive finds that a foreign subsidiary in a poor nation has hired a 12-year-old girl to work on a factory floor, in violation of the company's prohibition on child labor.

  In preparation for your overall logistics white paper

in preparation for your overall logistics white paper recommendation to the ceo she has asked you to give her a taste

  List and in brief identify the seven foundation

1. list and briefly identify the seven foundation competencies that are needed by individuals to be successful in most

  Determine the percentage of time the operator

Determine the average number of parts waiting to be worked on. Determine the percentage of time the operator is working.

  Illustrate what order quantity minimizes my total inventory

Storing this paper requires a specialized facility and holding costs are 32%. Assume a lead time of 1 week and that re are 250 working days in a year. Illustrate what order quantity minimizes my total inventory costs.

  Determine the workstation cycle time

Some tasks and the order in which they must be performed according to their assembly requirements are shown in the following table. These re to be combined into workstations to create an assembly line.

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