Skip to main content
Skip header
Terminated in academic year 2017/2018

Database Systems

Type of study Follow-up MasterMasterBachelor
Language of instruction Czech
Code 714-0393/01
Abbreviation DBS
Course title Database Systems
Credits 2
Coordinating department Department of Mathematics and Descriptive Geometry
Course coordinator Mgr. Petr Otipka, Ph.D.

Subject syllabus

Lectures
1. Fundamental concept definition.
2. Data levels organisation.
3. Data structure.
4. Data storage.
5. Forms of data organisation.
6. Data organisation in database management systems.
7. The basis of sets theory. Mathematical principle of relational databases.
8. Operations over the relations.
9. The basis of the relational database systems.
10.Structured query language (SQL) and the elementary commands.

Practices
1. The data storage methods. The file types and relationships among them.
2. The system task modes: dialogs and programs.
3. The databases file structure definition and its change.
4. The data insertion into database files, the data changes.
5. Expressions and commands.
6. Fundamental input commands.
7. Multiple data manipulation commands.
8. Interactive form creation, the usage of it.
9. Interactive report creation, the usage of it.
10.The sample of programming.

Literature

Microsoft Access: Users Guide. Microsoft Corporation, Redmond(Wa,USA), 1999.

Advised literature

Miller, H. J. - Han, J.: Geographic Data Mining and Knowledge Discovery. ISBN 203468023. Taylor & Francis, London, 2001.
Ponniah, P.: Database Design and Development. John Wiley & Sons, London, 2003.