Course Details

Databases

Academic Year 2026/27

BEA014 course is part of 1 study plan

​ BPC-GK Summer Semester 2nd year

  1. Introduction to database technology, basic concepts.
  2. Conceptual modeling and database design, data models, E/R diagrams.
  3. Transformation of data model into relational database tables.
  4. Dependency theory, normal forms.
  5. Relational algebra, SQL language (DDL, DML).
  6. Internal data organization, indexing, hashing.
  7. Transaction processing.
  8. Web databases (PHP + MySQL).
  9. Mircosoft Access database system – exercises.
  10. Credit

Credits

2 credits

Language of instruction

Czech

Semester

summer

Course Guarantor

doc. Ing. Dalibor Bartoněk, CSc.

Institute

Institute of Geodesy

Forms and criteria of assessment

course-unit credit

Entry Knowledge

Handling with personal computers.

Aims

Theory of relation database systems. Creation tables of relations, queries. Basic of SQL language.
Ability to design a single database in MS Access.

Offered to foreign students

Not to offer

Course on BUT site

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

Exercise

13 weeks, 2 hours/week, compulsory

Syllabus

  • 1. Fundamental terms of database technology.
  • 2. E/R diagrams, relational database languages, SQL.
  • 3. Relational data model, theory of dependence, normal forms.
  • 4. Internal data organization, indexing, hashing.
  • 5. Security and data integrity, triggers, transactions.
  • 6. Database in GIS.
  • 7.–10. Database systems Mircosoft Access, Oracle, SQL plus.