Database Systems

Code	Completion	Credits	Range	Language
B0B36DBS	Z,ZK	6	2P+2C+4D	Czech

Course guarantor:

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

Time-table is not available yet

Time-table for summer 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	roomKN:E-307 Kostov B. 12:45–14:15 (lecture parallel1 parallel nr.101) Karlovo nám. roomKN:E-311 Prokop Y. 14:30–16:00 (lecture parallel1 parallel nr.112) Karlovo nám. roomKN:E-107 Řimnáč M. 16:15–17:45 (lecture parallel1) Karlovo nám. roomKN:E-311 Prokop Y. 12:45–14:15 (lecture parallel1 parallel nr.111) Karlovo nám. roomFS_KN:A-320 Řimnáč M. 16:15–17:45 (lecture parallel1) Karlovo nám.
Wed	roomKN:E-307 Nagyová I. 09:15–10:45 (lecture parallel2 parallel nr.109) Karlovo nám. roomKN:E-328 Prokop Y. 16:15–17:45 (lecture parallel2 parallel nr.102) Karlovo nám. roomKN:E-328 Prokop Y. 18:00–19:30 (lecture parallel2 parallel nr.104) Karlovo nám. roomKN:E-307 Nagyová I. 11:00–12:30 (lecture parallel1 parallel nr.110) Karlovo nám.
Thu	roomKN:E-301 Řimnáč M. 09:15–10:45 (lecture parallel2) Karlovo nám. roomKN:E-307 Prokop Y. 14:30–16:00 (lecture parallel1 parallel nr.103) Karlovo nám. roomKN:E-311 Řimnáč M. 16:15–17:45 (lecture parallel1 parallel nr.107) Karlovo nám. roomKN:E-311 Řimnáč M. 18:00–19:30 (lecture parallel1 parallel nr.108) Karlovo nám. roomKN:E-311 Řimnáč M. 12:45–14:15 (lecture parallel2 parallel nr.105) Karlovo nám. roomKN:E-311 Řimnáč M. 14:30–16:00 (lecture parallel1 parallel nr.106) Karlovo nám.
Fri

The course is a part of the following study plans:

Software Engineering and Technology (compulsory course in the program)
Open Informatics - Computer Science 2016 (compulsory course in the program)
Open Informatics - Internet of Things 2016 (compulsory course in the program)
Open Informatics - Software 2016 (compulsory course in the program)
Open Informatics - Computer Games and Graphics 2016 (compulsory course in the program)
Open Informatics (compulsory course in the program)
Medical electronics and bioinformatics (compulsory elective course)
Open Informatics (compulsory course in the program)
Open Informatics - Artificial Intelligence and Computer Science 2018 (compulsory course in the program)
Open Informatics - Internet of Things 2018 (compulsory course in the program)
Open Informatics - Software 2018 (compulsory course in the program)
Open Informatics - Computer Games and Graphics 2018 (compulsory course in the program)
Software Engineering and Technology (compulsory course in the program)
Software Engineering and Technology (compulsory course in the program)
Software Engineering and Technology (compulsory course in the program)
Software Engineering and Technology (compulsory course in the program)
Software Engineering and Technology (compulsory course in the program)