Course Details

Database Systems

Academic Year 2025/26

NUB019 course is part of 1 study plan

​ NPC-GK Winter Semester 1st year

Course Guarantor

Ing. Michal Vojkůvka, Ph.D.

Institute

Institute of Computer Aided Engineering and Computer Science

Language of instruction

Czech

Credits

4 credits

Semester

winter

Forms and criteria of assessment

course-unit credit

Offered to foreign students

Not to offer

Course on BUT site

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

Lecture

13 weeks, 1 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.

Exercise

13 weeks, 2 hours/week, compulsory

Syllabus

  • 1. Comparison of work with data in demo application between application user interface and underlying database management system interface.
  • 2. Using simple tools for information extraction (ordering a filtering). Data imports and exports.
  • 3. Table structure definition, data types, integrity constraints implementation.
  • 4.–6. Creating queries for information extraction.
  • 7.–9. Relationships between tables, complex queries, SQL language notation.
  • 10.–12. Assigning of themes for projects, project consultations.
  • 13. Projects submission, final test.