Course Details
Relational Database Management Systems
Academic Year 2025/26
Course Guarantor
Institute
Language of instruction
Czech
Credits
7 credits
Semester
summer
Forms and criteria of assessment
examination
Offered to foreign students
Not to offer
Course on BUT site
Lecture
13 weeks, 3 hours/week, elective
Syllabus
- 1. Data modelling, current approaches
- 2. Relational model for database management, relation and its representation
- 3. Relational algebra
- 4. Conceptual modelling
- 5.–6. Tables, relationships, primary and foreign keys, E-R diagrams
- 7. Indexing
- 8. Reference integrity
- 9. SQL language, DDL and DML commands
- 10. Complex SELECT queries
- 11. Views, stored procedures in TSQL. Transactions and access management.
- 12. Overview of current database management systems: Oracle, MySQL, SQL Server, ISAM
- 13. Sample analysis of simple information system.