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

Database technology fundamentals, terminology, data modelling.
Relational data model, relation algebra, data integrity.
Conceptual modelling, Entition-Relationship diagrams.
RDBMS languages, SQL language.
RDBMS architecture.
ISAM and SQL systems (MS Access, MS SQL2000 Server).
Practices of analytical skills. As a project students develop a simple database system in chosen production branch.

Credits

7 credits

Language of instruction

Czech

Semester

summer

Course Guarantor

doc. RNDr. Jiří Macur, CSc.

Institute

Institute of Computer Aided Engineering and Computer Science

Forms and criteria of assessment

examination

Entry Knowledge

Basic knowledge and using of operation system especially of filesystem.

Offered to foreign students

Not to offer

Course on BUT site

https://www.vut.cz/en/students/courses/detail/283656

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.