DATABASE FUNDAMENTALS
DATABASE CONCEPTS AND STRUCTURES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
One-to-One
|
|
|
One-to-Many
|
|
|
Many-to-Many
|
|
|
Many-to-One
|
Detailed explanation-1: -The Doctor and Patient entity have a one-to-many relationship as a Doctor may treat more than one patient. Similarly, Patient and Medicine have a many-to-many relationship as a patient may buy more than one medicine and vice-versa. ‘Code’ is the key attribute for Medicine which is unique for every medicine.
Detailed explanation-2: -Many-to-many relationships between two entities suggest the need for a third entity not yet specified. In Figure 6, a clinician provides many different types of treatments and a particular treatment can be offered by many clinicians. The two entities have many to many relationship.
Detailed explanation-3: -A doctor–patient relationship (DPR) is considered to be the core element in the ethical principles of medicine. DPR is usually developed when a physician tends to a patient’s medical needs via check-up, diagnosis, and treatment in an agreeable manner.
Detailed explanation-4: -Many people see more than one doctor or health professional. Your primary care doctor, such as your internist or family doctor, may refer you to another doctor for a problem. You may see a specialist for another health concern. You may need a surgeon.