Database Systems

Course guarantor:

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:

1. Introduction to relational databases, terminology, E-R model

2. Decomposition, candidate keys, normal forms

3. Relationship modelling

4. Data integrity

5. Relational algebra

6. noSQL databases

7. Example

Syllabus of tutorials:

1. ER model - example

2. Creating tables

3. Modelling relationships

4. Inserting data into the database

5. - 6. Querying data, SQL, Views

7. Consultation on own seminar work

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
Tue
Wed	roomHO:A-270 Kaliková J. 09:45–11:15 (parallel nr.230) Horská 3 (stará budova) roomHO:A-270 Kaliková J. 11:30–13:00 (parallel nr.231) Horská 3 (stará budova) roomHO:A-270 Kaliková J. 13:15–14:45 (parallel nr.232) Horská 3 (stará budova) roomHO:B-101 Krčál J. 09:45–11:15 (parallel nr.233) Horská 3 (nová budova) roomHO:B-101 Krčál J. 11:30–13:00 (parallel nr.234) Horská 3 (nová budova) roomHO:B-101 Krčál J. 13:15–14:45 (parallel nr.235) Horská 3 (nová budova) roomHO:A-136 Krčál J. 09:45–11:15 (lecture parallel2) Horská 3 (stará budova) roomHO:A-136 Kaliková J. 13:15–14:45 (lecture parallel1) Horská 3 (stará budova)
Thu
Fri

Time-table for summer semester 2024/2025:

Time-table is not available yet

The course is a part of the following study plans:

• Bachelor TET-LOG Full-Time from 2022/23 (compulsory course)
• Bachelor TET-DOS Full-Time from 2022/23 (compulsory course)
• Bachelor TET-ITS Full-Time from 2022/23 (compulsory course)
• Bachelor TET-LED Full-Time from 2022/23 (compulsory course)
• Bachelor TET Common Part of Study Full-Time from 2023/24 (compulsory course)
• Bachelor TET-DOS Full-Time from 2023/24 (compulsory course)
• Bachelor TET-LOG Full-Time from 2023/24 (compulsory course)
• Bachelor TET-ITS Full-Time from 2023/24 (compulsory course)
• Bachelor TET-LED Full-Time from 2023/24 (compulsory course)
• Bachelor TET Common Part of Study Full-Time from 2024/25 (compulsory course)
• Bachelor TET-DOS Full-Time from 2024/25 (compulsory course)
• Bachelor TET-ITS Full-Time from 2024/25 (compulsory course)
• Bachelor TET-LED Full-Time from 2024/25 (compulsory course)
• Bachelor TET-LOG Full-Time from 2024/25 (compulsory course)
• Bachelor TET-LOG Part-Time from 2025/26 (compulsory course)