PřF:Z3104 Geodatabases - Course Information
Z3104 Geodatabases
Faculty of ScienceAutumn 2019
- Extent and Intensity
- 1/2/0. 3 credit(s). Type of Completion: z (credit).
- Teacher(s)
- Mgr. Karel Staněk, Ph.D. (lecturer)
Mgr. Radim Lískovec (seminar tutor)
Mgr. Filip Málek (seminar tutor) - Guaranteed by
- Mgr. Karel Staněk, Ph.D.
Department of Geography – Earth Sciences Section – Faculty of Science
Contact Person: Mgr. Karel Staněk, Ph.D.
Supplier department: Department of Geography – Earth Sciences Section – Faculty of Science - Timetable
- Mon 15:00–15:50 Z5,02004
- Timetable of Seminar Groups:
Z3104/02: Wed 13:00–14:50 Z1,01001b, R. Lískovec, F. Málek
Z3104/03: Tue 8:00–9:50 Z1,01001b, R. Lískovec, F. Málek - Prerequisites (in Czech)
- Z2062p Cartography
- Course Enrolment Limitations
- The course is only offered to the students of the study fields the course is directly associated with.
The capacity limit for the course is 54 student(s).
Current registration and enrolment status: enrolled: 0/54, only registered: 0/54 - fields of study / plans the course is directly associated with
- Applied Geography and Geoinformatics (programme PřF, B-AG, specialization Geoinformatics and Regional Development)
- Applied Geography and Geoinformatics (programme PřF, B-AG, specialization Geoinformatics and Sustainable Development)
- Physical Geography (programme PřF, B-GEK)
- Geographical Cartography and Geoinformatics (programme PřF, B-GEK)
- Geographical Cartography and Geoinformatics (programme PřF, B-GK)
- Geography (programme PřF, B-GK, specialization Physical Geography)
- Geography (programme PřF, B-GK, specialization Human Geography)
- Geoinformatics and Regional Development (programme PřF, B-GEK)
- Geoinformatics and Sustainable Development (programme PřF, B-GEK)
- Social Geography (programme PřF, B-GEK)
- Course objectives
- The main objectives of the course are the following: acquainting students with the database basic with respect to their role in GIS. students acquire query and definition language SQL in relational and post-relational databases making students aware of manipulation with spatial data in above mentioned databases making students aware of document oriented databases
- Learning outcomes
- - to compile a general database query in SQL language
- to design a relational database structure with limited volume of entities and relationships
- to implement data dictionary of the designed database in SQL language
- to compile a spatial database query in SQL language - Syllabus
- 1. Basic database models 2. Principles of relational and postrelational DBMS 3. Relational database design (Chen diagram, data types, keys, standard forms) 4. Definition part of SQL 5. Query part of SQL - introduction 6. Query part of SQL - functions and aggregates 7. Query part of SQL - theta join 8. Document oriented databases 9. Document oriented databases query languages 10. Spatial data in databases 11. Computer literacy - Networks and Internet 12. Computer literacy - Computer security 13. Computer literacy - Legal issues Exercises 1. Database creation and management 2. Database definition 3. INSERT command 4. UPDATE, Constrains a ALTER TABLE 5. Base of querrying SQL 6. GROUP BY and Aggregating functions 7. Selections from multiple tables I. 8. elections from multiple tables II. 9. Nested queries 10. Database design
- Literature
- Teaching methods
- lectures and practical exercises
- Assessment methods
- final written exam
- Language of instruction
- Czech
- Further comments (probably available only in Czech)
- Study Materials
The course is taught annually.
- Enrolment Statistics (Autumn 2019, recent)
- Permalink: https://is.muni.cz/course/sci/autumn2019/Z3104