Question

A dentist’s office needs to keep information about patients, the number of visits they make to...

A dentist’s 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. *Make sure to indicate all primary keys, weak-strong entities, total participations, etc.

Homework Answers

Answer #1

PLEASE GIVE IT A THUMBS UP, I SERIOUSLY NEED ONE, IF YOU NEED ANY MODIFICATION THEN LET ME KNOW, I WILL DO IT FOR YOU


The ones in the rectangular boxes are the Entity
The ones in the elliptical shapes are the Attributes
The attributes which are underlined are the primary key attributes
The ones in the diamond-like shapes structures are the Relations
Many Patients pay many visits, therefore many to many relations are shown
Many visits are there in a single clinic, therefore many to one relation is there
The single clinic has many laboratories, therefore one too many relations is shown.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions