Database Organization and Information Systems

Course: Software Technology Internet of Things

Structural unit: Faculty of information Technology

Title
Database Organization and Information Systems
Code
ДВС.5.04.02
Module type
Вибіркова дисципліна для ОП
Educational cycle
First
Year of study when the component is delivered
2023/2024
Semester/trimester when the component is delivered
6 Semester
Number of ECTS credits allocated
4
Learning outcomes
– Know the stages of designing information systems. – Know the methods of designing information systems. – To know the methods of visual representation of the work of nodes of the information system. – Know software tools for designing and software implementation of databases. – Be able to programmatically implement a database. – Be able to programmatically implement the interface of the information system. – The ability to work in a team, the development of students' practical skills of group work with the use of appropriate methods and techniques for obtaining, storing and processing data and their presentation with modern technical capabilities.
Form of study
Full-time form
Prerequisites and co-requisites
1) successful mastery of the disciplines "Distributed information collection systems", "Algorithms and data structures", "Programming technologies", "Object-oriented programming", "Basics of information security". 2) knowledge of the theoretical foundations of programming languages in order to use them for the possibility of performing laboratory work. 3) possession of elementary skills of the basics of algorithmization and programming.
Course content
The course examines the theoretical basis of the stages of creating an information system: pre-design specification of tasks for the information system, creation of IDFO, DFD models for understanding the relationships between activities in the subject area and creation of a logical database, designing UML diagrams of the nodes of the future information system. The laboratory classes are devoted to the practical implementation of an information system containing an extensive database and a clear external interface. The result of the course is the acquisition of theoretical knowledge of the methodology of creating information systems and the acquisition of practical skills in their implementation. The main task of studying the discipline is to acquire the necessary knowledge and practical skills of using existing tools for the design and practical implementation of information systems. Applicants must master the stages of designing information systems, creating models and diagrams in accordance with the system being developed, and master the software tools for software implementation of databases and the interface of the information system. In the process of education, students learn to conduct a systematic analysis of design objects and justify the choice of structure, algorithms and methods of information circulation in information systems and technologies. And also, justify the choice of software and technical means for creating ICT based on the analysis of their properties, purpose and technical characteristics, taking into account system requirements and operating conditions. The discipline ends with a project presentation on an individually chosen topic.
Recommended or required reading and other learning resources/tools
– Boehm B. A Spiral Model of Software Development and Enhancement - ACM SIGSOFT Software Engineering Notes, ACM, 11(4):14-24, August 1986 // [Електронний ресурс] - Режим доступу: http://weblog.erenkrantz.com/~jerenk/phase-ii/Boe88.pdf – Guide to the Software Engineering Body of Knowledge (SWEBOK) - A project of the IEEE Computer Society Professional Practices Committee, 2004 // [Електронний ресурс] – Режим доступу: http://ocw.unican.es/ensenanzas-tecnicas/ingenieria-del-software-i/otros-recursos-1/SWEBOK_Guide_2004.pdf IEEE Standard 1517-99. IEEE Standard for Information Technology – Software Lifecycle Process – Reuse Processes
Planned learning activities and teaching methods
Lectures, laboratory activities, individual work.
Assessment methods and criteria
The grade for the semester is formed through the successful completion and mandatory defense of laboratory and practical work and the presentation of a project on an individually chosen topic. As well as abstract presentations at practical classes and answers to blitz quizzes at lecture classes. A student receives 1 point for 1 addition or answer to a question during a blitz quiz. There can be 3 such answers. An abstract report in a practical lesson can be evaluated from 5 to 7 points. 7 practical works, which are evaluated from 3 to 5 points. Only 3 laboratory works from 5 to 8 points each. Before performing practical and laboratory work, the applicant chooses an individual topic of the subject area of research. From the texts of practical and laboratory works, according to a pre-prepared plan, the applicant forms an explanatory note to the project of an individual work, which corresponds to the main points of the bachelor's work.
Language of instruction
Ukrainian

Lecturers

This discipline is taught by the following teachers

Departments

The following departments are involved in teaching the above discipline