Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A dentists office needs to keep information about patients, the number of visits they make to the office, work that must be performed, procedures performed

A dentists office needs to keep information about patients, the number of visits they make to the office, work that must be performed, procedures performed during visits, charges and payments for treatment, and laboratory supplies and services. Assume there is only one dentist, so there is no need to store information about the dentist in the database. There are several hundred patients. Patients make many visits, and the database should store information about the services performed during each visit and the charges for each of the services. There is a standard list of charges, kept outside the database. The office uses three dental laboratories that provide supplies and services, such as fabricating dentures. Draw a complete E-R diagram for this example.

I need help filling the rest whether it's one to many, Partial, Total, Min, Max, etc. I did the first part from Patient to Visit. Does it need min, max, partial, total, etc?

image text in transcribed

Patient Phone Location Number Calls Visit Name P.P (0,M) Name PID Phone (Address) Number Date Dentist Office Time Reason For Treatment Has Procedure) Laboratories Services Supplies LID Patient Phone Location Number Calls Visit Name P.P (0,M) Name PID Phone (Address) Number Date Dentist Office Time Reason For Treatment Has Procedure) Laboratories Services Supplies LID

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sql All In One For Dummies 7 Books In One

Authors: Allen G Taylor ,Richard Blum

4th Edition

1394242298, 978-1394242290

More Books

Students also viewed these Databases questions

Question

Manage and maintain a dialogic loop with audiences

Answered: 1 week ago

Question

design a simple disciplinary and grievance procedure.

Answered: 1 week ago