Infopaket

ОК 14

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

Second

2021/2022

4 Semester

6

The learning outcome is the formation of knowledge about database design. After mastering the discipline, the student should be able to normalize databases, in particular to the first, second, third and fourth normal forms, find functional dependencies in relations, and use them to normalize relations. The student must learn to construct the closure of a set of functional dependencies and a set of attributes, master the decomposition of relations without losses, be able to denormalize relations. As a result of studying the academic discipline, the student should master the design of a logical database model, learn to create a physical data model and carry out its reorganization, create and use indexes; based on the analysis of the task being developed, choose the most rational structure of the database, which ensures the effective implementation of the task.

Full-time form

The discipline is based on knowledge, skills and practical skills acquired by students during the study of the disciplines "Basics of Programming", "Algorithms and Data Structures", "Introduction to Object-Oriented Programming", “SQL”.

The discipline "Database design" consists of two meaningful modules. The first module deals with issues such as what is a database management system, what are databases, database normalization. In the second content module are studied conceptual, logical and physical data models.

1. Mulesa O. Yu. Information systems and relational databases. Training manual. Electronic edition. 2018. 118 p. .— Access mode: https://dspace.uzhnu.edu.ua/jspui/bitstream/lib/19776/1/Мулеса_БД.pdf 2. Bardus I. O. Databases in schemes (based on the fundamental approach): ed. manual Kharkiv: "Disa plus" edition. 2017.133 p. 3. Bui D. B., Silveystruk L. M. Formalization of the "essence-connection" model. Monograph. - K.: VOC "Kyiv University", 2011. - 175 p. 4. Gaina G. A. Fundamentals of database design: Training manual. - K: KNUBA, 2005. - 204 p. 5. Mulesa O.Yu. Basics of the SQL query language. Electronic edition. 2015. 48 p.— Access mode: https://dspace.uzhnu.edu.ua/jspui/bitstream/lib/8868/1/sql.pdf

Lectures, practical activities, individual work

The level of achievement of all planned learning outcomes is determined by the results of the defense of practical work and individual tasks of independent work. Semester assessment of students is carried out during the semester for all types of work. The total score is formed as a weighted sum of points earned by the student for various types of work. The maximum number of points that a student can receive for work in a semester does not exceed 100 points. The final evaluation form is an exam. A student is not admitted to the exam if he scored less than the recommended 36 points during the semester. For students who during the semester did not reach the minimum cut-off grade level, a final semester comprehensive test is conducted, the maximum grade of which cannot exceed 40% of the final grade (up to 40 points on a one-point scale). The condition for receiving a positive final grade for a discipline is to achieve at least 60% of the maximum possible number of points - 60 points.

Ukrainian