Databases in Infocommunication Systems

Major: Telecommunications and Radio Engineering
Code of subject: 6.172.06.E.148
Credits: 4.00
Department: Electronics and Information Technology
Lecturer: Hlinenko Larysa
Semester: 6 семестр
Mode of study: денна
Learning outcomes: By the end of the study, learners are expected to: – comprehend the fundamentals of database approach, database design and the use of database management systems for applications in information and telecommunication systems; – know the fundamentals of relational database organization and means of manipulating the relational data; – demonstrate knowledge and skills of relational database schema design by employing the concepts of normal forms, normalizing procedures and entity-relationship diagrams; – declare, define, and access relational database schemas in relational database management systems using the data definition language subset of SQL and facilities of QBE; – demonstrate knowledge and skills of querying relational databases by using SQL and the ability to convert relational algebra queries to SQL; – be able to apply the acquired knowledge for the relational database development in DBMS Access and to support query and constraint realization with QBE and SQL; – demonstrate knowledge of recent advances in database systems by identifying the connection between traditional relational databases and other data models; – be able to present results of DB design and to substantiate it while discussing them with other students
Required prior and related subjects: – Informatics of the information and communication systems – Modelling of Infocommunication Systems – Infocommunication Networks
Summary of the subject: Characteristics of the database (DB) approach. Advantages of using the DB approach. Data and structure independence. Database system concepts and architecture. Database management systems (DBMS). DBMS architecture and functions. Data models and schemas. Traditional and advanced data models. Database languages and interfaces. Centralized and client/server architectures for DBMSs. Classification of database management systems. The relational data model and relational database constraints. The relational algebra and relational calculus. Relational algebra operations from set theory. Unary relational operations: SELECT and PROJECT. Binary relational operations: JOIN and DIV ISION. Conceptual modelling and database design. Data modelling using the Entity-Relationship (ER) model. Entity types, entity sets, attributes, and keys. Relationship types, Relationship sets, roles and characteristics. Notations of ER model. Database design theory and normalization. Basics of functional dependencies and normalization for relational databases. Normal forms. Relational decompositions algorithms for relational database schema design. Basic SQL. SQL Data Definition and data types. Specifying constraints in SQL. Views (virtual tables) in SQL Basic retrieval queries in SQL. INSERT, DELETE, and UPDATE statements in SQL. Introduction to transaction processing. Desirable properties of transactions. Characterizing schedules based on serializability. Concurrency control techniques. Two-Phase locking techniques for concurrency control. Database recovery techniques. New DB technologies. Data warehouses. Knowledge bases. Databases and WEB. WEB access to DB and DB WEB publication.
Assessment methods and criteria: – Current control: laboratory reports, oral interviewing, written tests – 40 points (40 %): laboratory works execution and defence - 10 points; tests - 30 points – Final control: control procedure - written and verbal examination (60 %): written examination (test) - 54 points; oral interviewing (verbal examination) - 6 points
Recommended books: 1. Берко А.Ю., Верес О.М., Пасічник В.В. Системи баз даних та знань. Книга 1. Організація баз даних та знань: навч. посібник. _ Львів: «Магнолія 2006»б 2008. – 456 с 2. Конноли Т., Бегг К., Страчан А. Базы данных: проектирование, реализация и сопровождение. Теория и практика. – М.: Изд. Дом “Вильямс”. 2000. – 1120 с. 3. Роб П., Коронел К. Системы баз данных: проектирование, реализация и управление. 5-е изд. – СПб.: БХВ-Петербург. – 2004. – 1040 с. 4. Elmasri R. Fundamentals of database systems / Ramez Elmasri, Shamkant B. Navathe.—6th ed. p. cm. – N.Y.-Addison-Wesley, Pearson, 2010. - 1200 pages. ISBN-13: 978-0-136-08620-8. 5. Павлиш В.А., Гліненко Л.К. Основи інформаційних технологій і систем: навч. посібник / В.А.Павлиш, Л.К. Гліненко. - Львів: Видавництво львівської політехніки, 2013. - 500 с. 6. Пирогов В. Ю. Информационные системы и базы данных: организация и проектирование: учеб. Пособие / В. Ю. Пирогов. — СПб.: БХВ-Петербург, 2009. — 528 с. 7. Берг М. Применение объектно-ориентированных систем управления базами данных в телекоммуникационной отрасли / Макс Берг. - http://citforum.ru/products/versant/T_communications 8. Божко К.А. Современные базы данных и их экономическая целесообразность в телекоммуникационных сетях / К.А.Божко. - http://cyberleninka.ru/article/n/sovremennye-bazy-dannyh-i-ih-ekonomicheskaya-tselesoobraznost-v-telekommunikatsionnyh-setyah