460-2032/01 – Information Systems in Medical Care (ISZ)
Gurantor department | Department of Computer Science | Credits | 4 |
Subject guarantor | Ing. Radoslav Fasuga, Ph.D. | Subject version guarantor | Ing. Radoslav Fasuga, Ph.D. |
Study level | undergraduate or graduate | Requirement | Compulsory |
Year | 2 | Semester | summer |
| | Study language | Czech |
Year of introduction | 2010/2011 | Year of cancellation | 2021/2022 |
Intended for the faculties | FEI | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
After course finish student know:
- Basic terms from area of database and information systems,
- know to determine basic IS,
- cooperate on data, functional, and dynamic analysis IS,
- know basic SQL language commands, and is capable to search requested information from database,
- can work with concrete information system from area of Medical care.
Teaching methods
Lectures
Tutorials
Project work
Summary
In this course receive student knowledge about information system design, with requested terms and problems and also with their practical usage in process of analysis, design and implementation. Student will know how to use SQL practically for selecting information form databases. Theoretically receives information about transaction processing and distributed database systems.
Compulsory literature:
C.J. Date: An Introduction to Database Systems. Addison Wesley, 8th Edition, 2003.
Recommended literature:
H. Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001.
Way of continuous check of knowledge in the course of semester
Successful finish for four presence test for minimal score requirements:
Test 1 – Design conceptual data model for given theme
Test 2 – Create set of queries in SQL for given theme
Test 3 – Functional and Dynamical analysis with simply transaction analysis for given theme
Test 4 – Work with Medical Care information system – patient evidence, enter diagnosis, orders for medical examinations, laboratory tests
E-learning
Other requirements
Additional requirements are placed on the student.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
1. Evidence task, basic terms, database, and information system.
2. Data analyses, Conceptual schema, ERD (Entity Relationship Diagram), transaction ERD pro RDM (Relational Data Model)
3. Data analysis in relational database, functional dependencies, normal forms
4. Information searching (retrieval) in RDM, relational languages, relational algebra
5. SQL(Structured Query Language) – commands for data structure definition, commands for data manipulation INSERT, DELETE, UPDATE, basic SELECT
6. SQL – full select SELECT, advanced syntax, multi-table query, aggregation functions
7. SQL – SELECT, sub-query, VIEW, GRANT, REVOKE.
8. Information system desing life-cycle, functional analysis, context diagram, DFD (Data Flow Diagram), elementary functions
9. Mini-specification for elementary functions, structural language
10. Dynamic analysis, state diagram, entity state
11. Database consistence, transaction, log, database recovery, multi-user access
12. Physical data organization, Sequential files, indexes, B-tree
13. Design, Implementation, traffic
14. Medical care documentation, Medical care informatics, Dividing of Medical care information systems
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction