Course detail

Databases I

FAST-GE51Acad. year: 2024/2025

Basic concepts of database technology, ANSI/SPARC levels, data models, architecture of database systems (DBS).
Coceptual modelling, E/R diagrams,languges of relation DBS, SQL language.
Relational data model, theory of dependence.
Interior data organization, indexing, hashing.
Security and integrity of data, trigery.
Distributed DBS, architecture client- server, current trends of database technology development, postrelation systems.
Databases in GIS. Database systems Mircosoft Access, Oracle SQL plus.

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

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Date, C.F.: An Introduction to Database System. Addison-Wesley, 1995. (EN)
Korth H.,F. Silberschatz A.: Database System Concepts. Mc Graw-Hill, 1996. (EN)
Pokorný J.: Databázová abeceda. Science Valetiny, 1998. (CS)

Recommended reading

Not applicable.

Type of course unit

 

Exercise

26 hod., compulsory

Teacher / Lecturer

doc. Ing. Dalibor Bartoněk, CSc.

Syllabus

• fundamental terms of database technology • E/R diagrams, relational database languages, SQL. • relational data model, theory of dependence, normal forms. • Internal data organization, indexing, hashing. • Security and data integrity, triggers, transactions • Database in GIS • Database systems Mircosoft Access, Oracle, SQL plus