Course Unit Code | 548-0007/10 |
---|
Number of ECTS Credits Allocated | 4 ECTS credits |
---|
Type of Course Unit * | Choice-compulsory type B |
---|
Level of Course Unit * | Second Cycle |
---|
Year of Study * | First Year |
---|
Semester when the Course Unit is delivered | Summer Semester |
---|
Mode of Delivery | Face-to-face |
---|
Language of Instruction | Czech |
---|
Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
---|
Name of Lecturer(s) | Personal ID | Name |
---|
| HOR10 | prof. Ing. Jiří Horák, Dr. |
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. |
Learning Outcomes of the Course Unit |
---|
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. |
Course Contents |
---|
1) Reality modelling, data processing. Advantages of DB technology.
2) Information system. Classification of information systems.
3) Database system. DBMS and its role.
4) Conceptual scheme. ERA diagram. UML.
5) Review of data types.
6) Relational data model. RDBMS.
7) Integrity constraints.
8) Querying in RDBMS.
9) SQL.QBE.
10) NoSQL databases
11) Spatial database systems.
12) Storage of spatial data in databases
13) Spatial querying, spatial operators according to OGC. |
Recommended or Required Reading |
---|
Required Reading: |
---|
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. |
Pokorný, J., Valenta M.: Databázové systémy. ČVUT, 2020. ISBN 978-80-01-06696-6
Šarmanová J.: Teorie zpracování dat. Skripta VŠB-TUO. 159 stran. 2007.
Pokorný J.: Konstrukce databázových systémů. ČVUT Praha 1998.
Manolopoulos Y., Papadopoulos, Vassilakopoulos M.: Spatial Databases: Technologies, Techniques, Trends. Idea Group Publishing. 340 stran, Hershey, 2005. ISBN 1-59140-387-1. |
Recommended Reading: |
---|
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. |
Dohnal, Pour: Architektury informačních systémů. Ecopress 1997.
Pokorný J.: Databázové systémy a jejich použití v informačních systémech. Academia, 1992.
Dobešová Z: Prostorové databázové systémy. UP Olomouc, 2004.
Ricardo C.M.: Database systems: principles, design, and implementation. Macmillan Publ.Comp. New York 1990. |
Planned learning activities and teaching methods |
---|
Lectures, Tutorials, Project work |
Assesment methods and criteria |
---|
Task Title | Task Type | Maximum Number of Points (Act. for Subtasks) | Minimum Number of Points for Task Passing |
---|
Credit and Examination | Credit and Examination | 100 (100) | 51 |
Credit | Credit | 33 (33) | 17 |
písemné testy | Written test | 12 | 0 |
docházka a řešení doplňkových úkolů | Other task type | 21 | 0 |
Examination | Examination | 67 (67) | 18 |
písemná zkouška | Written examination | 50 | 18 |
ústní zkouška | Oral examination | 17 | 0 |