database management system

Construct an ER diagram for a hospital with a set of patients and a set of medical doctors. Associate with each patient a log of the various tests and examinations conducted. Record every patient's name, insurance, admittance date, and leave date as well as id numbers. Every doctor is assigned on id, his/her name as well as specialization is kept. Every test has an id, name, result, date, and time. i. Construct an E-R Diagram ii. Construct appropriate tables (schema) for the E-R diagram in (a)