Question: INSTRUCTIONS Using the following narrative to design a database by drawing an Entity-Relationship Diagram. Include the maximum and minimum cardinalities for each relationship you

INSTRUCTIONS Using the following narrative to design a database by drawing anEntity-Relationship Diagram. Include the maximum and minimum cardinalities for each relationship you

INSTRUCTIONS Using the following narrative to design a database by drawing an Entity-Relationship Diagram. Include the maximum and minimum cardinalities for each relationship you identify. Download the ERD Homework template provided under the ERD #2 Assignments link on the course Blackboard site and create the solution to the ERD homework description handed out in class. You can copy and paste the diagram elements on the template to create the solution. When you are finished, name your file YourLastName.ERD2.docx, and submit it via the same Assignments link on Blackboard. Mobile Mike's Mobile Phone Repair ("MMMPR") receives mobile phones ("phones") from customers, performs repair evaluations and then repairs the phones if the customers want them repaired. MMMPR wants to create a database to keep track of their business operations. Their business process is fairly simple: First, an Intake Technician receives in the mobile phone(s). A phone receipt is defined as a customer bringing in one or more faulty mobile phones for evaluation. An Intake Technician receives the phone(s) and generates a receipt to document the phones(s) received. At this time, the customer must pay the minimum charge of $30 per phone to have each phone evaluated. The receipt of phone(s) and the receipt of cash happen at the same time so for database purposes these will be tracked using a single table (entity). MMMPR needs to keep track of its "customer phone inventory", which are the phones that have been received for evaluation. Each phone received is given a unique inventory number. Each received phone will eventually be evaluated by a Repair Technician. MMMPR tries to do evaluations in the order in which the phones were received. A Repair Technician pulls receipts by date, retrieves the associated phones from inventory, and evaluates each phone. Obviously, one Repair Technician can perform many evaluations, but newly hired repair technicians may not have performed any evaluations (until they receive training) in a given period. When new hires are trained the trainer gets credit for the evaluation, not the trainee, so the database records only one technician for each evaluation.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!