| Course Unit Code | 460-2032/01 |
|---|
| Number of ECTS Credits Allocated | 4 ECTS credits |
|---|
| Type of Course Unit * | Compulsory |
|---|
| Level of Course Unit * | First Cycle |
|---|
| Year of Study * | Second Year |
|---|
| Semester when the Course Unit is delivered | Summer Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| FAS01 | Ing. Radoslav Fasuga, Ph.D. |
| 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. |
| Learning Outcomes of the Course Unit |
|---|
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.
|
| Course Contents |
|---|
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 |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
C.J. Date: An Introduction to Database Systems. Addison Wesley, 8th Edition, 2003.
|
| Šarmanová, J.: Informační systémy ve zdravotnictví. Skriptum VŠB-TU Ostrava, 2007. |
| Recommended Reading: |
|---|
| H. Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001. |
J. Pokorný, I. Halaška: Databázové systémy. 2. vyd. Praha: Vydavatelství ČVUT, 2003. 148 s. ISBN 80-01-02789-9.
J. Pokorný: Dotazovací jazyky. Karolinum, 2002. 255 s. ISBN 80-246-0497-3.
J. Pokorný: Databázové systémy a jejich použití v informačních systémech. Academia Praha, 1992
H. Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001.
C.J. Date: An Introduction to Database Systems. Addison Wesley, 8th Edition, 2003.
|
| Planned learning activities and teaching methods |
|---|
| Lectures, Tutorials, Project work |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| 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 |