Database Design in Ward Nursing Information System

병동간호업무 전산화를 위한 데이터베이스구축;간호업무기록지를 중심으로

In the complexity and diversity of modern society, there is an urgent need for an information system which can systematically collect, manage and analyze data. Especially in the discipline of nursing, a nursing informarion system is necessary to maximize nursing resources and improve nursing care in the present system which is faced with increases in client needs and multiple changes in hospital environments. This research was done to provide a basis for the development of an integrative nursing information system for the future, by designing dababases items which were extracted from an analysis of the ward nursing information system on general wards excluding the OPD, ICU, OR and CSR with functions using a different system from the wards, and the design of output screen used the database items. The ward nursing information system was analysed through analysis of nursing practice related to recordings, such as the worksheet, kardex, and other nursing practice recordings, on 25 wards. The development of the database was the part of the construction of hospital information system and used the database development life cycle which is related to the system development life cycle. The database development steps included selection of database management system and design of a physical database following the principles of the order communication system which is been developing at Y University Hospital. Conceptual database and Logical database were designed using the base of 25 data items and fields derived from analysing the worksheet, the data items and fields derived from the kardex and other nursing practice recording, from these 19 data base tables were framed through transforming the relational database. Through this process, four types of output material for nursing practice recording which nurses can carry and use during their nursing practice were produced.