Přístupnostní navigace
E-application
Search Search Close
Course detail
FIT-IDSAcad. year: 2023/2024
Fundamentals of database systems (DBS). Conceptual Modelling. The relational model. Relational database design from a conceptual model. Normalization-based design of a relational database. SQL language. Transaction processing. DBS architectures: client/server, multi-tier architectures, distributed DBS. Introduction to database administration: data security and integrity, introduction to physical database design, performance optimization, database recovery, concurrency control. Trends in database technology. The project consists in designing the structure of a relational database and programming SQL scripts to create the database, querying data in it, database triggers, and stored procedures.
Language of instruction
Number of ECTS credits
Mode of study
Guarantor
Department
Entry knowledge
Rules for evaluation and completion of the course
Mid-term exam passing, realization and presentation/defence of projects in due dates.
In the case of a reported barrier of the mid-term exam and to present/defend a project, a student will be offered a substitute date of the exam or an oral exam, and she/he will be allowed to present/defend the project in a substitute date, respectively.
Aims
Study aids
Prerequisites and corequisites
Basic literature
Recommended reading
Elearning
Classification of course in study plans
branch BIT , 2 year of study, summer semester, compulsory
Lecture
Teacher / Lecturer
Syllabus
Project