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.