Infopaket

Database Development

ОК 13

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

Second

2022/2023

1 Semester

7

Process the results of geodetic measurements, topographic and cadastral surveys, using geographic information technologies and computer software and database management systems. Have modern technologies for data collection, processing, exchange, transformation and integration in various fields of geosciences.

Full-time form

1. Have an initial level of information technology; 2. Have the skills to work with a personal computer, have a basic level of programming knowledge. 3. It is desirable to master the basic course "Geodatabase Management" or similar (optional).

There is an acquaintance with the basics of designing geodatabase structures, principles of optimization and testing. General design paradigms are studied databases, their place in modern decision support systems and data analysis. Students acquire practical skills of analysis of attributive information and creation of relational geodatabases.

1. Date, K., J. Introduction to database systems. 6th ed. - TO.; M., St. Petersburg: "Williams", 2000. 2. Pasichnik V., Reznichenko V. Organization of data bases and knowledge. – K.: BHV, 2006. 3. Ladychuk D., Pichura V. Bazy heoinformatsiinykh danykh. – Kherson: KhDU, 2007. 4. Database Tutorial, https://www.quackit.com/database/tutorial/

Lectures, practical work, independent work

1. Semester assessment: 1) Test work on the basics of data organization and normalization of relational databases -10 points (marginal score of 6 points) 2) Test work on the basics of structured query language and database design - 10 points (marginal score of 6 points) 3) Score for work in practical classes - 40 points (threshold score of 24 points) 2. Final assessment in the form of an exam: maximum score of 40 points, marginal score of 24 points. During the exam the student answers a theoretical question and performs a test task for comprehensive knowledge of relational database structures and SQL syntax. The results of students' learning activities are evaluated on a 100-point scale.

ukrainian, english