Question

In: Computer Science

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

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.

Solutions

Expert Solution

An Entity Relationship Diagram (ERD) is a snapshot of data structures. An Entity Relationship Diagram shows entities (tables) in a database and relationships between tables within that database. For a good database design it is essential to have an Entity Relationship Diagram.

Basic ER diagram is named as Crow Foot Notation

Crow's foot diagrams represent entities as boxes, and relationships as lines between the boxes. Different shapes at the ends of these lines represent the relative cardinality of the relationship. Crow's foot notation was used in the consultancy practice CACI. ... With this notation, relationships cannot have attributes.

In the above mentioned details we have the classes
Mobile details

Services Provided

Customer

Service Details

One customer can get any number of services and any number of devices.

As soon as we request for a service then the shopkeeper informs us the charge taken to provide that particular service.

We have services such as Glass replacement, Battery Replacement, Cleaning


Related Solutions

Create an ERD (using Crow’s Foot Notation) for the following description. Be sure to include all...
Create an ERD (using Crow’s Foot Notation) for the following description. Be sure to include all necessary entities, attributes, and correct cardinality in relationships between entities. You have been asked to build a database for a sportswear company called AthFleet. The company owner needs to keep track of the customers that buy their products, the employees that work at AthFleet, the vendors that provide them with products, and the products themselves. Each vendor has contact with one employee representative and...
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate....
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Two-Bit Drilling Company keeps information on employees and their insurance dependents. Each employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, the Social Security number and dependent names should be kept. All dependents must...
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy (EER) if...
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy (EER) if appropriate. Two-Bit Drilling Company keeps information on employees and their insurance dependents. Each employee has an employee number, name, date of hire, and title. If an employee is a full-time inspector, then the date of certification, the renewal date for that certification, and the yearly salary should also be recorded in the system. If an employee is a part-time inspector, then the date of...
ERD Lucid chart with Crow's foot notation for the following. include all entities, attributes, and correct...
ERD Lucid chart with Crow's foot notation for the following. include all entities, attributes, and correct carnality in relationships between entities. primary and foreign keys. You have been asked to build a database for a sportswear company called Ath Fleet. The company owner needs to keep track of the customers that buy their products, the employees that work at Ath Fleet, the vendors that provide them with products, and the products themselves. Each vendor has contact with one employee representative...
Use following case and create Entity-Relationship Diagrams using the Crow’s Feet method for each. Each ERD...
Use following case and create Entity-Relationship Diagrams using the Crow’s Feet method for each. Each ERD should be completed on a separate sheet of paper, if drawn by hand. If additional assumptions are made for any of your 2cases, be sure to document the additional business rules and include them with your ERDs. Entity-Relationship Diagram : TEXTBOOK REVIEWS Your website would like to add the ability for school BIT students to provide reviews for textbooks they have previously used. Using...
Create an ERD based on the following business rules and requirements. Make sure that the ERD...
Create an ERD based on the following business rules and requirements. Make sure that the ERD follows good database design practices covered in Chapter 6. use an online visual paradigm tool to create the ERD NOST offers many different tours. For each tour, the tour name, approximate length (in hours), and fee charged is needed. Tours are classified into five categories: family friendly, adventure, hiking, camping, and water activities. Guides are identified by an employee ID, but the system should...
Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The...
Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). A company has many divisions. Each division operates many departments, but each department is operated by one division. b). A department employs many employees but not more than 100. c). Each employee is employed...
Draw the ERD in Chen notation corresponding to the following spec: Sailors are identified by an...
Draw the ERD in Chen notation corresponding to the following spec: Sailors are identified by an sid, having a name, age, and rating Boats are identified by a bid and also have a name and a color. Sailors reserve boats on a given date. Every sailor reserves a boat at some time
Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where...
Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where appropriate (use Visio). The ERD must contain all primary keys, foreign keys, and main attributes. Business rules are defined as follows: At a hospital, each patient is classified as either a resident patient or an outpatient. All patients have common attributes - ID, first and last name, and diagnosis - and unique attributes that are specific to their groups. The list of such attributes...
Phase 1 – ERD In this phase of the project you will create an ERD based...
Phase 1 – ERD In this phase of the project you will create an ERD based upon the following requirements and business rules. Limit your ERD to entities and relationships based on the business rules showed here. In other words, do not add realismto your design by expanding or refining the business rules.  However, make sure you include all attributes needed that would permit the model to be successfully implemented, including all primary and foreign keys. 1.Trinity College (TC) is divided...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT