Databases are central to business information systems and RDBMS is most widely used for the database system. Normalization was designed to control various anomalies (insert, update, delete anomalies). However, normalized database design does not account f

Databases are central to business information systems and RDBMS is most widely used for the database system. Normalization was designed to control various anomalies (insert, update, delete anomalies). However, normalized database design does not account for the tradeoffs necessary for performance. In this research, we model a database design method considering denormalization of duplicating attributes in order to reduce frequent join processes. This model considers response time for processing each select, insert, update, delete transaction, and for treating anomalies. A branch and bound method is proposed for this model.

The objective of this research was to develop a relational database management system(RDBMS) to collect, manage and analyze data on agricultural non-point source(NPS) pollution. The system consists of the relational database for agricultural NPS data and data process modules. The data process modules were composed of four sub-modules for data input, management, analysis, and output. The data collected from the watershed of the upper Cheongmi stream and Geunsam-Ri were used in this study. The database was constructed using Apache Derby with meteorological, hydrological, water quality, and soil characteristics. Agricultural NPS-Data Management System(ANPS-DMS) was developed using Oracle Java. The system developed in this study can deal with a variety of agricultural NPS data and is expected to provide an appropriate data management tool for agricultural NPS studies.

본 연구에서는 유역 수문자료를 효율적으로 관리할 수 있는 수문자료관리시스템(HDMS)을 개발하였으며 경기도 화성시에 위치한 발안시험유역을 대상으로 시스템의 적용성을 보여주었다. MySQL 5.0을 사용하여 관계형 데이테베이스를 설계하였으며, MS-Visual Basic 6.0을 이용하여 윈도우 기반의 시스템을 개발하였다. HDMS는 자료검색시스템, 자료관리시스템, 자료분석시스템으로 구성되었다. 자료검색시스템과 자료관리시스템은 자료검색, 자료저장, 자료갱