Lecturer(s)
|
-
Prokýšek Miloš, PhDr. Ph.D.
-
Klán Petr, doc. Mgr. Ing. CSc.
-
Geyer Jakub, Mgr.
|
Course content
|
Topics: 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), Practical training
- Preparation for classes
- 30 hours per semester
- Semestral paper
- 20 hours per semester
- Preparation for exam
- 20 hours per semester
- Class attendance
- 56 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.
The student is able to independently create designs and implementations of relational databases, including their administration.
|
Prerequisites
|
Introductory course. Basic knowledge of working with ICT.
|
Assessment methods and criteria
|
Oral examination, Analysis of student's work activities (technical works)
Credits are given for elaborated model of database in the form of entity-relationship model, relational model and a non-trivial SQL select statement on this database model. Oral examination from relational database theory.
|
Recommended literature
|
-
Carlos Coronel, Steven Morris. Database Systems: Design, Implementation, & Management. Cengage Learning, 2018. ISBN 9781305627482.
-
HERNANDEZ, M., J. Návrh databází. Grada, 2006. ISBN 80-247-0900-7..
-
Ryan K. Stephens, Ronald R. Plew. Naučte se SQL za 28 dní. Computer Press, 2012. ISBN 9788025127001.
|