548-0007/03 – 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
Year3Semesterwinter
Study languageCzech
Year of introduction1999/2000Year of cancellation2009/2010
Intended for the facultiesFBIIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
ARD01 Ing. Jiří Ardielli
HOR10 prof. Ing. Jiří Horák, Dr.
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 6+6

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

E-learning

Other requirements

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1) Modelování reality a automatizované zpracování dat. Výhody databázové technologie. 2) Informační systém (IS), základní dělení IS. Databázový systém (DBS). SŘBD a jeho funkce. Architektura DBS. 3) Tři úrovně struktury dat. Konceptuální schéma. ERA diagram. Vztahy mezi entitami. Jiné modely k.s. 4) Funkční analýza. Diagram toku dat. UML. 5) Přehled datových typů. Interní formy uložení dat. 6) Síťový a hierarchický databázový model. Relační datový model, relační DBS a jeho podmínky. 7) Klíče a integrita relačních DBS. Funkční závislosti. Normalizace relačních tabulek. 8) Dotazování nad relační DB. Relační algebra. Procedurální a neprocedurální jazyky. 9) SQL. QBE. 10) Objektově orientované databáze. 11) Ochrana DBS. 12) Řízení paralelních procesů v databázích. 13) Datové sklady, koncept OLAP.

Conditions for subject completion

Full-time form (validity from: 1960/1961 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)		Min. number of pointsMax. počet pokusů
Exercises evaluation and Examination Credit and Examination 100 (100) 51 3
        Exercises evaluation Credit 45 (45) 0 3
                Project Project 22  0 3
                Written exam Written test 8  0 3
                Other task type Other task type 15  0 3
        Examination Examination 55 (55) 0 3
                Written examination Written examination 40  0 3
                Oral Oral examination 15  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 yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2005/2006 (M3908) Fire Protection and Industrial Safety (3908T006) Fire Protection Engineering and Industrial Safety P Czech Ostrava 3 Choice-compulsory study plan
2005/2006 (M2102) Mineral Raw Materials (3902T006) Automation and Computers in Raw Materials Treatment Industry P Czech Ostrava 3 Choice-compulsory study plan
2004/2005 (M3908) Fire Protection and Industrial Safety (3908T006) Fire Protection Engineering and Industrial Safety P Czech Ostrava 3 Choice-compulsory study plan
2004/2005 (M2102) Mineral Raw Materials (3902T006) Automation and Computers in Raw Materials Treatment Industry P Czech Ostrava 2 Choice-compulsory study plan
2004/2005 (M2102) Mineral Raw Materials (3902T006) Automation and Computers in Raw Materials Treatment Industry P Czech Ostrava 3 Choice-compulsory study plan
2003/2004 (M2102) Mineral Raw Materials (3902T006) Automation and Computers in Raw Materials Treatment Industry P Czech Ostrava 2 Choice-compulsory study plan
2003/2004 (M2102) Mineral Raw Materials (3902T006) Automation and Computers in Raw Materials Treatment Industry P Czech Ostrava 3 Choice-compulsory study plan
2003/2004 (M3908) Fire Protection and Industrial Safety (3908T006) Fire Protection Engineering and Industrial Safety P Czech Ostrava 3 Choice-compulsory study plan
2002/2003 (M2102) Mineral Raw Materials (3902T006) Automation and Computers in Raw Materials Treatment Industry P Czech Ostrava 2 Choice-compulsory study plan
2002/2003 (M3908) Fire Protection and Industrial Safety (3908T006) Fire Protection Engineering and Industrial Safety P Czech Ostrava 3 Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction

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