create an entity relationshp diagram.

You are to create a small DB for a hospital. The DB should contain the information about patients and physicans. Attributes of physicians include physician ID (identifier), name(first and Last) and specialization. Every patient has a name (first and last) and a unique patient ID. When a patient is admitted to the hospital, the patient must be assign a physician in charge of the admission procedure. For every admission, the date of the admission to the hospital is stored. A physician may optionally oversee the admission procedure for any number of patients. Once admitted, a given patient must be treated by at least one physician. A particular physician may treat any number of patients, or may not treat any patients. Whenever a patient is treated by a physician, the hospital wishes to record the details of the treatment (treatment day, time, and the results).