You have been tasked to design a database for use at a doctor’s private practice. There is only one doctor at the practice and many patients consult the doctor presenting various health issues. The patients pay the fees due in cash or may complete their medical aid forms. On consultation, the patient describes their symptoms and the doctor diagnoses a disease/ ailment that the patient may be suffering from. Some patients present symptoms as a sign to more than one disease. In cases where the doctor cannot assist the patient, they refer the patient to a specialist. a. List all the entities you can identify for the scenario. b. Identify attributes for each of the identified entities, clearly marking the primary key/s. c. Which of the identified entities are related? Describe the cardinality of the relationships.
Question 3
You have been tasked to design a
doctor at the practice and many patients consult the doctor presenting various health issues. The
patients pay the fees due in cash or may complete their medical aid forms. On consultation, the
patient describes their symptoms and the doctor diagnoses a disease/ ailment that the patient may
be suffering from. Some patients present symptoms as a sign to more than one disease. In cases where
the doctor cannot assist the patient, they refer the patient to a specialist.
a. List all the entities you can identify for the scenario.
b. Identify attributes for each of the identified entities, clearly marking the primary key/s.
c. Which of the identified entities are related? Describe the cardinality of the relationships.
d. Which schema does your answer to a, b and c represent? Justify your answer.
e. At which phase/stage of the Database Development Processis the schema identified in d. defined
Step by step
Solved in 3 steps with 2 images
