You have been asked to design a database for a single hospital (there is only one hospital it is not part of a group of hospitals). The hospital wants to keep track of data about transactions regarding patients. The hospital wants to keep track of patient admittance, as well as patient treatment by health care professionals. Patients are admitted to the hospital by physicians, but physicians are only one kind of health care professional (HCPROF) at the hospital. Assume that the hospital has a large number of HCPROFs, but they dont need to differentiate between physicians and other types of HCPROFs. Attributes of HCPROF include HCPROFID (identifier), type, and specialty. When a patient is admitted to the hospital, the hospital wants to keep track of the patient, the date and time the patient was admitted and also the admitting HCPROF. It is possible that a patient may be admitted to the hospital more than once. The hospital wants to keep the patients on file with the assumption that the patient may be admitted more than once and the hospital needs to know each different date and time that a patient was admitted. Attributes of PATIENT include patient_id (identifier) and patient_name. Any individual patient who is admitted must have exactly one admitting HCPROF, but an HCPROF may admit no patients or many patients. Once admitted, a given patient may be treated by no HCPROFs, but could be treated by multiple HCPROFs. The particular HCPROF who admits a given patient may or may not treat that same patient. A particular HCPROF may treat any number of patients, or may not treat any patients. Whenever a patient is treated, the hospital records the details of the treatment (TREATMENTDETAIL). Attributes of TREATMENTDETAIL include date, time, and outcome. It is possible that more than one HCPROF participates in the same TREATMENTDETAIL for a patient. For example, it is possible that during a single TREATMENTDETAIL like a consultation about a patients pain, a Neurologist, a Psychologist and a Nurse Practitioner (all are considered HCPROFs) may participate. The hospital wants to keep track of all HCPROFs who participate in a treatment. For each HCPROF who participates in a TREATMENTDETAIL, the hospital wants to record the notes from the HCPROF and the amount of time that the HCPROF spent on the treatment. For example, if three HCPROFs participate in a single TREATMENTDETAIL for a single patient, the hospital wants to keep track of the notes and time spent individually for each of the three HCPROFs.