Database systems

Semestr: Winter

Range: 2+2s

Completion:

Credits: 4

Programme type: Undefined

Study form:

Course language:

Summary:

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;

Keywords:

Course syllabus:

Seminar syllabus:

Literature:

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.

Examiners:

Lecturers:

Instructors: