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

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

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