Course details
Data Modelling and Database Design
DSI Acad. year 2003/2004 Winter semester 6 credits
Fundamentals of database systems (DBS). Relational database design from a conceptual model. SQL language. Fundamentals of the relational model. Normalization-based design of a relational database. Organization of data at an internal level. Data security and integrity. Introduction to query optimization. Transaction processing - database recovery, concurrency control. Introduction to DBS architectures: client/server, multi-tier architectures, distributed DBS. Introduction to postrelational DBS. Access to databases from WWW. 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.
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 EI-BC-3, field VTB, 1st year of study, Compulsory
- Programme EI-BC-3 (in English), field VTB, 1st year of study, Compulsory
- Programme EI-MGR-3, field VTN, 1st year of study, Compulsory
- Programme EI-MGR-5, field VTI, 1st year of study, Compulsory
- Programme EI-MGR-5 (in English), field VTI, 1st year of study, Compulsory