545-0117/05 – Database Systems (DBS)

Gurantor department	Department of Economics and Control Systems	Credits	5
Subject guarantor	Ing. Filip Beneš, Ph.D.	Subject version guarantor	prof. Ing. Jiří Horák, Dr.
Study level	undergraduate or graduate	Requirement	Compulsory
Year	2	Semester	winter
		Study language	Czech
Year of introduction	1997/1998	Year of cancellation	2002/2003
Intended for the faculties	HGF	Intended for study types	Master

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

Subject aims expressed by acquired skills and competences

The objective of subject is development of basic questions and facilitys in the area of modelling of reality with a view to proposal and creating of database systems (DBS). Students will informed about history of data processing, basic terminology in the area of databases, data types, particular database models and ways of theirs creation. In practical part students will informed about proposal and physical realization of database in environment of software Microsoft Access. At the close students create semestral project intent on proposal and realization of database.

Teaching methods

Lectures
Tutorials
Project work

Summary

Modelování reality. Informační systém. Datové typy. Databázový systém(DBS). SŘBD a jeho funkce. Tři úrovně struktury DBS. Výhody databázové technologie. Architektura DBS. Interní formy uložení dat. Konceptuální schéma. ERA diagram. Vztahy mezi entitami. Jiné modely k.s. Funkční analýza. Diagram toku dat. Síťový datový model, síťové DBS. Hierarchický datový model, hierarchické DBS. Relační datový model, relační DBS a jeho podmínky. Klíče a integrita relačních DBS. Funkční závislosti. Normalizace relačních tabulek. Dotazování nad relační DB. SQL, QBE. Ochrana DBS. Řízení paralelních procesů v databázích. Přístup k výstavbě DBS a IS.

Compulsory literature:

1. SIMSION, G.; WEST, M.; WITT, G.: Data Modeling Essential. Elsevier Science & Technology, 2004, 560 pages, ISBN: 978-0-12-644551-0. 2. BALTER, A.: Access 2013 Absolute Beginner’s Guide. Pearson Education, Inc., 2013, 388 pages, ISBN: 978-0-7897-4871-3.

Recommended literature:

1. VINE, M.: Microsoft Access VBA Programming for the Absolute Beginner. Thomson Course Technology, 2002, 328 pages, ISBN: 1-59200-723-6.

Way of continuous check of knowledge in the course of semester

E-learning

Other requirements

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. Data a informace. Modelování reality. Informační systém. Rozdělení IS. 2. Jednoduché datové typy, složené datové typy. Dynamické datové struktury. 3. Historie zpracování dat. Databázový systém (DBS). SŘBD a jeho funkce. Tři úrovně struktury dat. Výhody databázové technologie.

Conditions for subject completion

Full-time form (validity from: 1960/1961 Summer semester)

Task name	Type of task	Max. number of points (act. for subtasks)	Min. number of points	Max. počet pokusů
Exercises evaluation and Examination	Credit and Examination	100 (145)	51	3
Examination	Examination	100	0	3
Exercises evaluation	Credit	45	0	3

Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic year	Programme	Branch/spec.	Spec.	Zaměření	Form	Study language	Tut. centre	Year	W	S	Type of duty
2001/2002	(M3646) Geodézie a kartografie	(3602T002) Geoinformatics			P	Czech	Ostrava	2			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í.