Course detail

Databases

FAST-BEA014Acad. year: 2026/2027

  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

Language of instruction

Czech

Number of ECTS credits

2

Mode of study

Not applicable.

Guarantor

doc. Ing. Dalibor Bartoněk, CSc.

Department

Institute of Geodesy (GED)

Entry knowledge

Handling with personal computers.

Rules for evaluation and completion of the course

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

Aims

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

Study aids

Bartoněk, D. Databáze I. Elektronický učební text, 2015.

Korth H.F, Silberschatz, A.: Database System Concepts. Third Edition. McGRAW-HILL. 1996 - prezentace v *.ppt.

Ramakrishnan R.: Database Management Systems. WCB/McGraw-Hill, 1998.

Date C.J.: An Introduction to Database Systems. Sixth edition. Addison-Wesley, 1995.

Pokorný, J.: Databázové systémy a jejich použití v informačních systémech. Academia, Praha, 1992.

Pokorný, J.: Dotazovací jazyky. SCIENCE, Veletiny, 1994.

Pokorný, J.: Databázová abeceda. SCIENCE, Veletiny, 1998.

Riordan, M., R.: Vytváříme relační databázové aplikace. Computer Press, Praha, 2000.

Morkes, D.: Microsoft Access 2000. Computer Press, Praha, 1999.

Prezentace z výuky

Prerequisites and corequisites

Not applicable.

Basic literature

Not applicable.

Recommended reading

Not applicable.

Classification of course in study plans

  • Programme BPC-GK Bachelor's 2 year of study, summer semester, compulsory

Type of course unit

 

Exercise

26 hours, compulsory

Teacher / Lecturer

doc. Ing. Dalibor Bartoněk, CSc.

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.