Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2023/2024
UPOZORNĚNÍ: Jsou dostupné studijní plány pro následující akademický rok.

Database Systems

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
B0B36DBS Z,ZK 6 2P+2C+4D Czech
Garant předmětu:
Martin Řimnáč
Lecturer:
Martin Řimnáč
Tutor:
Bogdan Kostov, Ingrid Nagyová, Yuliia Prokop, Martin Řimnáč
Supervisor:
Department of Computer Science
Synopsis:

The course is designed as a basic database course mainly aimed at the student ability to design a relational data model and to use the SQL language for data definition as well as for data querying and to choose the appropriate degree of transaction isolation. Students will also get acquainted with the most commonly used indexing techniques, database system architecture and their management. They will verify their knowledge during the elaboration of a continuously submitted seminar task.

Requirements:

math (function, projection, cartesian product)

JAVA

Syllabus of lectures:

- Conceptual model

- Relational model

- Functional dependencies

- Integrity constraints, reference integrity, normal forms

- SQL (schema definition), data querying

- Query optimization, indexes

- Stored procedures, triggers

- Object relational mapping, JPA

- Modern trends in database systems

Syllabus of tutorials:
Study Objective:

Students will be learned to design a data model for a relational database, formulate queries over a relational database in SQL, choose the appropriate degree of transaction isolation and design and implement a simple database application in Java.

Study materials:

Pokorný J., Valenta M.: Databázové systémy, Nakladatelství ČVUT, Praha, 2013, ISBN 978-80-01-05212-9

Note:
Further information:
https://cw.fel.cvut.cz/wiki/courses/b0b36dbs/
Time-table for winter semester 2023/2024:
Time-table is not available yet
Time-table for summer semester 2023/2024:
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
roomKN:E-307
Kostov B.
12:45–14:15
(lecture parallel1
parallel nr.101)

Karlovo nám.
HW-lab K307
roomKN:E-311
Prokop Y.
14:30–16:00
(lecture parallel1
parallel nr.112)

Karlovo nám.
Lab K311
roomKN:E-107
Řimnáč M.
16:15–17:45
(lecture parallel1)
Karlovo nám.
Zengerova posluchárna K1
roomKN:E-311
Prokop Y.
12:45–14:15
(lecture parallel1
parallel nr.111)

Karlovo nám.
Lab K311
Wed
roomKN:E-307
Nagyová I.
09:15–10:45
(lecture parallel2
parallel nr.109)

Karlovo nám.
HW-lab K307
roomKN:E-328
Prokop Y.
16:15–17:45
(lecture parallel2
parallel nr.102)

Karlovo nám.
Bourací učebna
roomKN:E-328
Prokop Y.
18:00–19:30
(lecture parallel2
parallel nr.104)

Karlovo nám.
Bourací učebna
roomKN:E-307
Nagyová I.
11:00–12:30
(lecture parallel1
parallel nr.110)

Karlovo nám.
HW-lab K307
Thu
roomKN:E-301
Řimnáč M.
09:15–10:45
(lecture parallel2)
Karlovo nám.
Šrámkova posluchárna K9
roomKN:E-307
Prokop Y.
14:30–16:00
(lecture parallel1
parallel nr.103)

Karlovo nám.
HW-lab K307
roomKN:E-311
Řimnáč M.
16:15–17:45
(lecture parallel1
parallel nr.107)

Karlovo nám.
Lab K311
roomKN:E-311
Řimnáč M.
18:00–19:30
(lecture parallel1
parallel nr.108)

Karlovo nám.
Lab K311
roomKN:E-311
Řimnáč M.
12:45–14:15
(lecture parallel2
parallel nr.105)

Karlovo nám.
Lab K311
roomKN:E-311
Řimnáč M.
14:30–16:00
(lecture parallel1
parallel nr.106)

Karlovo nám.
Lab K311
Fri
The course is a part of the following study plans:
Data valid to 2024-03-27
Aktualizace výše uvedených informací naleznete na adrese https://bilakniha.cvut.cz/en/predmet5010606.html