|
Lecturer(s)
|
-
Prokýšek Miloš, PhDr. Ph.D.
-
Geyer Jakub, Mgr.
|
|
Course content
|
1. Basic database concepts 2. E-R conceptual model 3. Relational database model 4. Object and relational model 5. SQL 6. SELECT statement of the SQL language. 7. Relational algebra 8. Functional relation and Armstrong rules 9. Database normalization 10. Transaction data processing 11. Binary and multilevel locks 12. Time stamps and Multiversions
|
|
Learning activities and teaching methods
|
Monologic (reading, lecture, briefing), Projection, Practical training
- Class attendance
- 56 hours per semester
- Semestral paper
- 20 hours per semester
- Preparation for classes
- 56 hours per semester
- Preparation for exam
- 20 hours per semester
|
|
Learning outcomes
|
The course is aimed to basic theory of database technology. The course includes introduction to basic database models (E-R conceptual model, relational DB model, object DB model), rules of database normalization process, relational algebra, query language SQL, transaction and concurrent access to databases.
Student is able to create independently projects and implementations of relational databases, including their administration.
|
|
Prerequisites
|
Introducing course. Basic knowledge of ICT.
|
|
Assessment methods and criteria
|
Analysis of student's work activities (technical works), Combined exam
Creation of database, its optimization and normalization and subsequent defense. Combined exam in relational database theory and SQL knowledge.
|
|
Recommended literature
|
-
DRAGON, P., ALBHARI, B., NEWARK, T. C# v kostce. Grada, 2006. ISBN 80-247-0443-9..
-
HERNANDEZ, M., J. Návrh databází. Grada, 2006. ISBN 80-247-0900-7..
-
KANISOVÁ, H.,MÜLLER, M. UML srozumitelně. Computer Press, 2006. ISBN 80-251-1083-4..
-
KEOGH, J., GIANNINI, M. OOP Objektově orientované programování bez předchozích znalostí. Computer Press, 2006. ISBN 80-251-0973-9..
-
ŠIMŮNEK, M. SQL - kompletní kapesní průvodce. Grada, 2001. ISBN 80-7169-692-7..
|