@article{Panitsidis_Andreopoulou_Kokkinakis_2017, title={Multimedia database development for innovative application about fish fauna for inland water ecosystem management}, volume={8}, url={https://journal.magisz.org/index.php/jai/article/view/406}, DOI={10.17700/jai.2017.8.3.406}, abstractNote={This paper describes the development of an innovative application with a multimedia database, concerning the management of fresh water fish fauna in the inland water ecosystems of Greece. This database is a baseline for keeping descriptive information of fresh water fish fauna and bibliographic spread reports. The database has provision for both descriptive and geographic mapping (GIS). The sources of the data used for the database population were from a) The Red Book of Endangered Animals of Greece b) IUCN (International Union for Conservation of Nature and c) Ministry of Environment & Energy (Study 6: Supervision and Evaluation of the Conservation status of fish species of Community interest in Greece). A detailed description will be made for the development of the stages of the database (Conceptual - Logical - Physical Design). The database management system was developed in Microsoft Access and in pgAdmin, which is an open source administration and development platform for PostgreSQL. In addition, we will mention the filling of the database and the Entity - Relationship Model. The database due to its structure and data it will be able to provide answers to hypothetical scenarios to the application that will use it. Furthermore, the aim of this project is to construct a database that will provide ichthyologic and environmental data. The main advantage is the compatibility with various software platforms and that it can be easily expanded.}, number={3}, journal={Journal of Agricultural Informatics}, author={Panitsidis, Konstandinos and Andreopoulou, Zacharoula and Kokkinakis, Antonios}, year={2017}, month={Nov.} }