1 / 15

Hospital Application

This application aims to create a comprehensive database for hospitals in a region, enabling the tracking of patients, equipment, room assignments, and staff. With this database, users can easily locate patients or equipment and generate reports on staff, rooms, equipment, and patient diagnosis information.

saho
Download Presentation

Hospital Application

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Hospital Application Want to create a database for all hospitals in a region. In conferring with the client we find them talking about the individual hospitals and wanting to keep track of Patients, equipment, room assignments, Staff (doctors nurses, maintenance, etc).

  2. Hospital Application From this database one should be able to locate patients or equipment; produce reports on staff, rooms, equipment, patient, diagnosis information, etc.

  3. Hospital Application Some conditions: Patient must be assigned a room outpatients will have room no for OP area Every room must be associated with a hospital. Each piece of equipment must be assigned a room. Each staff member must be assigned to a hospital. A doctor is a staff member and a diagnosis must be associated with a doctor. Patient must be assigned a room, if diagnosed must be associated with a doctor. Staff must be associated with a hospital

  4. Hospital Persons Rooms Patients Staff Doctors Equipment

  5. Hospital Hospital number Integer (3 digit) Primary Key Name Character (20) Address Character (20) Capacity Integer (4 digit)

  6. Rooms Hospital Number Integer (3 digit) Primary Key Room Number Integer (3 digit) Primary Key Type Character (10) Number of beds Integer (2 digit) Hospital number must be in hospital

  7. Equipment Serial Number Character (8) Primary Key Description Character (20) Cost Money Must be assigned to a room which is currently in the database

  8. Persons SIN Number Character (9) Primary Key Name Character (20) Address Character (30) Birthdate Date8 Assign to a hospital.

  9. Doctors Doctor Number Integer Primary Key Specialty Character (10) Is a person must be in person file diagnosis patients

  10. Patients Date admitted Date Date exited Date Is a person must be in Persons list must be assigned a room (outpatient will have a room number) Diagnosed by a doctor - not required if diagnosed (date, doctor, diagnosis)

  11. Staff Class type Character (2) Must be in person Must be assigned to a hospital

  12. Hospital hire has Persons Rooms In Is a Patients Is a Is a have Staff Doctors diagnose Equipment diag Date

  13. Hospital 1 Hires 1 has N Persons N N Rooms In 1 1 1 M Is a 1 Patients Is a Is a N have N 1 1 N Staff Doctors M diagnose Equipment diag Date

  14. Hospital Hires 0:1 1:1 has 1:M Persons 3:N Rooms In Rooms 1:N 1:1 1:1 1:1 0:M Is a Patients 1:1 Is a Is a 0:N have N 0:1 0:1 Staff Doctors 0:N diagnose M Equipment diag Date

  15. Hospital Hires 0:1 1:1 has 1:M Persons 3:N Rooms In Rooms 1:N 0:M {mandatory,Or} Patients 1:1 have N Staff Doctors 0:N diagnose M Equipment diag Date

More Related