Infopaket

Geodata Management Systems

ВК 2.8.6

Вибіркова дисципліна для ОП

First

2023/2024

7 Semester

6

Knowledge Required: - Understand the main data organization models. - Know the structural elements of relational databases. - Be familiar with key data types, including geodata. - Understand the primary methods of organizing base tables, indexes, and queries. - Comprehend data integrity and data anomalies. - Know the purpose and syntax of basic SQL language operators. - Be familiar with the main modules of database management systems. - Understand the specifics of representing geological data and organizing access to it. Skills Required: - Be able to create basic tables and queries to solve assigned tasks. - Determine input and output data, as well as their format, for solving assigned tasks. - Write and test SQL commands, and define test cases. - Use database management systems for data entry and utilization, including geodata. - Organize information in databases in a clear format accessible to other users for effective task resolution.

1. Successful completion of the "Information Technology" course. 2. Possess basic skills in working with a personal computer.

An introduction to the fundamentals of data organization and database management systems takes place. Students become familiar with the stages of developing the main elements of databases, their representation, and evaluation. General paradigms of database design are studied, and students are introduced to modern database management environments. Students also become acquainted with the structure and primary definitions of the SQL programming language.

1. Mulesa O.Yu. *Fundamentals of SQL Query Language*. - Uzhhorod, 2015. - 48 pages. 2. *Databases: Educational and Practical Guide for Students' Independent Work* [Electronic resource] / M.Yu. Losev, V.V. Fedko. – Kharkiv: S. Kuznets KhNEU, 2018. – 233 pages. 3. Pashchenko R.E. *Database Design for Geodata: Lecture Notes* / Educational Literature, 2018, 15 pages. 4. Berko A.Yu., Veres O.M., Pasichnyk V.V. *Database and Knowledge Systems. Book 2. Database and Knowledge Systems. Educational Manual* / "Magnolia-2006", 2013 - 584 pages. 5. *Geoinformation Systems and Databases: Monograph* / V.I. Zatserkovnyi, V.G. Burachek, O.O. Zheleznyak, A.O. Tereshchenko. – Nizhyn: M. Gogol NDU, 2014. – 492 pages.

Lectures, practical sessions, independent work

Assessment is carried out using a modular rating system and includes: completion of 10 practical tasks (where students must demonstrate the quality of acquired knowledge and solve assigned problems using methods and tools specified by the instructor) and the completion of 2 written modular tests. Final evaluation is conducted in the form of a written-oral exam.

Ukrainian