INFORMATION-SYSTEM ON INVESTIGATIONS OF THE ADRIATIC SEA

Development of the integral referral Information System on Investigati ons of the Adriatic Sea, with built-in functional and organizational a spects 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 DataBa se Management System) ''INGRES'', the Information System (IS) has been designed and implemented. The IS design process is described in detai l. The system was subdivided into three subsystems: POM (Project Organ ization Module), EOM (Expedition Organization Module), and SPMM (Sampl ing and Parameter Measurements Module). The necessary entities and the ir relationships were defined using the E-R (Entity-Relationship) diag ram concept. The integral E-R diagram was transformed into a set of 3N F (Third Normal Form) relation schemes. The SQL (Structured Query Lang uage) command file was generated and started in the INGRES, producing a relational database scheme. The integrity constraints were built int o the database by defining 87 SQL procedures and 146 rules for 61 rela tion schemes. Therefore, the database integrity control could be perfo rmed 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 ena bles data presentation in space and time under user-defined conditions . The verification of the system was performed using real data from th ree research projects.