Question: Draw an entity relationship diagram ( ERD ) for the following situation, you must include a narrative explaining what you think your ERD means: Problem:
Draw an entity relationship diagram ERD for the following situation, you must include a narrative explaining what you think your ERD means:
Problem: You run an auto repair business called William Robert's Automotive Service Center. Whenever new customers are seen for the rst time, they complete a customer information form that asks their name, address, phone number, insurance carrier, and credit card info, all of which are stored in the customer information le Customers can be signed up with only one carrier, but they may not have insurance at all. Each time a customer visits, an insurance claim is sent to the carrier for payment or the credit card is charged. The claim must contain information about the visit, such as the date, purpose, and cost. It would be possible for a customer to submit two claims on the same day.
The ERD you create should include entities, attributes, relationships, cardinalities max and min and identifiers primary and foreign keys You must state all assumptions you make in creating the ERD, and you need to provide a narrative in plain language describing what your ERD says.
Your diagram will need to be created using a diagramming tool such as LucidChart.com I need an answer in lucidchart.com" diagram and explanation.. thank you
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
