Home/ Majors directory/Telecommunications and Radio Engineering/Databases in Infocommunication Systems
Databases in Infocommunication Systems
Major: Telecommunications and Radio Engineering
Code of subject: 6.172.06.E.123
Credits: 4.00
Department: Electronics and Information Technology
Lecturer: Hlinenko Larysa
Semester: 6 семестр
Mode of study: денна
Завдання: The study of the discipline provides for the development of student competencies:
general competences:
- GC1. Ability for abstract thinking, analysis and synthesis;
- GC2. Ability to apply knowledge in practical situations;
- GC7. Ability to learn and master modern knowledge;
- GC8. Ability to identify, formulate and solve problems;
- GCI4. Ability to search and analyse information from various sources;
- GCI5. Ability to think systematically.
professional competences:
- PC1. Ability to understand the nature and importance of information in the development of modern information society;
- PC5.3. Ability to organize and maintain data management in information systems; ability to analyze the subject area, to develop a relational database for it; to select appropriate software and hardware; to implement a database therein; to provide access to and to manage data through SQL queries, to administer the database
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
As a result of studying the course, the student must be able to demonstrate the following programme learning outcomes:
PLO 1. GC2. Skills of evaluation, interpretation and synthesis of information and data
PLO 1. GC11. Ability to demonstrate knowledge and understanding of design methodology, relevant regulations, current standards and specifications
PLO 2. SC 1. Analyze, justify, make decisions in solving specialized problems and practical problems of telecommunications and radio engineering, which are characterized by complexity and incomplete determination of conditions
PLO 2. SC 2. Apply the results of personal search and analysis of information to solve problems of a similar nature in information and computer networks, telecommunications and radio networks
PLO 3. SC 13. To apply knowledge and understanding to solve problems of synthesis and analysis in information and communication systems that are characteristic of the chosen specialization
PLO 4. SC 14. To think systematically and apply creative abilities to the formation of fundamentally new ideas
PLO 5. AiB2. Ability to recognise the need for lifelong learning in order to deepen acquired knowledge and to gain new professional knowledge
Required prior and related subjects: - Programming (by professional activity), part 1, 2
- Object-oriented programming
- Infocommunication networks
- Modelling of information and communication systems
- Fundamentals of information technology and electronic engineering
Summary of the subject: The course covers the basics of the database concept; stages and approaches to database design, DBMS architecture and functions. The course provides for the study of modern approaches to data modelling and database organization, and examines in detail the main stages and tools for designing relational databases, tools for building an infological and logical database model. The basics of the SQL database language and transaction management methods are studied; the knowledge gained will be implemented in the process of performing practical activities involving using the CASE tools and modern DBMS environment.
Опис: 1. Evolution of data storage systems in computers. Fundamentals of the database concept. Database management systems (DBMS). Architecture and functions of DBMS. Classification of database management systems.
2. Data modelling in the process of creating the database. Classical (hierarchical, network, relational) and modern (multidimensional, object-oriented, object-relational, document-oriented) data models
3. Fundamentals of database design. The main stages of design. Database design as an iterative process of creating database models. Basic approaches to database design.
4. Modelling databases at the conceptual level of representation. Infological model "entity-relationship". Data representation using this model. Modelling using the entity-relationship model (ER diagram). Types of entities, sets of entities, attributes, keys. Relationships, types of relationships, sets of relationships, roles and characteristics of relationships. ER-diagram notations.
5. Fundamentals of the relational approach to database organisation. Basic concepts of relational data modelling. Basic (fundamental) properties of relationships in relational databases. The main characteristics and advantages of the relational data model.
6. Basic tools for manipulating relational data. Fundamentals of relational algebra and relational calculus. Operations of relational algebra, their interpretation.
7. Designing relational databases. Basics of database normalisation. Quality criteria for logical database models. Functional dependencies. The concept of normal database form and normalisation. The 1st, 2nd and 3rd normal forms, the algorithm for converting the database model to them. Correctness of the normalisation procedure.
8. Normal forms of higher orders: BCNF - Boyce-Codd normal form, 4th and 5th normal forms. Multivalued dependence and PJ dependence. Algorithm for decomposing relationships when designing a relational database schema
9. The basics of SQL. Definition of database objects and data types in SQL. Specification of constraints in SQL. Views (virtual tables) in SQL.
10. SQL queries for data selection: simple and cross queries, queries with calculations. Non-trivial queries. Formation of nested queries and their application SQL queries for data modification: inserting, deleting and updating data. Adding constraints. Changing and updating tables.
11. Basics of transaction management. Requirements for transaction properties. Serialised transaction schedules. Methods of conflict management. The method of two-phase locking as a method of conflict management. Methods of database recovery.
12. Databases and the Internet. Internet access to databases and publishing databases on the Internet.
Assessment methods and criteria: Oral and written surveys in the process of performing and defending laboratory works and individual assignments, control and current testing in the VNS, examination testing, execution of control tasks, oral survey during the exam.
Критерії оцінювання результатів навчання: Current control (PC)
- Defence of laboratory work - 14 points
- Individual assignments - 12 points
- Control tests - 14 points
- Total for PC - 40 points
Examination control
- Written component - 54 points
- Oral component - points
Total for the course -100 points
Grades for laboratory works are assigned on the basis of determining the correctness, completeness and independence of the solutions obtained for each task:
- the results obtained are correct, complete and obtained independently - 100% of the maximum score;
- the results are correct, complete and obtained with significant assistance and correction from the teacher - 90% of the maximum score;
- the solutions obtained in the work are correct, but incomplete and obtained with significant help and correction from the teacher - 75% of the maximum score;
- the results obtained contain errors, but the approach to obtaining a solution and the use of tools for obtaining the solution are correct - 50% of the maximum mark.
Current and control testing is conducted in the Virtual Learning Environment and the grade is assigned automatically for all test tasks. For essay type tasks, 100% of the maximum score is assigned in the manual assessment mode for a totally correct and complete solution, 85% for a generally correct solution with minor errors in calculations; 75% for an incomplete solution with some errors with a generally correct approach to the solution; 50% for significant errors and an incomplete solution with a correct approach; 30% for formulating a correct approach without implementing the solution.
The exam is conducted in written and oral form (the test is assessed out of 54 points, the oral component - out of 6 points)
Порядок та критерії виставляння балів та оцінок: .
100-88 points - ("excellent") is assigned for a high level of knowledge (some inaccuracies are allowed) of the educational material of the component contained in the main and additional recommended literature sources, the ability to analyse the phenomena studied in their interconnection and development, clearly, concisely, logically, consistently answer the questions posed, the ability to apply theoretical provisions in solving practical problems; 87-71 points - ("good") is given for a generally correct understanding of the educational material of the component, including calculations, reasoned answers to the questions posed, which, however, contain certain (insignificant) shortcomings, for the ability to apply theoretical provisions in solving practical problems; 70 - 50 points - ("satisfactory") is assigned for poor knowledge of the educational material of the component, inaccurate or poorly reasoned answers, with a violation of the sequence of presentation, for poor application of theoretical provisions in solving practical problems; 49-26 points - ("not certified" with the possibility of retaking the semester control) is assigned for ignorance of a significant part of the educational material of the component, significant errors in answering questions, inability to apply theoretical provisions in solving practical problems; 25-00 points - ("unsatisfactory" with mandatory re-study) is assigned for ignorance of a significant part of the component's educational material, significant errors in answering questions, inability to navigate when solving practical problems, ignorance of the main fundamental provisions.
Recommended books: 1. Організація баз даних : навч. посібник / О. Г. Трофименко, Ю. В. Прокоп, Н. І. Логінова, І. М. Копитчук. 2-ге вид. виправ. і доповн. – Одеса : Фенікс, 2019. – 246 с.
2. Берко А.Ю., Верес О.М., Пасічник В.В. Системи баз даних та знань. Книга 1. Організація баз даних та знань: навч. посібник. - Львів: «Магнолія 2006», 2021. – 440 с
3. Павлиш В.А., Гліненко Л.К. Основи інформаційних технологій і систем: навч. посібник / В.А.Павлиш, Л.К. Гліненко. - Львів: Видавництво львівської політехніки, 2013. - 500 с.
4. Берко А.Ю., Верес О.М., Пасічник В.В. Системи баз даних та знань. Книга 2. Системи управління базами даних та знань: навч. посібник. – Львів : «Магнолія-2006», 2021. – 584 с.
5. Coronel C., Morris S. Database Systems: Design, Implementation, And Management. 10th ed., 13th ed. - Cengage Learning;, 2019. – 816 p.
6. Kroenke D. M., Auer D. J. Database Processing: Fundamentals, Design, and Implementation (13th Edition). – Pearson, 2013.- 640 p.
7. Бази даних в інформаційних системах: підручник / Гайдаржи В. І., Ізварін І. В. ; Нац. техн. ун-т України "Київ. політехн. ін-т ім. Ігоря Сікорського", Відкритий міжнар. ун-т розвитку людини "Україна". - Київ : Ун-т "Україна", 2018. - 417 с
Уніфікований додаток: The National University "Lviv Polytechnic" ensures the implementation of the right of persons with disabilities for high school education. Inclusive educational services are provided by the University Accessibility Service "Without Limitations", the aim of which is to provide permanent and individualized support to the educational process of students with disability or chronic illness. An important tool in the implementation of inclusive education policy at the University is the Programme for Upgrading the Qualification of Scientific and Educational Staff and Supplementary Educational Personnel in the Field of Social Inclusion and Inclusive Education. Apply at the address:
Karpinskiogo St., 2/4, II st.b., room. 112
E-mail: nolimits@lpnu.ua
Websites: https://lpnu.ua/nolimits https://lpnu.ua/integration
Академічна доброчесність: Policies on academic virtues of the participants of the educational process is formed on the basis of adherence to the principles of academic integrity, taking into account the "Regulations on academic virtues in the National University "Lviv Polytechnic" (approved by the Academic Council of the University on 20.06.2017, protocol № 35).