Course details

Database Systems

IDS Acad. year 2003/2004 Summer semester 5 credits

Current academic year

Fundamentals of database systems (DBS). Relational database design from a conceptual model. The relational model. SQL language. Normalization-based design of a relational database. Organization of data at an internal level. Transaction processing. Introduction to database administration: data security and integrity, database recovery, performance optimization. DBS architectures: client/server, multi-tier architectures, distributed DBS. Trends in database technologies. Development of a database application in modern development and database environment.

Details ...

Guarantor

Zendulka Jaroslav, doc. Ing., CSc.

Language of instruction

Czech, English

Completion

Examination

Time span

Department

Department of Information Systems (UIFS)

Subject specific learning outcomes and competences

Students are able to develop conceptual models of an application domain for database applications and have knowledge of relational database management system fundamentals.

Learning objectives

Mastering fundamentals of relational database theory and skill in using database technology at a level required for database design, development of database applications and database administration.

Recommended prerequisites

Fundamental literature

  • Silberschatz, A., Korth H.F, Sudarshan, S.: Database System Concepts. Sixth Edition. McGraw-Hill. 2010, 1320 p.

Progress assessment

Written mid-term exam, presentation of the first project and defence of the second one in due dates.

Course inclusion in study plans

Back to top