Database systems

The course cannot be taken simultaneously with:

Database Systems (E36DBS)

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.

Note:

Further information:

No time-table has been prepared for this course

The course is a part of the following study plans: