Home/ Majors directory/Telecommunications and Radio Engineering/Information Systems Databases
Information Systems Databases
Major: Telecommunications and Radio Engineering
Code of subject: 6.172.05.E.111
Credits: 4.00
Department: Electronics and Information Technology
Lecturer: Hlinenko Larysa
Semester: 7 семестр
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 infocommunication 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 entity-relationship diagrams, normal forms and normalizing procedures;
– 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 discipline, 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: • Fundamentals of information technology and electronic engineering
• Programming (by professional orientation), part 1 and part 2
• Modelling of electronic devices
• Design of radioelectronic apparatus
• Databases in information and computer systems (CW)
• Fundamentals of information technologies and systems
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. Introduction. Data, information and their saving in computers. Subject, purpose and objectives of the course. File systems and their disadvantages in terms of information storage in information and communication systems.
2. Fundamentals of the database concept. Database management systems (DBMS). Architecture and functions of DBMS. Classification of database management systems.
3. Data modelling in the process of creating databases. Classical (hierarchical, network, relational) and modern (multidimensional, object-oriented, object-relational, document-oriented, graphical) data models
4. Fundamentals of database design. The main stages of design. Database design as an iterative process of creating database models. Basic approaches to database design.
5. 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 notation.
6. Fundamentals of the relational approach to database organization. Basic concepts of relational data modelling. Basic (fundamental) properties of relationships in relational databases. The main characteristics and advantages of the relational data model.
7. Basic tools for manipulating relational data. Fundamentals of relational algebra and relational calculus. Operations of relational algebra, their interpretation.
8. Designing relational databases: basics of database normalisation and normal forms. 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 bringing the database model to them. Correctness of the normalisation procedure. Hez's theorem.
9. Designing relational databases: higher order normal forms: BCNF - Boyce-Codd normal form, 4th and 5th normal forms. Algorithm for decomposing relationships in the design of a relational database schema.
10. Fundamentals of SQL. Definition of database objects and data types in SQL. Specification of constraints in SQL. Views (virtual tables) in SQL.
11. Basic SQL queries for data selection: simple and cross queries, queries with calculations. Non-trivial queries. Formation of nested queries and their application.
12. SQL queries for data modification: inserting, deleting and updating data. Adding constraints. Changing and updating tables.
13. 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.
14. New database technologies. Data warehouses. 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 VLE, examination testing, execution of control tasks, oral survey during the exam.
Критерії оцінювання результатів навчання: Current control (PC)
- Defence of laboratory work - 14 points
- Individual assignments - 8 points
- Control tests - 18 points
- Total for PC - 40 points
Examination control
- Written component - 54 points
- Oral component - points
Total for the course -100 points
Grades for laboratory work 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.
Порядок та критерії виставляння балів та оцінок: 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. Берко А.Ю., Верес О.М., Пасічник В.В. Системи баз даних та знань. Книга 1. Організація баз даних та знань: навч. посібник. - Львів: «Магнолія 2006», 2021. – 440 с
2. Павлиш В.А., Гліненко Л.К. Основи інформаційних технологій і систем: навч. посібник / В.А.Павлиш, Л.К. Гліненко. - Львів: Видавництво львівської політехніки, 2013. - 500 с.
3. Берко А.Ю., Верес О.М., Пасічник В.В. Системи баз даних та знань. Книга 2. Системи управління базами даних та знань: навч. посібник. – Львів : «Магнолія-2006», 2021. – 584 с.
4. Бази даних в інформаційних системах: підручник / Гайдаржи В. І., Ізварін І. В. ; Нац. техн. ун-т України "Київ. політехн. ін-т ім. Ігоря Сікорського", Відкритий міжнар. ун-т розвитку людини "Україна". - Київ : Ун-т "Україна", 2018. - 417 с.
5. 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.
6. Coronel C., Morris S. Database Systems: Design, Implementation, And Management. 10th ed., 13th ed. - Cengage Learning;, 2019. – 816 p.
Уніфікований додаток: 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).
Information Systems Databases (курсова робота)
Major: Telecommunications and Radio Engineering
Code of subject: 6.172.05.E.115
Credits: 2.00
Department: Electronics and Information Technology
Lecturer: Hlinenko Larysa
Semester: 7 семестр
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: As a result of studying the discipline (completing course work), the student must be able to demonstrate the following learning outcomes:
- knowledge of the basics of organising relational databases and tools for manipulating relational data;
- the ability to design a relational database schema based on the construction of ER diagrams, the involvement of the theory of normal forms and normalisation procedures, to understand the features of the design and application of databases in information and communication systems;
- ability to define and access the schema of relational databases in the environment of relational database management systems, using a subset of the SQL data description language and QBE tools;
- ability to build queries to a relational database using SQL and be able to convert relational algebra queries into SQL queries;
- the ability to apply the acquired knowledge to develop a relational database in Access, to ensure the implementation of queries and constraints using QBE and SQL;
- ability to present the results of database design and justify them in a discussion with other students
As a result of studying the discipline, 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: • - Fundamentals of information technology and electronic engineering
• - Programming (by professional orientation), part 1 and part 2
• - Modelling of radioelectronic aparatus
• - Design of radioelectronic apparatus
• - Databases in information and computer systems (CW)
• - Fundamentals of information technologies and systems
Summary of the subject: The course work is aimed at forming and developing the skills and abilities of designing relational databases, including: creating a user model based on the analysis of the subject area; creating an infological and logical database models; applying CASE-technologies for building an infological and logical database model; forming a database schema in the selected DBMS and creating database management tools (queries, reports, forms) using the SQL database language. The explanatory note to the course work should contain textual and illustrative material. The result of the work is a fully functioning database with test data. The project is to be completed in one semester (16 weeks). The standard time allocated to the student to do the job is 60 hours.
Опис: 1. Introductory lecture. Acquaintance with the assignment, methodology of the course project ( course work) and clarification of the assignment variant
2. Analysis of the subject area according to the assignment and formation of a user model. Identifying entities, attributes, keys and relationships.
3. Building an infological model
4. Building a logical model in Microsoft Visio. Normalisation of relations
5. Implementation of the database schema in the environment of the selected DBMS and test loading of the database
6. Developing queries using QBE and SQL tools
7. Development of forms and reports, other database management tools. Formulation of conclusions
8. Defence of the course work
Assessment methods and criteria: Current control in the form of checking by the teacher the parts of the course project (course work) according to the description of the stages of the course project (course work). Final control in the form of defence of the course project ( course work).
Критерії оцінювання результатів навчання: Current control (PC) - 70 points
Completion of individual sections of the course work - 40 points
Checking the text and graphic part of the term paper - 30 points
Defence of the term paper - 30 points
Total for the discipline - 100 points
Grades for the course work are assigned based on the correctness, completeness and independence of the solutions obtained for each of the tasks:
- the results are correct, complete and obtained independently - 100% of the maximum mark;
- the results are correct, complete and obtained with significant assistance and correction from the teacher - 90% of the maximum mark;
- the solutions obtained in the work are correct, but incomplete and obtained with significant help and correction from the teacher - 75% of the maximum mark;
- the results obtained contain errors, but the approach to obtaining a solution and the use of tools for obtaining a solution are correct - 50% of the maximum mark.
The grade for defending a term paper is based on a preliminary assessment of the work, text and graphical part, with consideration of the presentation of the results and answers to questions.
Порядок та критерії виставляння балів та оцінок: 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. Методичні вказівки до виконання курсової роботи студентами першого (бакалаврського) рівня освіти спеціальності 173 «Телекомунікації і радіотехніка» з дисципліни «Бази даних в інформаційно-комп’ютерних системах»
2. Берко А.Ю., Верес О.М., Пасічник В.В. Системи баз даних та знань. Книга 1. Організація баз даних та знань: навч. посібник. - Львів: «Магнолія 2006», 2021. – 440 с
3. Павлиш В.А., Гліненко Л.К. Основи інформаційних технологій і систем: навч. посібник / В.А.Павлиш, Л.К. Гліненко. - Львів: Видавництво львівської політехніки, 2013. - 500 с.
4. Берко А.Ю., Верес О.М., Пасічник В.В. Системи баз даних та знань. Книга 2. Системи управління базами даних та знань: навч. посібник. – Львів : «Магнолія-2006», 2021. – 584 с.
5. ДСТУ ISO/IEC 2382:2017 Інформаційні технології. Словник термінів (ISO/IEC 2382:2015, IDT). - К.: «УкрНДНЦ», 2019.
6. Бази даних в інформаційних системах: підручник / Гайдаржи В. І., Ізварін І. В. ; Нац. техн. ун-т України "Київ. політехн. ін-т ім. Ігоря Сікорського", Відкритий міжнар. ун-т розвитку людини "Україна". - Київ : Ун-т "Україна", 2018. - 417 с.
7. Електронний навчально-методичний комплекс «Бази даних в інформаційно-комп'ютерних системах». Сертифікат № 03026 Е-41-122-67/2019 від 04.12.2019 р. http://vns.lpnu.ua/course/view.php?id=5417
Уніфікований додаток: 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).