Jack is developing an ERD for a small dental practice office patient record system.The dental practice has three dentists,six hygienists,and many patients.A patient is always assigned to the same dentist for all appointments.In particular,he is working on the relationship between dentists and patients.Should it be:
A)1 to 1,with a modality of null
B)1 to many with a modality of not null
C)Many to many with a modality of null
D)Many to many with a modality of not null
E)1 to many with a modality of null

Question

Quizplus · Accepted Answer

A patient is always assigned to the same dentist, which means one dentist can have many patients but a patient can only have one dentist. Therefore, the relationship between dentists and patients should be 1 to many with a modality of not null.

Jack Is Developing an ERD for a Small Dental Practice