|
|
|
||
Last update: Mgr. Lukáš Brůha, Ph.D. (27.11.2019)
|
|
||
Last update: Mgr. Lukáš Brůha, Ph.D. (10.01.2020)
Hoffer, J. a kol. (2019): Modern Database Management, Pearson Education Limited, 592 s, ISBN 9781292263359 Juba, S. a kol. (2019): Learning PostgreSQL 11: A beginner's guide to building high-performance PostgreSQL database solutions, 3rd Edition, 556 s, Packt Publishing, ISBN: 978-1789535464 Ramez, E. (2017): Fundamentals of Database Systems, 7th Edition, Pearson, 1272 s, ISBN 978-0133970777 Mikiewicz, D. a kol. (2017): Mastering PostGIS, Packt Publishing, 328 s, ISBN 9781784391645 Pokorný, J. (2002): Dotazovací jazyky, Karolinium, 225 s, ISBN 80-246-0497-3 Codd, E.F. (1970): A relational model of data for large shared data banks, CACM, 10 s |
|
||
Last update: Mgr. Lukáš Brůha, Ph.D. (11.02.2023)
For a successful completion of the course three practical assignments need to be duly elaborated. The first task is in the field of ERD modelling and the second and third concern DDL and DML SQL scripting. Final examination has oral character. |
|
||
Last update: Mgr. Lukáš Brůha, Ph.D. (11.02.2023)
The content of the course includes: - entity-relationshhip modeling - functional dependencies - database normalization - relational algebra |