Infopaket

Fundamentals of databases

ОК 28

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

First

2023/2024

7 Semester

7

To be able to apply knowledge in the field of informatics and modern information technologies, computer and microprocessor technology and programming, software tools for solving specialized tasks and practical tasks in the field of professional activity. To be able to apply modern achievements in the field of professional activity in order to build promising telecommunication systems, communication, telecommunication networks, radio technical systems and television and radio broadcasting systems, etc. To be able to demonstrate knowledge and understanding of the main facts, concepts, rules and theories related to professional activities aimed at creating conditions for the exchange of information at a distance, its processing and storage, including technological systems and technical means that ensure reliable and high-quality transmission, reception, processing and storage of various signs, signals, text, images, sounds by optical, electrical, radio and other systems.

Full-time form

Knowledge of the basics of the SQL language, the DDL language, the DML language, the complexity theory of algorithms, the principles of designing and implementing algorithms, the theoretical basics of statistics, the basic principles of software development on client-server technology, the basics of website development. To have basic skills in designing relational databases, writing queries in SQL, DDL and DML languages, designing algorithms to solve applied problems, developing web pages and application to interact with the database, working with Windows and Unix operating systems.

This subject involves studying a specialized programming language of database management system for developing additional database functionality, as well as studying the basics of query optimization in databases. The subject integrates previously acquired theoretical knowledge and practical skills in the field of databases, forming a holistic view of the process of designing, implementing, maintaining database, and analyzing database performance. Studying this subject allows you to comprehensively understand the technological processes of data processing in relational databases, learn how to optimize queries and automate some data processing processes in database. The subject mainly is focused on learning and acquiring practical skills in using a specialized programming language of the database management system to create additional database functionality as stored functions, procedures, triggers on the example of the PL/SQL programming language of the Oracle DBMS.

1. Date C.J. Database Design and Relational Theory: Normal Forms and All That Jazz. – Apress; 2nd ed. Edition, 2019. – 451 p. 2. Groff J.R., Weinberg P.N., Oppel A. SQL The Complete Reference. – McGraw Hill Professional; 3rd Edition, 2008. – 912 p. 3. Berko A.Yu. Database and knowledge systems. Book 2 / Berko A.Yu., Veres O.M., Pasichnyk V.V. 2019. - 584 c. 4. Mulesa O.Yu. Information systems and relational databases. Study guide. – Electronic edition, 2018. – 118 p. 5. Tarasov O.V. Oracle database client-server technologies. SQL Oracle language: educational and practical guide for independent work of students on subject "Organization of Databases and Knowledge" for students of the direction 6.050101 "Computer Sciences" / O. V. Tarasov, V. V. Fedko. – Kh.: Simon Kuznets Kharkiv National University of Economics, 2015. – 384 p. (Ukrainian lang). 6. Trofymenko O.G., Bukata L.M., Prokop Yu.V. Databases: creation and processing. – Odessa: Phoenix, 2016.– 226 p.

Lectures, laboratory work, practical activities, independent work

The subject integrates various types of work, including independent work. The student has to assert laboratory and practical work by completing an individual task during class and demonstrating the result to the teacher. For some topics, the assertion in teamwork is provided. The grade for the work depends on the correctness of the individual task.During the semester, after completing the study of the relevant topics (content parts), a control test or a written task is conducted. During the semester, each student also completes an individual project related to the design and development of a database for their chosen subject area, which have to include triggers and client interface development. The project evaluates by the commission, the points for it are included in the total amount of points for the semester. During the semester, the student can score a maximum of 60 points, the remaining 40 points can be obtained in the exam.

Ukrainian