DATA BASES.

Please do an a class diagram.

Problem: Dr. House Clinic At Dr. House's clinic they need a system to keep track of patients and doctors. Data such as card number, name, surname, address, telephone number and date of birth are stored for each patient. The identification number, name, surname, telephone number and specialty of each doctor are recorded. It is desired to keep track of each of the admissions that the patient makes to the clinic, it is considered admission when the patient spends at least 1 night in the clinic, that is, only of the patients who are hospitalized to undergo some treatment or surgery, taking into account the medical history of each one, if he had any treatment, if any laboratory test was performed, etc. A consecutive identifier is kept for each admission, the room number, bed number, and the date of entry and date of departure. Each room can have at most 5 beds. A doctor can attend several admissions, but a patient's admission can only be attended by a single doctor. A patient can make several hospital admissions. The clinic manager must obtain reports to know the availability of beds, the doctors who are treating which patients, the conditions of the patients, etc.