Original scientific paper

Information System on Investigations of the Adriatic Sea

Jadranka Pečar-Ilić ; Faculty of Electrical Engineering and Computing, University of Zagreb, Unska 3, 10000 Zagreb, Croatia
Ivica Ružić ; Ruđer Bošković Institute, Center for Marine Research, P.O.B. 1016, 10001 Zagreb, Croatia
Zoran Skočir ; Ruđer Bošković Institute, Center for Marine Research, P.O.B. 1016, 10001 Zagreb, Croatia

Abstract

Development of the integral referral Information System on Investigations of the Adriatic Sea, with built-in functional and organizational aspects of the performed investigations, is described. According to the selected development method, adapted to the software available CASE (Computed Aided System Engineering) »POSE« & RDBMS (Relational DataBase Management System) »INGRES«, the Information System (IS) has been designed and implemented. The IS design process is described in detail. The system was subdivided into three subsystems: POM (Project Organization Module), EOM (Expedition Organization Module), and SPMM (Sampling and Parameter Measurements Module). The necessary entities and their relationships were defined using the E-R (Entity-Relationship) diagram concept. The integral E-R diagram was transformed into a set of 3NF (Third Normal Form) relation schemes. The SQL (Structured Query Language) command file was generated and started in the INGRES, producing a relational database scheme. The integrity constraints were built into the database by defining 87 SQL procedures and 146 rules for 61 relation schemes. Therefore, the database integrity control could be performed while the data were inserted. The developed application is based on hierarchically organized frames (Menu, Browse and Report), allowing the information flow (»top- down«) between them. The application enables data presentation in space and time under user-defined conditions. The verification of the system was performed using real data from three research projects.

Keywords

Hrčak ID:

135640

URI

https://hrcak.srce.hr/135640

Publication date:

3.4.1997.

Visits: 839 *