Database and Knowledge Base Organization

Major: Computer Science (Design and programming of intelligent systems and devices)
Code of subject: 6.122.12.O.016
Credits: 6.00
Department: Computer-Aided Design
Lecturer: professor of CAD department, Sc.Dr., senior researcher Olena Stankevych
Semester: 3 семестр
Mode of study: денна
Мета вивчення дисципліни: The purpose of the course is the formation of thorough knowledge in the field of database modeling (DB), the language of structured SQL queries, and relational database management systems (RDMS) for solving complex specialized tasks and practical problems in the field of computer science.
Завдання: The study of an educational discipline involves the formation of competencies in students: the ability to solve complex specialized tasks and practical problems in the field of computer science or in the learning process, which involves the application of theories and methods of information technologies and is characterized by the complexity and uncertainty of conditions; ability to abstract thinking, analysis and synthesis; ability to apply knowledge in practical situations; knowledge and understanding of the subject area and understanding of professional activity; ability to work in a team; the ability to be critical and self-critical; the ability to make informed decisions; the ability to evaluate and ensure the quality of performed works; the ability to act on the basis of ethical considerations; the ability to realize one's rights and responsibilities as a member of society, to realize the values of a civil (free democratic) society and the need for its sustainable development, the rule of law, the rights and freedoms of a person and a citizen in Ukraine; the ability to preserve and multiply moral, cultural, scientific values and achievements of society based on an understanding of the history and patterns of development of the subject area, its place in the general system of knowledge about nature and society and in the development of society, technology and technologies, to use various types and forms of motor activity for active recreation and leading a healthy lifestyle; the ability to design and develop software using various programming paradigms: generalized, object-oriented, functional, logical, with appropriate models, calculation methods and algorithms, data structures and control mechanisms.
Learning outcomes: As a result of studying the academic discipline, the student must be able to demonstrate the following program learning outcomes: 1. To use the modern mathematical apparatus of continuous and discrete analysis, linear algebra, and analytical geometry, in professional activities to solve theoretical and applied problems in the design and implementation of information objects. 2. Understand the principles of modeling organizational and technical systems and operations; use methods of operations research, solving one- and multicriteria optimization problems of linear, integer, nonlinear, and stochastic programming. 3. Use the methodology of system analysis of objects, processes, and systems for the analysis, forecasting, management, and design of dynamic processes in macroeconomic, technical, technological, and financial objects. 4. Ability to develop analytical data warehouses with the help of appropriate software, using survey results, queries, and features of the chosen method of presenting knowledge.
Required prior and related subjects: Algorithmization and programming, Part 1; Algorithmization and programming, Part 2; Object-orienting programming; Applied programming.
Summary of the subject: The main issues of database modeling (DB), structured SQL query language, relational database management systems (DBMS) are considered.
Опис: The curriculum contains 9 modules: data models and DBMS types, relational data model, database normalization, database ER diagrams, structured SQL query language, memory structures and index structures, transaction management, object-relational mapping technology, BusinessIntelligence in the database.
Assessment methods and criteria: Current control: Laboratory work - analysis of the report in accordance with the established requirements, written survey. Calculation-graphic work - analysis for compliance with the task, independence of execution, design in accordance with established requirements. Semester control: Testing in the VNS, oral examination.
Критерії оцінювання результатів навчання: Current control (45%): written reports on practical and laboratory work, report on the performance of calculation and graphic work, oral survey. Final control (55%, examination control): testing (45%), oral component (10%).
Recommended books: 1.Coronel C., Morris S. Database Systems: Design, Implementation, and Management. 12th ed. – Cengage Learning, 2017. – 818 p. 2.Connolly T.M., Begg C.E. Database Systems: A Practical Approach to Design, Implementation and Management: Global Edition. – 6th Edition. – Pearson Education, 2015. – 1440 p. 3.Kroenke D.M., Auer D.J. Database Processing: Fundamentals, Design, and Implementation. 14th ed. – Pearson Education Ltd., 2016. – 638 p. 4.Elmasri R., Navathe S.B. Fundamentals of Database Systems. 7th ed. – Addison Wesley, 2016. – 1272 p. 5.Берко А. Ю., Верес О. М., Пасічник В. В. Системи баз даних та знань. Книга 2. Системи управління базами даних та знань : навч. посіб. Львів :"Магнолія-2006", 2012. 584 с. 6.Гайна Г. А. Основи проектування баз даних : навч. посіб. К. : Кондор,2008. 200 с.