Database Systems

Course guarantor:

Jana Kaliková

Lecturer:

Ondřej Smíšek

Tutor:

Ondřej Smíšek

Supervisor:

Department Děčín

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 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 2024/2025:

	06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon	roomDP:218 Smíšek O. 10:30–11:15 (lecture parallel215) Decin PU2 (SM6)roomDP:218 Smíšek O. 11:30–12:15 (parallel nr.215) Decin PU2 (SM6)
Tue
Wed
Thu
Fri	roomDP:225 Smíšek O. 15:00–16:30 (parallel nr.219) Decin PU1 (SM4)roomDP:225 Smíšek O. 16:45–18:15 (parallel nr.219) Decin PU1 (SM4)roomDP:225 Smíšek O. 18:30–20:00 (parallel nr.219) Decin PU1 (SM4) roomDP:225 Smíšek O. 16:45–18:15 (parallel nr.219) Decin PU1 (SM4)roomDP:225 Smíšek O. 18:30–20:00 (parallel nr.219) Decin PU1 (SM4)

Time-table for summer semester 2024/2025:

Time-table is not available yet

The course is a part of the following study plans:

• KOMBI bak. studium od 20-21 (obor LED) (compulsory course)
• KOMBI bak. studium od 21-22 (obor LED) (compulsory course)
• KOMBI bak. studium od 22-23 (specializace LOG) (compulsory course)
• PRE bak. studium od 23-24 (spol. část studia) - program TET (compulsory course)
• KOMBI bak. studium od 23-24 (specializace LOG) (compulsory course)
• KOMBI bak. studium od 23-24 (specializace LOG) skok do 2.r. (compulsory course)
• PRE bak. studium od 24-25 (spol. část studia) - program TET (compulsory course)