Infopaket

Databases and Knowledge Bases

ОК 18

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

First

2023/2024

4 Semester

6

PR10 - Apply software development tools for client-server applications, design conceptual, logical, and physical database models, develop and optimize queries, create distributed databases, including cloud services.

Full-time form

1. Have knowledge of the basics of discrete mathematics and mathematical logic, set theory, algorithmization, and programming. 2. Be able to perform analysis of the information space of tasks in order to structure the input and output information, information circulating in the system, and needed to solve specific tasks. 3. Possess elementary skills in working with any programming tool environment, developing high-level language programs to implement the given task.

The course "Databases and Knowledge Bases" is designed to provide a theoretical foundation, teach students the basics of database design and operation, introduce them to the SQL language for defining and manipulating data, and to the fundamentals of knowledge bases, taking into account the current state and forecast of information systems (including NoSQL databases). Students will also be introduced to modern technologies and development tools for database systems, as well as the basic principles of knowledge base construction. The course is aimed at developing students' ability to apply theoretical and practical foundations of database design methodology, implement a multi-tiered computing model based on client-server architecture, including databases, data warehouses, and knowledge bases, to meet the computing needs of multiple users. They will learn how to create, use, and maintain database systems within the framework of modern information systems.

1. Gayna H.A. Basics of Database Design. Textbook. - Kyiv: Kondor, 2018. - 204 p. 2. Trofymenko O.H. Organization of Databases: Textbook / O.H. Trofymenko, Yu.V. Prokop, N.I. Loginova, I.M. Kopychuk. 2nd revised and expanded edition. - Odesa: Phoenix, 2019. - 246 p. 3. Gerardus Blokdyk. Microsoft SQL Server A Complete Guide - 2019 edition, - 304 p.

Lectures, laboratory works, individual work

Students are evaluated throughout the semester based on various types of assignments. The overall grade for the semester is determined by the weighted sum of the points earned by the student on different types of assignments. The maximum number of points a student can receive for an assignment in the semester does not exceed 60 points on a 100-point scale. The discipline concludes with an exam. Throughout the semester, after completing relevant topics, three written tests (KT1, KT2, KT3) are conducted with multiple choice and open-ended questions, as well as practical tasks. All laboratory and independent work is mandatory. To receive a passing grade for the discipline, a student must achieve at least 60% of the maximum possible points. The maximum number of points a student can receive on the exam is 40 points on a 100-point scale. If a student receives less than 24 points during the exam, they will receive a failing grade and the earned points will not be counted.

Ukrainian