Course details
Database Systems
IDS Acad. year 2003/2004 Summer semester 5 credits
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.
Guarantor
Language of instruction
Completion
Time span
Department
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
- Programme IT-BC-3, field BIT, 2nd year of study, Compulsory
- Programme IT-BC-3 (in English), field BIT, 2nd year of study, Compulsory