Basics of database design

Course: System Analysis

Structural unit: Faculty of Computer Science and Cybernetics

Title
Basics of database design
Code
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
5
Learning outcomes
Know the basic concepts and definitions of the theory of creation and maintenance of databases (architecture, model, format of data presentation, essence and relationship). Understand the organization of relational and non-relational databases. Know the basic tools of data manipulation and query description languages. Understand the structure and processes of query formation. Be able to apply tools and methods of data actualization in the tasks of accumulation and multidimensional data mining. Be able to use relational and non-relational database models to solve practical problems of decision-making, optimization and processing of information, as well as to create and apply knowledge bases.
Form of study
Full-time form
Prerequisites and co-requisites
Know the basic concepts of mathematical logic, discrete mathematics, basics of programming. Be able to solve typical problems from these courses. Have basic skills: solve problems in discrete mathematics and mathematical logic. To access the discipline "Fundamentals of Database Design" of the educational-professional program "Systems Analysis" the student must master the competencies and learning outcomes provided by the disciplines "Discrete Mathematics", "Mathematical Logic", "Fundamentals of Programming". The discipline "Fundamentals of Database Design" is the basis for mastering the disciplines "Data Analysis"
Course content
Compulsory discipline "Fundamentals of Database Design" is part of the educational and professional training program for the first (bachelor's) level of higher education in the field of knowledge 12 "Information Technology" in specialty 124 - "System Analysis", educational and professional program - "System" analysis". This subject is a compulsory subject in the System Analysis program. It is taught in the 4th semester of the 2nd year in the amount of 150 hours. (5 ECTS credits), in particular: lectures - 40 hours, laboratory - 30 hours, consultations - 2 hours, independent work - 78 hours. The course includes 2 substantive parts and 2 tests. The discipline ends with a test in the 4th semester.
Recommended or required reading and other learning resources/tools
1. Date K. Introduction to database systems, 6th edition: Per. with English - К .; M .; SPb .; Williams Publishing House, 2000. - 848p. 2. Meyer D. Theory of relational databases: Per. с англ.– М .: - Мир, 1987.– 608с. 3. Ozkarakhan E. Database machines and database management: Per. with English - M .: Mir. 1989. - 696 p. 4. Nagao M., Katayama T., Uemura S., Structures and databases: Per. with Japanese. - M .: Mir, 1986.- 197p. 5. Gary Hansen, James Hansen. Databases: development and application: Per. with English - M .: ZAO "Izdatelstvo BINOM", 1999. - 704 p. 6. Eremina NV Database design: Textbook. Manual.- K .: KNEU, 1998. - 208с. 7. Ullman D., Vidom D. Introduction to database systems. - Per. с англ.– М .: - Лори, 2000.– 374с.
Planned learning activities and teaching methods
Lecture, laboratory work, independent work
Assessment methods and criteria
Current assessment, tests
Language of instruction
Ukrainian

Lecturers

This discipline is taught by the following teachers

Departments

The following departments are involved in teaching the above discipline