Create a Crow’s Foot notation ERD to support the following business operations: Create a Crowsfoot notation ERD to support the following business operations: - A friend of yours has opened Marshfield Electronics and Repairs (MER) to repair smartphones, laptops, tablets, and MP3 players. She wants you to create a database to help her run her business.  When a customer brings a device to MER for repair, data must be recorded about the customer, the device, and the repair (also referred to as repair request). Completing each repair request can involve multiple services (e.g. glass replacement, battery replacement, cleaning. Some services require parts. The customer’s name, address, and a contact phone number must be recorded. For the device to be repaired, the type of device, model, and serial number are recorded (or verified if the device is already in the system).  Each repair request is given a reference number, which is recorded in the system along with the date of the request, and a description of the problem(s) that the customer wants fixed. For each Service, there is a service ID number, description, and charge (amount charged for the service) Part number, Part description and Price are stored for each part. Each repair request is associated with only one customer.  A customer may submit multiple repair requests. Each repair request is for the repair of one and only one device.   It is possible for a device to be brought to the shop for repair many different times, Completing a repair request may require the performance of many services.  Each service can be performed many different times over multiple repairs, but each service is only performed once during the repair of a device. Each service may or may not require parts.  A service may require many parts. A part is used in one or many services. It is also possible that a part is not used in any service. Hint: Make sure you convert all M-N relationship to two 1-M relationships to receive a full mark.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Create a Crow’s Foot notation ERD to support the following business operations:

Create a Crowsfoot notation ERD to support the following business operations: -

A friend of yours has opened Marshfield Electronics and Repairs (MER) to repair smartphones, laptops, tablets, and MP3 players. She wants you to create a database to help her run her business. 

When a customer brings a device to MER for repair, data must be recorded about the customer, the device, and the repair (also referred to as repair request). Completing each repair request can involve multiple services (e.g. glass replacement, battery replacement, cleaning. Some services require parts.

The customer’s name, address, and a contact phone number must be recorded.

For the device to be repaired, the type of device, model, and serial number are recorded (or verified if the device is already in the system). 

Each repair request is given a reference number, which is recorded in the system along with the date of the request, and a description of the problem(s) that the customer wants fixed.

For each Service, there is a service ID number, description, and charge (amount charged for the service)

Part number, Part description and Price are stored for each part.

Each repair request is associated with only one customer.  A customer may submit multiple repair requests.

Each repair request is for the repair of one and only one device.   It is possible for a device to be brought to the shop for repair many different times,

Completing a repair request may require the performance of many services.  Each service can be performed many different times over multiple repairs, but each service is only performed once during the repair of a device.

Each service may or may not require parts.  A service may require many parts. A part is used in one or many services. It is also possible that a part is not used in any service.

Hint: Make sure you convert all M-N relationship to two 1-M relationships to receive a full mark. 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.