548-0007/10 – Database Systems (DBS)

Gurantor departmentDepartment of GeoinformaticsCredits4
Subject guarantorprof. Ing. Jiří Horák, Dr.Subject version guarantorprof. Ing. Jiří Horák, Dr.
Study levelundergraduate or graduateRequirementChoice-compulsory type B
Year1Semestersummer
Study languageCzech
Year of introduction2020/2021Year of cancellation
Intended for the facultiesHGFIntended for study typesFollow-up Master, Bachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
HOR10 prof. 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+2
Part-time Credit and Examination 8+8

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. Teorey T., Lightstone S., Nadeau T: Database modelling and design: Logical design. Elsevier. ISBN 978-0-12-685352-0 Manolopoulos Y., Papadopoulos, Vassilakopoulos M.: Spatial Databases: Technologies, Techniques, Trends. Idea Group Publishing. 340 stran, Hershey, 2005. ISBN 1-59140-387-1. Yeung A.K.W, Hall G.B: Spatial Database Systems. Desing, Implementation and Project Management. Springer, Dordrecht, 2007. ISBN 10-1-4020-5393-2. 553 pages.

Recommended literature:

Ricardo C.M.: Database systems: principles, design, and implementation. Macmillan Publ.Comp. New York 1990. Adam Nabil R., Gangopadhyay Aryya: Database Issues in Geographic Information Systems. Kluwer, 2.vydání, 1998. Rigaux P., Scholl M., Voisard A.: Spatial Databases with Application to GIS. Kaufmann, San Francisco, 2002. ISBN 1-55860-588-6. 410 pages. Rajaraman A., Ullman J., 2011. Mining of Massive Datasets. Cambridge University Press. ISBN 9781107015357.

Way of continuous check of knowledge in the course of semester

Students are asked about knowledge from areas that they should have already known from previous lectures. During the semester students must pass 2 interim written tests. They must pass final writing and oral exam.

E-learning

Other requirements

No additional requirements are imposed on the student.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1) Reality modelling, data processing. Advantages of DB technology. 2) Information system. Classification of information systems. 3) Database system. DBMS and its role. 4) Conceptual scheme. ERA diagram. UML. 5) Review of data types. 6) Relational data model. RDBMS. 7) Integrity constraints. 8) Querying in RDBMS. 9) SQL. 10) Querying with QBE. 11) No-SQL databases 12) Spatial database systems. 13) Storage of spatial data in databases 14) Spatial querying, spatial operators according to OGC.

Conditions for subject completion

Full-time form (validity from: 2020/2021 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Credit and Examination Credit and Examination 100 (100) 51
        Credit Credit 33 (33) 17
                písemné testy Written test 12  0
                docházka a řešení doplňkových úkolů Other task type 21  0
        Examination Examination 67 (67) 18
                písemná zkouška Written examination 50  18
                ústní zkouška Oral examination 17  0
Mandatory attendence parzicipation: according to the valid study regulations

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2022/2023 (N0724A290013) Water – Strategic Resource K Czech Ostrava 1 Choice-compulsory type B study plan
2022/2023 (N0724A290013) Water – Strategic Resource P Czech Ostrava 1 Choice-compulsory type B study plan
2021/2022 (N0724A290013) Water – Strategic Resource P Czech Ostrava 1 Choice-compulsory type B study plan
2021/2022 (N0724A290013) Water – Strategic Resource K Czech Ostrava 1 Choice-compulsory type B study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner