Database Systems

Garant předmětu:

Lecturer:

Tutor:

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:

not 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 DB 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:

Further information:

No time-table has been prepared for this course

The course is a part of the following study plans:

• PIL bak.prez.10/11 (compulsory course in the program)
• TUL bak.prez.10/11 (compulsory course in the program)
• MED bak.komb.10/11 (compulsory course)
• MED bak.komb.11/12 (compulsory course)
• PIL bak.prez.11/12 (compulsory course)
• TUL bak.prez.11/12 (compulsory course)
• AUT bak.prez.11/12 (compulsory course)
• DOS bak.prez.11/12 (compulsory course)
• ITS bak.prez.11/12 (compulsory course)
• LED bak.prez.11/12 (compulsory course)
• MED bak.prez.11/12 (compulsory course)
• MED bak.komb.12/13 (compulsory course)
• PIL bak.prez.12/13 (compulsory course)
• TUL bak.prez.12/13 (compulsory course)
• AUT bak. prez.12/13 (compulsory course)
• DOS bak.prez.12/13 (compulsory course)
• MED bak.prez.12/13 (compulsory course)
• ITS bak.prez.12/13 (compulsory course)
• LED bak.prez.12/13 (compulsory course)
• PIL bak.prez.13/14 (compulsory course)
• TUL bak.prez.13/14 (compulsory course)
• MED bak.komb.13/14 (compulsory course)
• AUT bak.prez.13/14 (compulsory course)
• DOS bak.prez.13/14 (compulsory course)
• ITS bak.prez.13/14 (compulsory course)
• LED bak.prez.13/14 (compulsory course)
• MED bak.prez.13/14 (compulsory course)
• DOS bak.prez.13/14 (SKOK) (compulsory course)
• LED bak.prez.13/14 (SKOK) (compulsory course)
• MED bak.prez.13/14 (SKOK) (compulsory course)
• PIL bak.prez.14/15 (compulsory course)
• TUL bak.prez.14/15 (compulsory course)
• DOS bak.prez.14/15 (compulsory course)
• MED bak.prez.14/15 (compulsory course)
• ITS bak.prez.14/15 (compulsory course)
• LED bak.prez.14/15 (compulsory course)
• bak.prez.od 15/16 (compulsory course)
• DOS bak.prez.15/16 (compulsory course)
• MED bak.prez.15/16 (compulsory course)
• LED bak.prez.15/16 (compulsory course)
• bak.prez.od 16/17 - v 1.sem. si NEZAPSALI 14DB (compulsory course)
• DOS bak.prez.16/17 (compulsory course)
• LOG bak.prez.16/17 (compulsory course)
• ITS bak.prez.16/17 (compulsory course)
• LED bak.prez.16/17 (compulsory course)
• BEZ bak.prez.16/17 (compulsory course)
• bak.prez.od 16/17 - v 1.sem. si ZAPSALI 14DB (compulsory course)
• DOS bak.prez.17/18 - v 1.sem. si NEZAPSALI 14DB (compulsory course)
• DOS bak.prez.17/18 - v 1.sem. si ZAPSALI 14DB (compulsory course)
• LOG bak.prez.17/18 - v 1.sem. si NEZAPSALI 14DB (compulsory course)
• LOG bak.prez.17/18 - v 1.sem. si ZAPSALI 14DB (compulsory course)
• ITS bak.prez.17/18 - v 1.sem. si NEZAPSALI 14DB (compulsory course)
• ITS bak.prez.17/18 - v 1.sem. si ZAPSALI 14DB (compulsory course)
• LED bak.prez.17/18 - v 1.sem. si NEZAPSALI 14DB (compulsory course)
• LED bak.prez.17/18 - v 1.sem. si ZAPSALI 14DB (compulsory course)
• BEZ bak.prez.17/18 - v 1.sem. si NEZAPSALI 14DB (compulsory course)
• BEZ bak.prez.17/18 - v 1.sem. si ZAPSALI 14DB (compulsory course)