Home/ Majors directory/Biomedical Engineering (Internet of Things)/Data Bases in Biomedical Computer and Information Systems
Data Bases in Biomedical Computer and Information Systems
Major: Biomedical Engineering (Internet of Things)
Code of subject: 6.163.03.E.054
Credits: 5.00
Department: Electronics and Information Technology
Lecturer: Hlinenko Larysa
Semester: 7 семестр
Mode of study: денна
Завдання: The study of the discipline envisages developing the following student competences:
general competences:
- GC2. Knowledge and understanding of the subject area and understanding of professional activities
- GC4. Skills in using information and communication technologies
- GC6. Ability to search, process and analyse information from various sources
professional competences:
- PC1. Ability to apply engineering software packages for research, analysis, processing and presentation of results, as well as for computer-aided design of medical devices and systems
- PC10. Ability to apply the principles of construction of modern automated control systems for the production of medical devices, their technical, algorithmic, information and software
- PCS1.4. Ability to operate diagnostic and therapeutic systems and perform diagnostic information processing
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 bioengineering systems;
– know 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;
– understand peculiar features of medical databases design and application;
– 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. GC10. Ability to demonstrate knowledge and skills in conducting experiments, data collection and modelling of electronic and telecommunication systems and networks
PLO 2. SC1. To analyse, argue, make decisions in solving specialised problems and practical problems of telecommunications and radio engineering, which are characterised by complexity and incomplete certainty of conditions
PLO 3. SC 13. Apply knowledge and understanding to solve problems of synthesis and analysis in information and communication systems that are characteristic of the chosen specialisation
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 and acquire new professional knowledge
Required prior and related subjects: - Fundamentals of information theory and information systems
– Fundamentals of Biotechnical Systems Modelling
– Information Technology in Biomedical Engineering
– Information Systems in Biomedical Engineering
Summary of the subject: The course examines the essence of the database concept; stages and approaches to their design, architecture and functions of DBMS. The course provides for the study of modern approaches to data modelling and database organisation, the main stages and tools for designing relational databases, tools for building an infological and logical database model, and the specifics of building medical databases are considered in detail. 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 tasks on the use of CASE tools and the environment of modern DBMSs.
Опис: 1. Basics of the concept of databases.
Data and information. Storing information in a computer. File systems. The approach of databases. Database systems. Database management systems (DBMS). Architecture and functions of DBMS. Classification of database management systems.
2. Fundamentals of database modelling and design. Data modelling in the process of creating databases. Classical (hierarchical, network, relational) and modern (multidimensional, object-oriented, object-relational, document-oriented) data models. The main stages of design. Database design as an iterative process of creating database models. Basic approaches to database design.
3. 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. Formalisation of entities, attributes and relationships in the transition to a logical model.
4. 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. Basic tools for manipulating relational data. Fundamentals of relational algebra and relational calculus. Theoretical set and special operations of relational algebra, their interpretation.
5. Fundamentals of relational database design. Normalisation of relations in the design process. Quality criteria for logical database models. Functional dependencies. Normalisation of relations in the process of database design The concept of normal form of the database and normalisation. The 1st, 2nd and 3rd normal forms, the algorithm for converting the database model to them. Correctness of the normalisation procedure. Features of designing medical databases of medical and diagnostic type, EVA - database model. Normal forms of higher orders: BCNF, 4th and 5th normal forms. Multivalued dependence and conjunction dependence. Algorithm for decomposing relationships in the design of a relational database schema.
6. Relational database language SQL SQL basics. Definition of database objects and data types in SQL. Specification of constraints in SQL. Views (virtual tables) in SQL. Basic 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
7 Database administration. 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.
Databases and the Internet. Internet access to databases and publishing databases on the Internet.
8. Medical databases. Classification and features of different types of medical databases
Assessment methods and criteria: Oral and written surveys in the process of performing and defending laboratory work and individual tasks, control and current testing in the VLE, examination testing, completion of control tasks, oral survey during the exam.
Критерії оцінювання результатів навчання: Maximum mark in points 100
Current control (PC) 40
- Presentation of laboratory reports - 16 points
- Individual tasks - 10 points
- Control tests - 14 points
Total for PC - 40 points
Examination control - 60 points
- written component - 54 points
- oral component - 6 points
Total for the course -100 points
Laboratory work is graded on the basis of the accuracy, completeness and self-efficacy of the solutions obtained for each of the tasks:
- the results obtained are correct, complete and self-determined - 100% of the maximum score;
- correct, complete and obtained with significant help and corroboration from the teacher - 90% of the maximum mark;
- the solutions obtained in the work are correct, but incomplete and obtained with significant assistance and corroboration from the teacher - 75% of the maximum grade;
- the results obtained contain mistakes, but the approach to obtaining a solution and the use of tools for obtaining a solution is correct - 50% of the maximum score.
Preliminary and control tests are conducted in a virtual learning environment and the score is given automatically for all test tasks. For the task type "essay" 100% of the maximum score is given in manual mode for a fully correct and complete performance, 85% - overall correct performance with minor errors in calculations; 75% for failure to solve the problem with some mistakes in the solution; 50% - for significant mistakes and incomplete solution based on the correct approach; 30% - for formulation of the correct approach without implementation of 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 marks - ("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. Електронний навчально-методичний комплекс «Бази даних в біомедичних інформаційно-комп'ютерних системах». Сертифікат № 03137 Е-41-122-71/2020 від 05.02.2020 р. http://vns.lpnu.ua/course/view.php?id=5419
2. Берко А.Ю., Верес О.М., Пасічник В.В. Системи баз даних та знань. Книга 1. Організація баз даних та знань: навч. посібник. _ Львів: «Магнолія 2006»б 2008. – 456 с
3. Павлиш В.А., Гліненко Л.К. Основи інформаційних технологій і систем: навч. посібник / В.А.Павлиш, Л.К. Гліненко. - Львів: Видавництво львівської політехніки, 2013. - 500 с.
4. Collen Morris F. Computer Medical Databases: The First Six Decades (1950-2010) (Health Informatics) / Morris F. Collen. - Springer; 2012. – 288 р.
5. https://clinicaltrials.gov/ База Національної медичної бібліотеки США ClinicalTrials.gov
6. https://www.who.int/ictrp/search/en/WHO International Clinical Trials Registry Platform (ICTRP)
7. https://clinicaltrials.dec.gov.ua) Державний Реєстр Клінічних Досліджень в Україні
8. http://softwarestencils.com/uml/index.html Visio Stencil and Template for UML 2.5
9. https://www.globalclinicaltrialsdata.com/ GlobalClinicalTrialsData.com
10. http://www.physionet.org Веб-сайт PhysioNet з доступом до БД фізіологічних досліджень
Уніфікований додаток: 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).