Design a database for a hospital with a set of patients and a set of medical doctors. The database should capture each encounter between a doctor and a patient on each visit. Associate with each patient alox of the various tests and examinations conducted. Those tests can be ordered by a doctor, but this is not mandatory, The database should keep track of the dates of the tests as well as their results. Draw an ER-diagram for your design. Underline the primary key in the entity sets. Q8: (6 points) Reduce your ER-diagram to relations. Underline primary keys