460-2056 – Database Systems I (DS I)

Gurantor departmentDepartment of Computer Science
Subject guarantordoc. Ing. Radim Bača, Ph.D.
Study levelundergraduate or graduate
Subject version
Version codeYear of introductionYear of cancellationCredits
460-2056/01 2019/2020 4
460-2056/02 2019/2020 4

Subject aims expressed by acquired skills and competences

The primary goal is to introduce the basic database concepts such as the relational model and the SQL language. The students who finish this course will be able to specify the conceptual model and the relational scheme of an information system, and they will have a general knowledge of the basic SQL commands according to the SQL92 standard.

Teaching methods

Lectures
Tutorials
Project work

Summary

This course is a basic introduction to database technologies. The main topics are the conceptual modeling, the relational data model and the SQL language for data definition, manipulation and querying.

Compulsory literature:

H. Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001.

Recommended literature:

C.J. Date: An Introduction to Database Systems. Addison Wesley, 8th Edition, 2003.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.