Course detail

Relational Database Management Systems

FAST-DUB027Acad. year: 2024/2025

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.

Language of instruction

Czech

Number of ECTS credits

Mode of study

Not applicable.

Guarantor

doc. RNDr. Jiří Macur, CSc.

Department

Institute of Computer Aided Engineering and Computer Science (AIU)

Entry knowledge

Basic knowledge and using of operation system especially of filesystem.

Rules for evaluation and completion of the course

Extent and forms are specified by guarantor’s regulation updated for every academic year.

Aims

Not applicable.

Study aids

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Not applicable.

Recommended reading

Not applicable.

Classification of course in study plans

  • Programme DKA-GK Doctoral 1 year of study, summer semester, compulsory-optional
  • Programme DPA-GK Doctoral 1 year of study, summer semester, compulsory-optional
  • Programme DPC-GK Doctoral 1 year of study, summer semester, compulsory-optional
  • Programme DPC-GK Doctoral 1 year of study, summer semester, compulsory-optional

Type of course unit

 

Lecture

39 hod., optionally

Teacher / Lecturer

doc. RNDr. Jiří Macur, CSc.

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.