Databases and Knowledge Bases

Course: Computer science

Structural unit: Faculty of information Technology

Title
Databases and Knowledge Bases
Code
ОК 18
Module type
Обов’язкова дисципліна для ОП
Educational cycle
First
Year of study when the component is delivered
2022/2023
Semester/trimester when the component is delivered
4 Semester
Number of ECTS credits allocated
6
Learning outcomes
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.
Form of study
Full-time form
Prerequisites and co-requisites
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.
Course content
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.
Recommended or required reading and other learning resources/tools
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.
Planned learning activities and teaching methods
Lectures, laboratory works, individual work
Assessment methods and criteria
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.
Language of instruction
Ukrainian

Lecturers

This discipline is taught by the following teachers

Departments

The following departments are involved in teaching the above discipline