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 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 Databases Questions!