Answer to Question #312231 in Databases | SQL | Oracle | MS Access for Samantha

Question

Create the ERD using UML notation to show the relationships between DENTIST, PATIENT and

SURGERY. Also show the multiplicity in the relationships and attributes.

• The patient must be examined by more than one dentist and a dentist can examine at least one patient;

• Dentist number, dentist name, office number, cellphone number and email address must b captured on the system;

• A dentist can examine more than the minimum of three patients per day;

• The following patient details need to be captured on the system: patient number, patient name, street address, email address;

• Each surgery is assigned an examination at the time as instructed by dental clinic policy.

Answer 1

It's been a while since this question is posted here. Still, the answer hasn't been got. Consider converting this question to a fully qualified assignment, and we will try to assist. Please click the link below to proceed: Submit order