Answer to Question #313560 in Databases | SQL | Oracle | MS Access for Selma Shigwedha

Question

Question 1 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 given requirements. 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.

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