Draw an Entity-Relationship (ER) diagram for a General Hospi


Draw an Entity-Relationship (ER) diagram for a General Hospital’s database using the following information.

1. The General Hospital consists of a number of specialized WARDS (such as Maternity, Pediatrics, Oncology, etc). Each ward has a name, code and hosts a number of patients.

2. On admission, the personal details of every PATIENT are recorded. These include ID, name, address, gender, birth date and illness. We also need to store the information of the tests undertaken by a patient and the results of a prescribed treatment. A number of tests may be conducted for each patient. Each patient is assigned to one leading consultant but may be examined by another doctor, if required.

3. Each patient also has a ATTENDANT. This person is a family member or friend who looks after the patient and takes responsibility for them.

4. DOCTORS have their own IDs and a specialization in some branch of medicine and there are three types of doctors – consultants, specialists and interns. Each intern is supervised by a specialist doctor. One doctor can act as a consultant for a several patients. Their patients can be admitted in a number of wards.

Clearly show primary key attributes.

Kemahiran: Pentadbiran Pangkalan Data

Lihat lebih lanjut: diagram hospital, diagram hospital database, diagram general hospital, hospital database diagram, general hospital diagram, hospital diagram, draw diagram hospital, diagram database hospital, draw diagram general hospital, diagram general hospital database, draw database hospital, diagram hospital patient, diagram maternity hospital, diagram hospital treatment, diagram doctor patient relationship, diagram hospital doctor patient, diagram hospital doctors patients, diagram doctor patient hospital, database hospital diagram, diagram hospital general wards, code patients hospital diagram, diagram hospi, draw diagram hospital database, diagram hospital patients admitted, diagram hospital admission

Tentang Majikan:
( 0 ulasan ) Jeddah, Saudi Arabia

ID Projek: #1583043