460-2032/01 – Information Systems in Medical Care (ISZ)

Gurantor departmentDepartment of Computer ScienceCredits4
Subject guarantorIng. Radoslav Fasuga, Ph.D.Subject version guarantorIng. Radoslav Fasuga, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year2Semestersummer
Study languageCzech
Year of introduction2010/2011Year of cancellation
Intended for the facultiesFEIIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
FAS01 Ing. Radoslav Fasuga, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2

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

Další požadavky na studenta

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

Full-time form (validity from: 2010/2011 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (100) 51
        Exercises evaluation Credit 45 (45) 20
                Test 1 – Design conceptual data model for given theme Written test 10  5
                Test 2 – Create set of queries in SQL for given theme Laboratory work 15  5
                Test 3 – Functional and Dynamical analysis with simply transaction analysis for given theme Written test 10  5
                Test 4 – Work with Medical Care information system Laboratory work 10  5
        Examination Examination 55 (55) 28
                Written examination Written examination 55  28
Mandatory attendence parzicipation: obligatory participation at all exercises, 3 apologies are accepted obligatory participation at midterm exams (tests) and project final presentation

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2019/2020 (B2649) Electrical Engineering (3901R039) Biomedical Technician P Czech Ostrava 2 Compulsory study plan
2018/2019 (B2649) Electrical Engineering (3901R039) Biomedical Technician P Czech Ostrava 2 Compulsory study plan
2017/2018 (B2649) Electrical Engineering (3901R039) Biomedical Technician P Czech Ostrava 2 Compulsory study plan
2016/2017 (B2649) Electrical Engineering (3901R039) Biomedical Technician P Czech Ostrava 2 Compulsory study plan
2015/2016 (B2649) Electrical Engineering (3901R039) Biomedical Technician P Czech Ostrava 2 Compulsory study plan
2014/2015 (B2649) Electrical Engineering (3901R039) Biomedical Technician P Czech Ostrava 2 Compulsory study plan
2013/2014 (B2649) Electrical Engineering (3901R039) Biomedical Technician P Czech Ostrava 2 Compulsory study plan
2012/2013 (B2649) Electrical Engineering (3901R039) Biomedical Technician P Czech Ostrava 2 Compulsory study plan
2011/2012 (B2649) Electrical Engineering (3901R039) Biomedical Technician P Czech Ostrava 2 Compulsory study plan
2010/2011 (B2649) Electrical Engineering (3901R039) Biomedical Technician P Czech Ostrava 2 Compulsory study plan
2010/2011 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (B2649) Electrical Engineering (2601R004) Measurement and Control Engineering (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (B2649) Electrical Engineering (2602R014) Applied and Commercial Electronics (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (B2649) Electrical Engineering (3901R039) Biomedical Technician (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (B2649) Electrical Engineering (3907R001) Electrical Power Engineering (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (B2647) Information and Communication Technology (1103R031) Computational Mathematics (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (B2647) Information and Communication Technology (2612R059) Mobile Technology (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (N2647) Information and Communication Technology (1103T031) Computational Mathematics (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (N2647) Information and Communication Technology (2601T013) Telecommunication Technology (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (N2647) Information and Communication Technology (2612T059) Mobile Technology (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (N2649) Electrical Engineering (2601T004) Measurement and Control Engineering (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (N2649) Electrical Engineering (2612T015) Electronics (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (N2649) Electrical Engineering (3901T009) Biomedical Engineering (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (N2649) Electrical Engineering (3907T001) Electrical Power Engineering (01) Exchange Students P Czech Ostrava Optional study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner