Infopaket

FUNDAMENTALS OF DATABASE THEORY

ОК 29

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

First

2024/2025

1 Semester

3

PLO 3. Communicate information, ideas, problems, solutions, own experience and arguments to specialists and non-specialists. PLO 7. Perform surveying and surveying, topographic and geodetic, cartographic, design and design-survey work when performing professional tasks in geodesy and land management. PLO 9. Collect, evaluate, interpret and use geospatial data, metadata on objects of natural and man-made origin, apply statistical methods of their analysis to solve specialized tasks in the field of geodesy and land management.

Full-time form

1. Successful completion of the courses: "Higher Mathematics", "Fundamentals of Geoinformation Systems and Technologies". 2. Knowledge of the theoretical and practical foundations of linear algebra, programming and geoinformatics. 3. Possession of elementary skills in the Python, ArcGIS software environment.

The purpose of the discipline is to provide basic knowledge of the theory and practical application of databases in the geographical field. Providing students with basic knowledge of the theory of forming logical models of geospatial databases, as well as to form the necessary practical skills for creating such databases in the ArcGIS software environment. The course consists of two content modules: the first module - considers abstract issues related to database architecture and methods used for high-level database design. At this stage (design stage), those aspects of databases that depend on a specific technical or software will not be considered. Attention is focused on data elements and the relationships between them, terminology and various database models are considered. The design of database models begins using the class diagram notation of the Unified Modeling Language (UML), and database structuring is considered to minimize redundancy and ensure data integrity. The second module moves from the basics of databases to a direct consideration of applied geographic information systems, moving from abstract design principles to more specific implementation issues. It examines how to display UML constructs on tables, create rows and columns to prepare the database itself. It begins to study the process of creating geodatabases - defining model structures, loading data into these structures, and maintaining the geodatabase during use. It discusses the tools of the geodatabase itself, which help ensure data integrity, including domain and referential integrity and topological consistency of spatial object models. It studies ways to directly interact with the database using the SQL (Structured Query Language).

1. ДСТУ ISO 19101:2009 "Географічна інформація/геоматика: Географічна інформація – еталонна модель. – К.: Держспоживстандарт України, 2011. –37с. 2. ІSO/ІECCD13249-3:2006(E) – Text for FDІ Ballot Information technology – Database languages – SQL Multimedia and Application Packages – Part 3: Spatіal. – ISO/IEC, May 15, 2006. 3. Yeung, Albert K.W.; Hall, Brent G. Spatial database system: design, implementation and project Management . The GeoJournal Library, vol. 87. – Springer, 2007. – 553 p.

Lectures, practical classes

Organization of assessment: (the procedure for organizing the assessment forms provided for by the working curriculum with an indication of the approximate assessment schedule must be specified). Assessment is carried out during the semester based on the results of practical work (three assessments) and a test test after completing the tasks of the first content module and during the examination session by passing an exam. The overall grade for the discipline is derived by summing up the points received during the semester and during the exam. Final assessment in the form of an exam (written form): the maximum number of points on the exam is 40 points, the minimum number of points added to the semester ones is 24 points (60% of the maximum number of points allocated for the exam). Students who have scored a total of less points than the critical minimum of 20 points are not allowed to take the exam. The recommended minimum for admission to the exam is 36 points.

Ukrainian