Přístupnostní navigace
E-application
Search Search Close
Course detail
FIT-IDSeAcad. year: 2023/2024
Fundamentals of database systems (DBS). Conceptual modeling. 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. Development of a database application in modern development and database environment.
Language of instruction
Number of ECTS credits
Mode of study
Guarantor
Department
Offered to foreign students
Entry knowledge
Rules for evaluation and completion of the course
Mid-term exam passing, realization and presentation/defence of projects in due dates.
Aims
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.
Student is able to develop conceptual models of an application domain for database applications. He/she can develop database applications for relational databases, knows the standard database language for relational databases SQL, has experience with some integrated development environment for database applications, and has knowledge of relational database management system fundamentals. He/she receives basic competencies for database administrator's work like user account creation, access rights assignment and performance tuning. Student acquaints with fundamentals of some important functions of advanced database system like transactional processing, concurrency and recovery. Student acquaints with basic English terminology in the subject.
Student will learn how to analyze a given problem in a small team and he/she will learn to design and implement solution of the problem individually. He/she learns to present and defend both partial and final results of the project.
Study aids
Prerequisites and corequisites
Basic literature
Recommended reading
eLearning
Classification of course in study plans
specialization BCH , any year of study, summer semester, recommended
Lecture
Teacher / Lecturer
Syllabus
Project