Guba A. V., Zaitseva T. A., Osadcha O. V.

Oles Honchar Dnipropetrovsk National University


The scientific and technical progress requires the further implementation of information technology, and medicine is no exception. Introducing information technologies in the system of health care of Ukraine first of all means that the necessary information can be quickly targeted and obtained by medical workers.

Developing programs for medicine is one of the most challenging tasks in many areas of information society. Such programes can provide a significant amount of diversified information about patients which makes it possible to make a diagnosis, prognosis and administer the necessary treatment of a disease. The textual form is inconvenient while analyzing large databases. Important consequences of automation clinic using MIS include reducing the number of diagnostic errors through information control diagnostic process, reducing the time for keeping medical records and reports.

After studying the subject and the problem, it was decided to develop a database using MS Access 2007 and language SQL – queries.

At the first stage of development, it was found that the database should contain the following information: data about patients, diseases, disease statistics, data about employees, types of endoscopic examination.

At the second stage the tables were designed using SQL – queries. The table "Patient" includes patient’s personal data, his medical history, date of treatment and a diagnosis. The table can add a new patient and modify information. The table "Employees" reflects the personal data of employees (personal ID number, name of employee, address, phone number) that you can edit, add, delete. The table "Types of diagnosis" contains information about endoscopic diagnostic methods used in the department for patient’s examination, namely a unique diagnosis code type and name, an employee personal code, a diagnosis code, information about examining a patient. The table "Diagnosis" includes information about the unique ID of the diagnosis, a type of diagnosis (which section gastrointestinal disease is referred to), a diagnosis code of the endoscopic examination office. This table is essential for keeping disease statistics. For each table field a field name, a data type and field properties were defined. The primary key and set relationships between tables were identified.

At the next stage with the help of the SQL language queries were developed by a select, update, delete, add data.

Request "This patient" displays the patient’s name, the date of his arrival to the endoscopy office, the date of discharge from the hospital, his diagnosis and diagnostic research results. Request "Finding a doctor to patient" allows you to display information about the doctor who performed the examination of a certain patient. Request “Patient’s diagnosis search” allows you to record the number of patients with the same diagnosis that simplifies the process of keeping statistics. Request "Sampling in diagnosis" enables the user to determine what endoscopic examination the patient had, when and what diagnosis was made. "Search patient’s diagnosis" gives the information about the diagnosis made. "Finding patients by the endoscopy type" shows all patients undergoing various types of diagnostics.

The report "Diagnosis" provides an opportunity to display and print data on the diagnosis, the endoscopic method used, the patient's name and the date of a diagnosis.

The report "Patient’s health record” displays the information about the patients, a diagnosis, a type of ongoing diagnosis, the date of admission and discharge.

The report "diagnosis" displays the information about the type of diagnosis (which section gastrointestinal disease refers to). Each diagnosis has its own unique code.

 The database begins with the main window where all tables are presented. This is rather convenient because it is assumed that the information can always be updated. The workspace consists of three tabs: "Record", "Staff", "Statistical data" and "Exit from the database".

The developed software is aimed at the full computerization of medical and diagnostic processes, keeping track of patient care staff in the endoscopy department and keeping medical statistics.