548-0018/03 – Database Management Systems Applications (ASRBD)

Gurantor departmentDepartment of GeoinformaticsCredits3
Subject guarantorprof. Ing. Jiří Horák, Dr.Subject version guarantorprof. Ing. Jiří Horák, Dr.
Study levelundergraduate or graduateRequirementChoice-compulsory
Year2Semestersummer
Study languageCzech
Year of introduction2007/2008Year of cancellation2022/2023
Intended for the facultiesHGFIntended for study typesBachelor, Follow-up Master
Instruction secured by
LoginNameTuitorTeacher giving lectures
HOR10 prof. Ing. Jiří Horák, Dr.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit 0+2
Part-time Credit 0+6

Subject aims expressed by acquired skills and competences

The aim of the subject is to get acquainted students how to solve selected tasks of data analysis, to design some special data structures (OLAP, etc.), analyse given situation and to propose effective procedures of processing.

Teaching methods

Individual consultations
Tutorials
Project work

Summary

Data modelling. Functional dependency, relation scheme design, normalisation process. CASE modelling. ODBC. Data import, data processing, data export. Exploratory data analysis in DB environment. User definition and access rights. Forms development. reports development. Macros, programming modules. Case study in powerful RDBMS.

Compulsory literature:

Teorey T., Lightstone S., Nadeau T: Database modelling and design: Logical design. Elsevier. ISBN 978-0-12-685352-0

Recommended literature:

PONNIAH P.: Database design and development. Wiley, 2003.

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. Students also work on individual tasks. Tasks are frequently based on understanding of previous, simpler tasks.

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:

Data modelling. Functional dependency, relation scheme design, normalisation process. CASE modelling. ODBC. Data import, data processing, data export. Exploratory data analysis in DB environment. User definition and access rights. Forms development. reports development. Macros, programming modules. Case study in powerful RDBMS.

Conditions for subject completion

Full-time form (validity from: 2012/2013 Winter semester, validity until: 2022/2023 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Exercises evaluation Credit 85 (85) 85 3
        Project Project 70  0 3
        Other task type Other task type 15  0 3
Mandatory attendence participation: according to the valid study regulations

Show history

Conditions for subject completion and attendance at the exercises within ISP: The exercises are individual based on a semester project which has to be completed to the end of the exam period for the given semester.

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2022/2023 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics P Czech Ostrava 2 Choice-compulsory study plan
2021/2022 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics P Czech Ostrava 2 Choice-compulsory study plan
2021/2022 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics K Czech Ostrava 2 Choice-compulsory study plan
2020/2021 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics K Czech Ostrava 2 Choice-compulsory study plan
2020/2021 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics P Czech Ostrava 2 Choice-compulsory study plan
2019/2020 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics P Czech Ostrava 2 Choice-compulsory study plan
2019/2020 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics K Czech Ostrava 2 Choice-compulsory study plan
2018/2019 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics P Czech Ostrava 2 Choice-compulsory study plan
2018/2019 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics K Czech Ostrava 2 Choice-compulsory study plan
2017/2018 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics P Czech Ostrava 2 Choice-compulsory study plan
2017/2018 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics K Czech Ostrava 2 Choice-compulsory study plan
2016/2017 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics K Czech Ostrava 2 Choice-compulsory study plan
2016/2017 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics P Czech Ostrava 2 Choice-compulsory study plan
2015/2016 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics P Czech Ostrava 2 Choice-compulsory study plan
2015/2016 (B1316) Geodesy, Cartography and Geoinformatics (3646R006) Geoinformatics K Czech Ostrava 2 Choice-compulsory study plan
2014/2015 (B3646) Geodesy and Cartography (3646R006) Geoinformatics P Czech Ostrava 2 Choice-compulsory study plan
2014/2015 (B3646) Geodesy and Cartography (3646R006) Geoinformatics K Czech Ostrava 2 Choice-compulsory study plan
2013/2014 (B3646) Geodesy and Cartography (3646R006) Geoinformatics K Czech Ostrava 2 Choice-compulsory study plan
2013/2014 (B3646) Geodesy and Cartography (3646R006) Geoinformatics P Czech Ostrava 2 Choice-compulsory study plan
2012/2013 (B3646) Geodesy and Cartography (3646R006) Geoinformatics P Czech Ostrava 2 Choice-compulsory study plan
2012/2013 (B3646) Geodesy and Cartography (3646R006) Geoinformatics K Czech Ostrava 2 Choice-compulsory study plan
2011/2012 (B3646) Geodesy and Cartography (3646R006) Geoinformatics P Czech Ostrava 2 Choice-compulsory study plan
2011/2012 (B3646) Geodesy and Cartography (3646R006) Geoinformatics K Czech Ostrava 2 Choice-compulsory study plan
2010/2011 (B3646) Geodesy and Cartography (3646R006) Geoinformatics P Czech Ostrava 2 Choice-compulsory study plan
2010/2011 (B3646) Geodesy and Cartography (3646R006) Geoinformatics K Czech Ostrava 2 Choice-compulsory study plan
2009/2010 (B3646) Geodesy and Cartography (3646R006) Geoinformatics P Czech Ostrava 2 Choice-compulsory study plan
2009/2010 (B3646) Geodesy and Cartography (3646R006) Geoinformatics K Czech Ostrava 2 Choice-compulsory study plan
2008/2009 (B3646) Geodesy and Cartography (3646R006) Geoinformatics K Czech Ostrava 2 Choice-compulsory study plan
2008/2009 (B3646) Geodesy and Cartography (3646R006) Geoinformatics P Czech Ostrava 2 Choice-compulsory study plan
2007/2008 (B3646) Geodesy and Cartography (3646R006) Geoinformatics P Czech Ostrava 3 Choice-compulsory study plan
2007/2008 (B3646) Geodesy and Cartography (3646R006) Geoinformatics K Czech Ostrava 2 Choice-compulsory study plan
2007/2008 (B3646) Geodesy and Cartography (3646R006) Geoinformatics P Czech Ostrava 2 Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2018/2019 Summer
2014/2015 Summer
2009/2010 Summer