ORGANIZATION OF DATABASES AND KNOWLEDGE

Abstract of the academic discipline

The purpose of studying the discipline "Organization of databases and knowledge" is providing knowledge of the principles of designing effective database structures in terms of the relational model during creation of information systems, as well as acquiring practical skills in forming SQL-queries for creation of database elements and for data manipulation.

The practical significance and use of the acquired knowledge of the discipline "Organization of Databases and Knowledge" is gaining theoretical knowledge, special and practical  abilities and skills using modern technologies for designing and developing of relational databases, namely:
- obtaining concepts of basic types, structures and models of data used in the basis of information systems;
- mastering the basic operations of relational algebra, their implementation and use in databases;
– acquiring skills of normalizing relations within the relational data model and formalizing the connections between them;
− acquiring  skills of designing effective database structures in terms of the relational model;
- obtaining skills in the principles of creating queries in the SQL language to ensure efficient information processing.

Main learning outcomes
PRN#1. Apply knowledge of the basic forms and laws of abstract and logical thinking, the basics of the methodology of scientific knowledge, the forms and methods of extracting, analyzing, processing and synthesizing information in the subject area of computer science.
PRN#10. Use tools for the development of client-server applications, design conceptual, logical and physical models of databases, develop and optimize queries to them, create distributed databases, data stores and showcases, knowledge bases, including on cloud services, using web languages -programming.

Subjects and types of educational classes
1 week.
Lecture #1 
"Concepts of data and data processing".
Laboratory lesson #1. 
Laboratory work #1 
"Database design. The concept of User Story".
Obtaining a task for the Course work. Analysis and selection of literary sources.
2 week.
Lecture #2 
"Data types and structures".
Laboratory lesson #2. 
Laboratory work #2 
"Database design. The concept of relationships and the construction of a data schema. Part 1".
Performance of the Course work. Part 1.
3 week
Lecture #3 
"Concepts of database systems".
Laboratory lesson #3. 
Laboratory work#2 
"Database design. The concept of relationships and building a data schema. Part 2".
Performance of the Course work. Part 1.
4 week.
Lecture #4 
"Entities and their properties. Connections".
Laboratory lesson #4. 
Laboratory work #3 
"Creating a database. Entering information into the database. Part 1".
Performance of the Course work. Part 1.
5 week.
Lecture #5 
"Data models".
Laboratory lesson #5. 
Laboratory work #3
"Creating a database. Entering information into the database. Part 2".
Performance of the Course work. Part 1.
6 week.
Lecture 6 "Basic operations of relational algebra".
Laboratory lesson #6. 
Laboratory work #4 
"The language of data manipulation: queries, implementation of relational algebra operations. 
Part 1".
Performance of the Course work. Part 1.
7 week.
Lecture #7 
"Objectives of design. Normalization of relations".
Laboratory lesson #7. 
Laboratory work #4 
"The language of data manipulation: queries, implementation of relational algebra operations. 
Part 2".
Performance of the Course work. Part 1.
8 week.
Lecture #8 
"Formalization of connections".
Laboratory lesson #8. 
Laboratory work #4 
"The language of data manipulation: queries, implementations of relational algebra operations. Part 3".
Performance of the Course work. Part 1.
Modular control work #1.
9 week.
Lecture #9 
"SQL data definition language: SQL data types, domains, tables."
Laboratory lesson #9. 
Laboratory work #5 
"Data Manipulation Language: Using the JOIN Operator".
Performance of the Course work. Part 2.
10 week.
Lecture #10 
"The SQL data definition language: conditional statements, keys, indexes, representations."
Laboratory lesson #10. 
Laboratory work #6 
"The language of data manipulation: subqueries. Part 1".
Performance of the Course work. Part 2.
11 week.
Lecture 11 
"Elements of the SQL data manipulation language."
Laboratory lesson #11. 
Laboratory work #6 
"The language of data manipulation: subqueries. Part 2".
Performance of the Course work. Part 2.
12 week.
Lecture #12 
"Subqueries".
Laboratory lesson #12. 
Laboratory work #7 
"Data definition language: creation of triggers and stored procedures. Part 1".
Performance of the Course work. Part 2.
13 week.
Lecture #13 
"Elements of the SQL data definition language based on SQL data manipulation language commands."
Laboratory lesson #13. 
Laboratory work #7 
"Data definition language: creation of triggers and stored procedures. Part 2".
Performance of the Course work. Issuance of an explanatory note.
14 week.
Lecture #14 
"Elements of the SQL data management language."
Laboratory lesson #14. 
Laboratory work #8 
"The language of data management: users, privileges. Part 1".
Defense of the Course work.
15 week.
Lecture #15 
"Basic concepts of knowledge bases, storage and data showcase".
Laboratory lesson #15. 
Laboratory work #8 
"The language of data management: users, privileges. Part 2".
Modular control work #2.
Defense of the Course work.

Individual work of the applicant takes place during the semester and consists of preparation for classroom classes, control measures, individual tasks.
Consultations: are carried out by the teacher during the semester according to the schedule.

Assessment of learning outcomes
The evaluation of the results of studies in the discipline is carried out according to the cumulative system, which allows the student to receive a maximum of 100 points during the semester.
Module #1
Laboratory work #1 – 5 points, laboratory work #2 – 10 points, laboratory work #3 – 5 points, laboratory work #4 – 10 points. Total 30 points.
The Course work. Part 1 - assessment for performance - 30 points.
Modular control work #1 – 20 points (8 week).
Modular control work 1 is performed in the form of computer tests. The number of test questions is 40. Each correct answer is valued at 0.5 points.
Module # 2
Laboratory work #5 – 5 points, laboratory work #6 – 10 points, laboratory work #7 – 10 points, laboratory work #8 – 5 points. Total 30 points.
The Course work. Part. Part 2 – performance assessment – 20 points.
Defense of the Course work - 50 points.
Modular control work #2 – 20 points (15 week).
Modular control work 2 consists of 3 practical problems, which are evaluated in 6, 6 and 8 points, respectively.

Links to recommended sources
1. Введення в сучасні бази даних: навч. посіб. / М.А. Демиденко; НТУ «Дніпровська політехніка». – Д.: 2020. – 38 с.
2. Берко А. Ю., Верес О. М., Пасічник В. В. Системи баз даних та знань. Книга 1. Організація баз даних та знань : підручник; за заг. ред. В. В. Пасічника. – Львів : Магнолія-2006, 2018. – 440 с. 
3. Берко А. Ю., Верес О. М., Пасічник В. В.Системи баз даних та знань. Книга 2. Системи управління базами даних та знань : навч. посіб.; за заг. ред. В. В. Пасічника. – Львів : Магнолія-2006, 2018. – 584 с. 
4. Гайдаржи В.І., Ізварін І.В. Бази даних в інформаційних системах. – К.: Університет “Україна”, 2018. – 418 с.
5. Офіційний сайт СУБД PostgreSQL. – URL: https://www.postgresql.org.