ER Diagram Scenario( Doctor, Patient, Tests)
A doctor sees many patients and a patient may have many doctors. Many doctors may consult on a test and recommend it A doctor can recommend many tests to a patient. Patients have a token number name and age Doctor has name, qualification, specialization and contact no. likewise test has name, date, time and result of test Patient doctor and test have unique identifiers.
Observer the above scenario and answer the following:
a) List the entities b) List attributes for each entity
C) Draw an E-R diagram and assign cardinalities