Course Details
Relational Database Management Systems
Academic Year 2024/25
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.