Data Bases

Major: Computer Engineering
Code of subject: 6.123.00.O.130
Credits: 5.00
Department: Specialized Computer Systems
Lecturer: Kolodchak Olha M.
Semester: 4 семестр
Mode of study: денна
Learning outcomes: The goal is to provide students with basic theoretical knowledge on the organization of databases in lecture classes and consolidate this knowledge in laboratory classes, by implementing a project to create an information system with an appropriate database in a team with classmates. As a result of studying the academic discipline, the student should be able to demonstrate the following results: 1. to study the methodological approaches and stages of creating information systems to study, 2. basics of the theory of relational databases, 3. learn the SQL data manipulation language, 4. to study the technology of creating software products based on modern DBMS, the basics of DBMS programming languages, 5. study the stages of creating information systems, 6. create information systems based on the Microsoft SQL Server DBMS.
Required prior and related subjects: Previous academic disciplines: -Discrete Math -Programming - Object-oriented programming Associated and following academic disciplines: - System programming -Web programming - Database management systems
Summary of the subject: 1. Basics of database organization. • Information systems and information technologies. • Architectures of information systems. • Information and data. • Database architecture. • Information processing methods. • Database systems, levels of abstraction in DBMS, differences in database perception, real world model. • Database architecture. • Data models. • Classification of databases. • Subject area of databases. • Domain models of databases. • Relational data model. • Formalization of relations. • Relational algebra operations and their properties. • Relational computing. 2. Fundamentals of designing relational databases. • Data dependencies in the relational model. • Functional dependencies, axioms and rules for deriving functional dependencies. • Decompositions with lossless connection property. • Running algorithm. • Decompositions preserving functional dependencies. • Normal forms (first, second, third, Boyce-Codd) of the database and their normalization algorithms. • Multivalued dependencies and axioms of their derivation. • Peculiarities of presenting incomplete information in the relational database. • Designing relational databases. 3. SQL query language. 1. Working with tables: • CREATE TABLE • DROP TABLE • Creation of primary and foreign keys 2. Requests for obtaining information from the database: • SELECT .. FROM .. WHERE, • INNER JOIN, LEFT JOIN, RIGHT JOIN, • GROUP BY, HAVING, • aggregation functions MIN, MAX, SUM, COUNT, • predicates EXIST, ANY, ALL 3. Data modification requests: • INSERT INTO • UPDATE • DELETE FROM 4. Team work on the project and its protection
Assessment methods and criteria: Assessment of students' knowledge in the discipline "Organization of databases" is carried out in accordance with the work curriculum in the form of a semester control, which is conducted at the end of the semester and includes the results of the current control of students' knowledge, which is evaluated for the performance of laboratory work, and a control measure - the answer to the corresponding exam ticket. The control measure is a mandatory type of control and is conducted in written and oral form at the end of the semester. Current monitoring of lecture classes is carried out in order to identify the student's readiness for classes in the following forms: - a selective oral survey before the start of classes; - assessment of the student's activity in the course of classes, submitted proposals, original solutions, clarifications and definitions, additions to previous answers, etc. Control questions are divided into: a) test tasks - choose the correct answers; b) problematic – creation of problematic situations; c) questions-replies - to identify cause-and-effect relationships; d) situational tasks - to determine the answer according to a certain situation; e) issues of a reproductive nature - determination of practical significance. Criteria for assigning points and grades: 1. Distribution of points subject to the completion of the study plan, completion of all control works and the calendar plan for the performance of laboratory works, otherwise, according to the results of the semester control, the student is considered not certified. 2. The maximum number of points for the assessment of current control (PC) of knowledge per semester is 30 points. 3. Examination control is conducted in written and oral form. 4. The maximum number of points for evaluating the examination control is 70 points. 5. The student also completes the exam before the commission in written and oral form, with the questions and answer scores recorded on the exam sheet. 6. Students are admitted to the exam provided they complete the curriculum (including all laboratory work).
Recommended books: Basic 1. James R. Groff, Paul M. Winebury. SQL: The Complete Guide. - 2008. 2. Digo S.M. Design and use of databases. - 2005. 3. Pasichnyk V.V. Organization of databases and knowledge: a textbook for universities / V.V. Pasichnik, V.A. Reznichenko.-K.: BHV Publishing Group, 2006.-384p. Auxiliary 1. Lukyanova V.V. Computer data analysis: Handbook. - K.: Academy, 2008. - 344p. 2. A.H. Haumov, A.M. Vendrov, etc., "Database and Knowledge Management Systems", Moscow: Finance and Statistics, 1991. Information resources 1. Complete Guide (v1). Query builder. - https://yiiframework.com.ua/uk/doc/guide/database.query-builder/ 2. Working with requests. https://www.databasetour.net/ua/documentation/working-with-sql-queries.htm

Data Bases

Major: Computer Engineering
Code of subject: 6.123.00.O.129
Credits: 5.00
Department: Electronic Computing Machines
Lecturer: associate professor Iryna Pasternak
Semester: 4 семестр
Mode of study: денна
Learning outcomes: Students should know: - types of relationships for building databases - the difference between relational and non relational databases - transactions isolation levels - different types of backups - how to improve database performance
Required prior and related subjects: Programming;
Summary of the subject: Database types; SQL; Window functions; Indexes; Stored procedures;Functions; Transactions;
Assessment methods and criteria: Written reports on laboratory work, the verbal questioning (30%) Final assessment (control method, exam): written-verbal form (70%)
Recommended books: 1. William R. Stanek Microsoft SQL Server 2008, Second Edition; McGraw-Hill Education; 2 edition ; 2010.- 715 2. Bihag Thaker, Ritesh Shah Microsoft SQL Server 2012 Performance Tuning Cookbook; Packt Publishing 2012.-412 3. Itzik Ben-Gan, Dejan Sarka 70-461 - MS Training Kit 70-46; Microsoft Press 2012 -750 4. Dejan Sarka, Matija Lah, Grega Jerkic Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012; O’Reilly Media, Inc; 2012 -769