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

Gurantor department	Department of Geoinformatics	Credits	3
Subject guarantor	prof. Ing. Jiří Horák, Dr.	Subject version guarantor	prof. Ing. Jiří Horák, Dr.
Study level	undergraduate or graduate	Requirement	Choice-compulsory
Year	2	Semester	summer
		Study language	English
Year of introduction	2016/2017	Year of cancellation	2022/2023
Intended for the faculties	HGF	Intended for study types	Follow-up Master, Bachelor

Instruction secured by
Login	Name	Tuitor	Teacher giving lectures
HOR10	prof. Ing. Jiří Horák, Dr.

Extent of instruction for forms of study
Form of study	Way of compl.	Extent
Full-time	Credit	0+2

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:

1) Data modelling. 2) Functional dependency, relation scheme design, normalisation process. 3) Database design principles. 4) Data import, data processing, data export. 5) CASE modelling, application. 6) Exploratory data analysis in DB environment. 7) User definition and access rights. 8) Programming modules. 9) Case study 10) Principles of data design and processsing in large DBMS.

Conditions for subject completion

Full-time form (validity from: 2016/2017 Summer semester, validity until: 2022/2023 Summer semester)

Task name	Type of task	Max. number of points (act. for subtasks)	Min. number of points	Max. počet pokusů
Credit	Credit			3

Valid from	Valid until	Mandatory attendence participation
Nov 9, 2022 5:22:44 PM	Nov 10, 2022 1:00:16 PM	according to the valid study regulations

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

Valid from	Valid until	Conditions for subject completion and attendance at the exercises within ISP
Nov 9, 2022 5:22:44 PM	Nov 10, 2022 1:00:16 PM	Materials for an individual study are available at http://homel.vsb.cz/~hor10/Vyuka/ where you can find also topics for the exam. Consultations (both personal and online) with the lecturer are possible. 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. The exam is conducted only in person.

Occurrence in study plans

Academic year	Programme	Branch/spec.	Form	Study language	Tut. centre	Year	Type of duty
2021/2022	(B1316) Geodesy, Cartography and Geoinformatics	(3646R006) Geoinformatics	P	English	Ostrava	2	Choice-compulsory	study plan
2020/2021	(B1316) Geodesy, Cartography and Geoinformatics	(3646R006) Geoinformatics	P	English	Ostrava	2	Choice-compulsory	study plan
2019/2020	(B1316) Geodesy, Cartography and Geoinformatics	(3646R006) Geoinformatics	P	English	Ostrava	2	Choice-compulsory	study plan
2018/2019	(B1316) Geodesy, Cartography and Geoinformatics	(3646R006) Geoinformatics	P	English	Ostrava	2	Choice-compulsory	study plan
2017/2018	(B1316) Geodesy, Cartography and Geoinformatics	(3646R006) Geoinformatics	P	English	Ostrava	2	Choice-compulsory	study plan
2016/2017	(B1316) Geodesy, Cartography and Geoinformatics	(3646R006) Geoinformatics	P	English	Ostrava	2	Choice-compulsory	study plan

Occurrence in special blocks

Block name	Academic year	Form of study	Study language	Year	W	S	Type of block	Block owner

Assessment of instruction

Předmět neobsahuje žádné hodnocení.