Database Systems
Code | Completion | Credits | Range | Language |
---|---|---|---|---|
14DATS | KZ | 2 | 1P+1C+10B | Czech |
- Garant předmětu:
- Jana Kaliková
- Lecturer:
- Jana Kaliková, Jan Krčál
- Tutor:
- Jana Kaliková, Jan Krčál
- Supervisor:
- Department of Applied Informatics in Transportation
- Synopsis:
-
Basic concepts of database systems, conceptual model, relational data model, the principles of normal forms, relational database design, security and integrity of data, database queries, relational algebra, SQL language, client / server, multilayer architectures, distributed database systems. Access to data via the WWW.
- Requirements:
-
no defined
- Syllabus of lectures:
- Syllabus of tutorials:
- Study Objective:
-
Fundamentals of relational database theory, practical skills in using database technology at a level required for database design and creation of queries to the database. Introduction to database administration, architectures of database systems, trends in database technologies.
- Study materials:
-
Jeřábek M., Kaliková J., Kalika M., Krčál J., Krčálová L.: Databázové systémy pro dopravní aplikace, vydavatelství ČVUT, 2010
Riordan M. Rebecca:Vytváříme relační databázové aplikace, Computer Press, 2000
Hernandes Michael J.: Návrh databází, Praha, Grada 2006
Groff James R., Winberg Paul N.: SQL - Kompletní průvodce, Brno, Computer Press 2005
- Note:
- Time-table for winter semester 2022/2023:
- Time-table is not available yet
- Time-table for summer semester 2022/2023:
- Time-table is not available yet
- The course is a part of the following study plans:
-
- bak.prez.od 16/17 - v 1.sem. si NEZAPSALI 14DB (compulsory course)
- bak.prez.od 17/18 (compulsory course)
- DOS bak.prez.17/18 - v 1.sem. si NEZAPSALI 14DB (compulsory course)
- LOG bak.prez.17/18 - v 1.sem. si NEZAPSALI 14DB (compulsory course)
- ITS bak.prez.17/18 - v 1.sem. si NEZAPSALI 14DB (compulsory course)
- LED bak.prez.17/18 - v 1.sem. si NEZAPSALI 14DB (compulsory course)
- BEZ bak.prez.17/18 - v 1.sem. si NEZAPSALI 14DB (compulsory course)
- LOG bak.prez.17/18 - včetně 11FYZ v 3.s. (compulsory course)
- LED bak.prez.17/18 - včetně 11FYZ v 3.s. (compulsory course)
- bak.prez.od 18/19 (compulsory course)
- DOS bak.prez.18/19 (compulsory course)
- LOG bak.prez.18/19 (compulsory course)
- ITS bak.prez.18/19 (compulsory course)
- LED bak.prez.18/19 (compulsory course)
- DOS bak.prez.18/19 (skok do 3.r.) (compulsory course)
- CŽV pro LED bak.prez. v 18/19 (compulsory course)
- LOG bak.prez.18/19 (skok do 3.r.) (compulsory course)
- ITS bak.prez.18/19 (skok do 3.r.) (compulsory course)
- LED bak.prez.18/19 - skok z 2.r.do 3.r. (compulsory course)
- bak.prez.od 19/20 (compulsory course)
- LED bak.prez.19/20 angličtina (compulsory course)
- DOS bak.prez.19/20 (compulsory course)
- LOG bak.prez.19/20 (compulsory course)
- ITS bak.prez.19/20 (compulsory course)
- LED bak.prez.19/20 (compulsory course)
- ITS bak.prez.19/20 (skok do 3.r.) (compulsory course)
- DOS bak.prez.19/20 (skok do 3.r.) (compulsory course)
- LED bak.prez.19/20 (skok do 3.r.) (compulsory course)
- bak.prez.od 20/21 (pro B3710) (compulsory course)
- LED bak.prez.20/21 angličtina (compulsory course)
- DOS bak.prez.20/21 (compulsory course)
- LOG bak.prez.20/21 (compulsory course)
- LOG bak.prez.20/21 (skok do 3.r.) (compulsory course)
- ITS bak.prez.20/21 (compulsory course)
- ITS bak.prez.20/21 (skok do 3.r.) (compulsory course)
- LED bak.prez.20/21 (compulsory course)
- LED bak.prez.20/21 (skok do 3.r.) (compulsory course)
- bak.prez.od 21/22 (pro B3710) (compulsory course)
- bak.prez.od 21/22 (skok do 2.r.) - pro B3710 (compulsory course)
- LED bak.prez.21/22 (skok do 3.r.) (compulsory course)
- DOS bak.prez.21/22 (skok do 3.r.) (compulsory course)
- LOG (obor) bak.prez.21/22 (skok do 3.r.) (compulsory course)
- ITS bak.prez.21/22 (skok do 3.r.) (compulsory course)
- DOS bak.prez.21/22 (compulsory course)
- ITS bak.prez.21/22 (compulsory course)
- LED bak.prez.21/22 (compulsory course)
- bak.prez.od 21/22 (pro TET) (compulsory course)