548-0007/08 – Database Systems (DBS)

Gurantor departmentDepartment of GeoinformaticsCredits6
Subject guarantordoc. Ing. Jiří Horák, Dr.Subject version guarantordoc. Ing. Jiří Horák, Dr.
Study levelundergraduate or graduateRequirementCompulsory
Year1Semestersummer
Study languageCzech
Year of introduction2006/2007Year of cancellation
Intended for the facultiesHGFIntended for study typesFollow-up Master, Bachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
HOR10 doc. Ing. Jiří Horák, Dr.
JUR02 Ing. Lucie Orlíková, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+3
Combined Credit and Examination 6+9

Subject aims expressed by acquired skills and competences

The aim of the subject is to educate students how to create databases, utilise DBMS for solving of different tasks, how to design appropriate data structures.

Teaching methods

Lectures
Tutorials
Project work

Summary

Information system. Data types. DBS. DBMS. 3 layers of structure description. Advantages of DB technology. Architecture of DBS. Internal forms of data storing. Conceptual scheme. ERA diagram. Relationships. UML. Functional analysis, DFD. Network data model, hierarchical data model. Relational data model. RDBMS. Keys, referential integrity.Functional dependency. Normalisation process. Querying. Relational algebra. SQL. QBE. Protection of DBS. Parallel processes. DBS and IS construction. OO databases. Data warehousing. OLAP, multidimensional DB.

Compulsory literature:

Churcher, Clare. Beginning Database Design. Berkeley, CA: Apress, 2007. ISBN 9781590597699.

Recommended literature:

Ricardo C.M.: Database systems: principles, design, and implementation. Macmillan Publ.Comp. New York 1990.

Way of continuous check of knowledge in the course of semester

testing project

E-learning

Další požadavky na studenta

No additional requirements are imposed on the student.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Reality modelling, data processing. Advantages of DB technology. Information system. Data types. DBS. DBMS. 3 layers of structure description. Architecture of DBS. Internal forms of data storing. Conceptual scheme. ERA diagram. Relationships. UML. Functional analysis, DFD. Network data model, hierarchical data model. Relational data model. RDBMS. Keys, referential integrity.Functional dependency. Normalisation process. Querying. Relational algebra. SQL. QBE. Object-oriented DBMS. Protection of DBS. Parallel processes. Data warehousing. OLAP, multidimensional DB. Trends.

Conditions for subject completion

Combined form (validity from: 2012/2013 Winter 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) 17
                Projekt Project 33  17
        Examination Examination 67 (67) 18
                Písemná zkouška Written examination 50  18
                Ústní zkouška Oral examination 17  0
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2019/2020 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics P Czech Ostrava 1 Compulsory study plan
2019/2020 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics K Czech Ostrava 1 Compulsory study plan
2018/2019 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics K Czech Ostrava 1 Compulsory study plan
2018/2019 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics P Czech Ostrava 1 Compulsory study plan
2017/2018 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics P Czech Ostrava 1 Compulsory study plan
2017/2018 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics K Czech Ostrava 1 Compulsory study plan
2016/2017 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics K Czech Ostrava 1 Compulsory study plan
2016/2017 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics P Czech Ostrava 1 Compulsory study plan
2016/2017 (B3646) Geodesy and Cartography (3646R006) Geoinformatics P Czech Ostrava 2 Compulsory study plan
2015/2016 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics P Czech Ostrava 1 Compulsory study plan
2015/2016 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics K Czech Ostrava 1 Compulsory study plan
2014/2015 (B3646) Geodesy and Cartography (3646R006) Geoinformatics P Czech Ostrava 2 Compulsory study plan
2014/2015 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics P Czech Ostrava 1 Compulsory study plan
2014/2015 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics K Czech Ostrava 1 Compulsory study plan
2014/2015 (B3646) Geodesy and Cartography (3646R006) Geoinformatics K Czech Ostrava 2 Compulsory study plan
2013/2014 (B3646) Geodesy and Cartography (3646R006) Geoinformatics K Czech Ostrava 2 Compulsory study plan
2013/2014 (B3646) Geodesy and Cartography (3646R006) Geoinformatics P Czech Ostrava 2 Compulsory study plan
2012/2013 (B3646) Geodesy and Cartography (3646R006) Geoinformatics P Czech Ostrava 2 Compulsory study plan
2012/2013 (B3646) Geodesy and Cartography (3646R006) Geoinformatics K Czech Ostrava 2 Compulsory study plan
2012/2013 (N3646) Geodesy and Cartography (3602T002) Geoinformatics (20) K Czech Ostrava 1 Compulsory study plan
2011/2012 (B3646) Geodesy and Cartography (3646R006) Geoinformatics P Czech Ostrava 2 Compulsory study plan
2011/2012 (B3646) Geodesy and Cartography (3646R006) Geoinformatics K Czech Ostrava 2 Compulsory study plan
2011/2012 (N3646) Geodesy and Cartography (3602T002) Geoinformatics (20) P Czech Ostrava 1 Compulsory study plan
2011/2012 (N3646) Geodesy and Cartography (3602T002) Geoinformatics (20) K Czech Ostrava 1 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner
ECTS - FMG 2016/2017 Full-time English Optional 501 - Study Office stu. block
Subject block without study plan - HGF - P - cs 2016/2017 Full-time Czech Optional HGF - Faculty of Mining and Geology stu. block
O - ECTS FMG 2015/2016 Full-time Czech Optional 501 - Study Office stu. block
O - ECTS FMG - Bc. 2014/2015 Full-time Czech Optional 501 - Study Office stu. block
O - ECTS FMG - Bc. 2013/2014 Full-time Czech Optional 501 - Study Office stu. block
O - ECTS FMG - Bc. 2012/2013 Full-time Czech Optional 501 - Study Office stu. block