Course Details

Relational Database Management Systems

Academic Year 2024/25

DUB027 course is part of 4 study plans

DKA-GK Summer Semester 1st year

DPA-GK Summer Semester 1st year

DKC-GK Summer Semester 1st year

DPC-GK Summer Semester 1st year

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.