Question

question One:

Design an ER diagram for the following Dental Clinic database. Your diagram should have all the needed details. You may make any reasonable assumptions but you have to state them clearly.

------ The clinic has several dentists. Each dentist has a unique Number, name, nationality, multiple room-number, salary, birth-date and home-address (Box, City, Zip). Each client (patient) has a unique Code, name, home-phone, work-phone, address, and birth-date. Each client is assigned to one dentist. All future visits will be to the same dentist. A client can be insured or self-paying. An insured client should have an insurance company-name, and company-Phone, while a self-paying client must have a bank-name and a bank account. Each visit of a client is described by a date, type, action, fee, and date-of-next-appointment -------

question two: Convert then ER Diagram that presented in question one to Relational Schema.

* don't miss anything please, I have two question

Answer 1

Let's first try to figure out the entities for the entity relation diagram. Following are the entities:-

1. Doctor

2.Patient

3.Visit

• The relationship between doctor and patient is patient gets treated by doctor or we can say a patient visits doctor for treatment.
• A patient is assigned to one doctor but multiple patients are assigned to one doctor. so, relationship between doctor and patient is one to many.
• A patient may visit many times, but a visit cannot belong to more than 1 patient. so, relationship between each visit and patient is one to many.
• Similarly, a doctor may attend number of visits but a visit will only be attended by a single doctor. so, relationship between doctor and visit is one to many.
• Similarly, a patient may have insurance in one particular company but that company can have multiple patients insured under it so, relationship between company and patient is one to many and same is the case for bank.

Find below the ER model derived from above conclusions.

aw naton 800 Sale DOCTDR adeoas dake ATTEND ASSI 녀 TO achn ty 006S PATIENT dake B6LONGS To COMPANY no

Find the corresponding relational model below.

viet dae id F Por.id COMPENy

I have tried my best to attempt and explain the question to you. Hope you will like it and it will help you!!! Thanks!!!

Do give it a thumbs up!!!