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
BI-DBS.21 Z,ZK 5 2P+2R+1L Czech
Garant předmětu:
Michal Valenta
Lecturer:
Michal Valenta
Tutor:
Jan Bittner, Jan Blizničenko, Monika Borkovcová, Cyril Černý, Přemysl Dědic, Filip Glazar, Jiří Hunka, Martin Kolárik, Tomáš Krupička, Pavel Kříž, Ladislav Louka, Jan Matoušek, Štěpán Pechman, Andrii Plyskach, Lucie Procházková, Dominik Roudný, Martin Urbanec, Michal Valenta
Supervisor:
Department of Software Engineering
Synopsis:

Students are introduced to the database engine architecture and typical user roles. They are briefly introduced to various database models. They learn to design small databases (including integrity constraints) using a conceptual model and implement them in a relational database engine. They get a hands-on experience with the SQL language, as well as with its theoretical foundation - the relational database model. They learn the principles of normalizing a relational database schema. They understand the fundamental concepts of transaction processing, controlling parallel user access to a single data source, as well as recovering a database engine from a failure. They are briefly introduced to special ways of storing data in relational databases with respect to speed of access to large quantities of data. This introductory-level course does not cover: Administration of database systems, debugging and optimizing database applications, distributed database systems, data stores.

Requirements:

Common user-level knowledge of Unix/Linux and MS Windows operating systems, ability to describe a solution to a problem algorithmically, and elementary knowledge of algebra and logic are expected. Active knowledge of a specific programming language is not required.

Syllabus of lectures:

1. Basic principles of database systems, architectures of database management systems.

2. Conceptual, database, and physical level of view of data.

3. Conceptual data model. Basic constructs, expression of integrity constraints.

4. Relational data model. Relation, attributes, domains, relational database schema, relational algebra.

5. Introduction to the SQL language: basics of the SELECT statement, basics of the SQL DDL.

6. Design of a relational scheme by direct transformation from a conceptual scheme.

7. The SQL language - advanced querying: aggregation, nested queries, set operations.

8. The SQL language: parts DCL, DML, TCL.

9. Transactions, error recovery, parallel access coordination, data protection.

10. Functional dependencies, normal forms of relations, normalization of a relational scheme by decomposition.

11. Physical level of view of data. Indexes and their use in relational databases. Basics of SQL query optimization.

12. Nonrelational database models. Trends in databases.

13. Access of applications to a (relational) database. Introduction to the concept of software engineering.

Syllabus of tutorials:

1. Seminar: Introduction, project assignment.

2. Computer lab: Introduction to the environment and the tools.

3. Seminar: Conceptual data modeling.

4. Computer lab: SQL communication with a database engine, working with a conceptual modeler.

5. Seminar: Conceptual data modeling, relational algebra as a query language.

6. Computer lab: Working on projects, consultations.

7. Seminar: Relational algebra as a query language.

8. Computer lab: Working on projects, consultations.

9. Seminar: SQL.

10. Computer lab: Working on projects, consultations, project checkpoint.

11. Seminar: SQL.

12. Computer lab: Working on projects.

13. Seminar: Normalization of a schema, functional dependencies. Assessments

Study Objective:

After completing the course, students will be able to design and implement small databases and work with them effectively using the SQL language. Today, knowledge of (relational) databases is a necessary qualification, not just for programmers of information systems and creators of www applications, but for practically all informatics professionals. The course provides hands-on experience with databases that can be directly used in a wide range of situations, as well as theoretical foundations for subsequent courses, such as Database systems administration or specialized database-oriented courses (SQL, Database systems 2) in the second cycle degree programme.

Study materials:

1. Coronel C., Morris S. : Database Systems: Design, Implementation, and Management (13th Edition). Cengage Learning, 2018. ISBN 978-1337627900.

2. Garcia-Molina H., Ulman D. J., Widom J. : Database systems: The Complete Book (2nd Edition). Pearson Education, 2009. ISBN 978-0131873254.

3. Harrington J.L. : Relational Database Design and Implementation (4th Edition). Morgan Kaufmann, 2016. ISBN 978-0128043998.

4. Pokorný J., Valenta M.: Databázové systémy (2. rozšířené vydání). CVUT Praha, 2020. ISBN 978-80-01-06708-6.

Note:
Further information:
https://dbs.fit.cvut.cz
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
roomT9:348
Valenta M.
09:15–10:45
ODD WEEK

Dejvice
NBFIT PC ucebna
roomTH:D-1122
Valenta M.
14:30–16:00
(lecture parallel1)
Thákurova 7 (budova FSv)
D1122
roomT9:105
Valenta M.
18:00–19:30
(lecture parallel2)
Dejvice
Posluchárna
roomT9:348
Pechman Š.
11:00–12:30
ODD WEEK

Dejvice
NBFIT PC ucebna
roomT9:348
Valenta M.
12:45–14:15
ODD WEEK

Dejvice
NBFIT PC ucebna
roomT9:303
Roudný D.
14:30–16:00
ODD WEEK

Dejvice
NBFIT PC ucebna
roomT9:351
Kolárik M.
16:15–17:45
ODD WEEK

Dejvice
NBFIT PC ucebna
roomT9:351
Kolárik M.
18:00–19:30
ODD WEEK

Dejvice
NBFIT PC ucebna
Tue
roomTK:BS
Hunka J.
09:15–10:45
(parallel nr.1)
Dejvice
NTK Ballingův sál
roomTK:BS
Hunka J.
11:00–12:30
(parallel nr.2)
Dejvice
NTK Ballingův sál
roomT9:303
Plyskach A.
18:00–19:30
EVEN WEEK

Dejvice
NBFIT PC ucebna
roomTK:BS
Hunka J.
16:15–17:45
(parallel nr.3)
Dejvice
NTK Ballingův sál
roomTK:BS
Hunka J.
18:00–19:30
(parallel nr.4)
Dejvice
NTK Ballingův sál
roomT9:303
Dědic P.
18:00–19:30
ODD WEEK

Dejvice
NBFIT PC ucebna
Wed
roomT9:303
Hunka J.
09:15–10:45
EVEN WEEK

Dejvice
NBFIT PC ucebna
roomT9:303
Glazar F.
11:00–12:30
EVEN WEEK

Dejvice
NBFIT PC ucebna
roomT9:350
Urbanec M.
12:45–14:15
EVEN WEEK

Dejvice
NBFIT PC ucebna
roomT9:303
Blizničenko J.
09:15–10:45
ODD WEEK

Dejvice
NBFIT PC ucebna
roomT9:303
Blizničenko J.
11:00–12:30
ODD WEEK

Dejvice
NBFIT PC ucebna
roomT9:350
Urbanec M.
12:45–14:15
ODD WEEK

Dejvice
NBFIT PC ucebna
Thu
roomT9:348
Hunka J.
07:30–09:00
EVEN WEEK

Dejvice
NBFIT PC ucebna
roomT9:348
Glazar F.
09:15–10:45
EVEN WEEK

Dejvice
NBFIT PC ucebna
roomT9:350
Matoušek J.
12:45–14:15
ODD WEEK

Dejvice
NBFIT PC ucebna
roomT9:350
Matoušek J.
14:30–16:00
ODD WEEK

Dejvice
NBFIT PC ucebna
roomT9:348

07:30–09:00
ODD WEEK

Dejvice
NBFIT PC ucebna
roomT9:348
Plyskach A.
09:15–10:45
ODD WEEK

Dejvice
NBFIT PC ucebna
Fri
roomT9:303
Černý C.
07:30–09:00
EVEN WEEK

Dejvice
NBFIT PC ucebna
roomT9:303
Černý C.
09:15–10:45
EVEN WEEK

Dejvice
NBFIT PC ucebna
roomT9:303
Krupička T.
12:45–14:15
EVEN WEEK

Dejvice
NBFIT PC ucebna
roomT9:303
Dědic P.
16:15–17:45
EVEN WEEK

Dejvice
NBFIT PC ucebna
roomT9:303

07:30–09:00
ODD WEEK

Dejvice
NBFIT PC ucebna
roomT9:303

09:15–10:45
ODD WEEK

Dejvice
NBFIT PC ucebna
roomT9:303
Krupička T.
12:45–14:15
ODD WEEK

Dejvice
NBFIT PC ucebna
roomT9:303

16:15–17:45
ODD WEEK

Dejvice
NBFIT PC ucebna
The course is a part of the following study plans:
Data valid to 2024-04-22
Aktualizace výše uvedených informací naleznete na adrese https://bilakniha.cvut.cz/en/predmet6543806.html