Course Details

Database Systems

Academic Year 2025/26

NUB017 course is part of 2 study plans

​ NPC-SIK Summer Semester 1st year

​ NPC-MI Summer 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

summer

Forms and criteria of assessment

course-unit credit and examination

Offered to foreign students

Not to offer

Course on BUT site

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

Lecture

13 weeks, 2 hours/week, elective

Syllabus

  • 1. Basic concepts, data base management systems, starting principles, database systems classification.
  • 2. Data models, relation as the set and its representation in memory.
  • 3. Relational algebra and calculus.
  • 4. Conceptual modeling, database normalization, E-R diagrams and their transformation into the system data base.
  • 5. Modeling of relationships between entities, primary and foreign keys, associative entities.
  • 6. Data integrity and consistency, referential integrity, methods of enforcement.
  • 7. Basic internal algorithms of databases, indexing, B-trees, hashing, levels of data locking.
  • 8. The language SQL, commands of subsets DDL and DML.
  • 9. Construction of the complex command SELECT.
  • 10. Views, functions, stored procedures and triggers, hosting language T-SQL. Database cursor. Transaction processing and access control.
  • 11. Modern database systems Oracle, MySQL, MS SQL, ISAM systems, network architecture, ODBC interface.
  • 12.–13. Data analysis and implementation of the information system in three tiers architecture.

Exercise

13 weeks, 2 hours/week, compulsory

Syllabus

  • 1. User environment of the selected data management system. Tools for data structure definition, relationships, and information searching.
  • 2. Configuration of the tables, data types, data interpretation formats, setting of integrity constraints and business rules.
  • 3. SQL SELECT command and its representation in system of forms environment.
  • 4. Data grouping, aggregates, filtering by their properties.
  • 5. Inner and outer data joins, searching in related entities.
  • 6. Commands for SQL data manipulation. Using the relations while data changing.
  • 7. Instruments for configuration of data interpretation. Settings of output data format, data constraints and rules.
  • 8. Using data enumerators and data links for data management.
  • 9. Import and export data, using of public data warehouses, interface ODBC.
  • 10. Working in the environment of the hosting language. Program for batch processing using the database cursor.
  • 11.–12. User interface design for viewing and managing data.
  • 13. Evaluation of individual tasks and knowledge testing.