Database systems

The course cannot be taken simultaneously with:

Database systems (36DBS)

Lecturer:

Tutor:

Supervisor:

Department of Computer Science and Engineering

Synopsis:

Data processing, DBMS concepts and architecture; conceptual data models, E-R model; database models, network, hierarchical and relational model; relational algebra, formal query language; relational database desing, functional dependences, normalisation, design algorithms; mapping E-R concepts to the database models; query language SQL, DDL, DML, integrity constraints; transaction, error recovery, parallel access, data security, client-server architecture; physical level data view;

Requirements:

Syllabus of lectures:

Syllabus of tutorials:

Study Objective:

Study materials:

Date, C.J.: An Introduction to Database Systems. Vol. 1, Forth Ed.,

Addison-Wesley, 1987.

Elmasri, R., Navath, S.: Fundamentals of Database Systems.

Redwood City, CA: Benajmin/Cummings, 1989.

Batini, C.,Ceri, S., Navath, S: Conceptual Database Design in E-R Approach.

The Benjamin/Cummings Publ. COmp., Inc., 1992.

Pokorný, J., Halaška, I.: Databázové systémy.

Vydavatelství ČVUT, 1998

Pokorný, J., Halaška, I.: Databázové systémy: vybrané kapitoly a cvičení.

Vydavatelství ČVUT, 1992.

Pokorný, J., Halaška, I.: Databázové systémy, cvičení, Jazyk SQL a systém Oracle.

Vydavatelství ČVUT, 1995.

Pokorný, J.: Databázové systémy a jejich použití v informačních systémech.

ACADEMIA, 1992.

Pokorný, J.: Dotazovací jazyky.

Science, Veletiny, 1994.

Sokolowsky, P.,Pokorný, J.,Peterka, J.: Distribuované databázové systémy.

ACADEMIA, Praha, 1992.

Note:

Further information:

No time-table has been prepared for this course

The course is a part of the following study plans: