541-0526/01 – Database Systems ()

Gurantor departmentDepartment of Geological EngineeringCredits4
Subject guarantorDoc. PaedDr. Vladimír Homola, Ph.D.Subject version guarantorDoc. PaedDr. Vladimír Homola, Ph.D.
Study levelundergraduate or graduateRequirementChoice-compulsory
Year2Semestersummer
Study languageCzech
Year of introduction1997/1998Year of cancellation2009/2010
Intended for the facultiesHGFIntended for study typesMaster
Instruction secured by
LoginNameTuitorTeacher giving lectures
HOM50 Doc. PaedDr. Vladimír Homola, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 1+3

Subject aims expressed by acquired skills and competences

Teaching methods

Summary

The subject introduces to basics of professional computer data storing and processing, to database systems. Although two most available models are described, the relational database model is preferred. The different data types are demonstrated regarding to theirs memory forms, ranges, access methods, and operations. Query languages, SQL in particular, are the significant partition of the subject. The subject is practises in computer laboratory, the environment of concrete relational database system is used for own data modelling.

Compulsory literature:

Recommended literature:

Way of continuous check of knowledge in the course of semester

E-learning

Další požadavky na studenta

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Přednášky: Definice základních pojmů. Úvod do teorie grafů. Úrovně organizace dat. Struktura dat. Struktura uložení. Formy organizace dat. Organizace dat v systémech řízení báze dat. Cvičení: Způsoby uložení dat, typy souborů a vazby mezi nimi. Režimy práce se systémem; dialog a program. Definice struktury databázového souboru a její změna. Naplnění databázového souboru a změny hodnot. Výrazy a funkce. Základní výstupní příkazy. Příkazy pro hromadnou manipulaci s daty. Interaktivní tvorba formátu obrazovky. Interaktivní tvorba výstupní sestavy. Nastavení parametrů databázového prostředí. Ukázka programování.

Conditions for subject completion

Full-time form (validity from: 1960/1961 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (100) 51
        Exercises evaluation Credit 33 (33) 0
                Other task type Other task type 33  0
        Examination Examination 67 (67) 0
                Oral Oral examination 67  0
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2004/2005 (M2110) Geological Engineering (2101T003) Geological Engineering P Czech Ostrava 2 Choice-compulsory study plan
2003/2004 (M2110) Geological Engineering (2101T003) Geological Engineering P Czech Ostrava 2 Choice-compulsory study plan
2002/2003 (M2110) Geological Engineering (2101T003) Geological Engineering P Czech Ostrava 2 Choice-compulsory study plan
2001/2002 (M2110) Geological Engineering (2101T003) Geological Engineering P Czech Ostrava 2 Choice-compulsory study plan
2000/2001 (M2110) Geological Engineering (2101T003) Geological Engineering P Czech Ostrava 2 Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner