548-0007/09 – Database Systems (DBS)
Gurantor department | Department of Geoinformatics | Credits | 6 |
Subject guarantor | prof. Ing. Jiří Horák, Dr. | Subject version guarantor | prof. Ing. Jiří Horák, Dr. |
Study level | undergraduate or graduate | Requirement | Compulsory |
Year | 1 | Semester | summer |
| | Study language | English |
Year of introduction | 2016/2017 | Year of cancellation | 2022/2023 |
Intended for the faculties | HGF | Intended for study types | Bachelor, Follow-up Master |
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:
Recommended literature:
Way of continuous check of knowledge in the course of semester
testing
project
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.
2) Advantages of DB technology.
3) Information system. Data types. DBS. DBMS.
4) Three layers of structure description.
5) Architecture of DBS. Internal forms of data storing.
6) Conceptual scheme. ERA diagram. Relationships. UML. Functional analysis, DFD.
7) Network data model, hierarchical data model. Relational data model. RDBMS.
8) Keys, referential integrity.Functional dependency. Normalisation process.
9) Querying. Relational algebra. SQL. QBE.
10) Object-oriented DBMS.
11) Protection of DBS. Parallel processes.
12)Data warehousing. OLAP, multidimensional DB. Trends.
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction
Předmět neobsahuje žádné hodnocení.