Course: Database Systems

« Back
Course title Database Systems
Course code KGI/DATAS
Organizational form of instruction Lecture + Exercise + Seminar
Level of course Bachelor
Year of study not specified
Semester Winter
Number of ECTS credits 10
Language of instruction Czech
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Dobešová Zdena, doc. Ing. Ph.D.
Course content
The key topic is the relational database model. Practices take place in an environment of Microsoft Access database program. Is to practice creating tables, forms, sessions, queries, reports. There are also practiced SQL commands and modeling using CASE studio. Tasks are selected from different regions of geographic information systems (demography, geological database, the geomorphological, environmental database, hydrology). Outline: 1. Basic features of the database system, the concept of entity, attribute, attribute data types (field values) 2. Relationship, the cardinality of relationships, keys (candidate, primary, composite, foreign) 3. Integrity, referential integrity, 4. Types of database models (network, hierarchical, relational) relational data model, 5. ERA diagram and conceptual modeling 6. Indexes, unary operations restrictions and projections, questions, types of questions, normalization, SQL, 7. Definition and use of ODBC 8. ESRI geodatabase (file and personal), subtype definitions, domains 9. Definition connection session geodatabase annotation store 10. Conceptual modeling using ArcGIS Diagrammer 11. Working with geodatabase topology 12. Creation of geometric network in the geodatabase

Learning activities and teaching methods
Monologic Lecture(Interpretation, Training)
  • Preparation for the Exam - 40 hours per semester
  • Homework for Teaching - 42 hours per semester
  • Attendace - 84 hours per semester
Learning outcomes
Students are acquaint with the basic topics from the database technology during the lecture.
The course focuses on the acquisition of knowledge. Define key terms, describe the main approaches to demonstrate theoretical knowledge for solving of problems.
Prerequisites
Application of knowledge from previous studies.

Assessment methods and criteria
Written exam

Student has to prove the knowledge of the subject topics.
Recommended literature
  • Artur, D., Zeidler, M. (2004). Designing Geodatabase, Case Studies in GIS Data Modeling. ESRI Readlans.
  • Dobešová, Z. (2004). Databázové systémy v GIS, skriptum. Vydavatelství UP, Olomouc.
  • Pokorný, J., Halaška, I. (1998). Databázové systémy. Vydavatelství ČVUT.
  • Šimůnek, M. (1999). SQL kompletní průvodce. Grada.


Study plans that include the course
Faculty Study plan (Version) Branch of study Category Recommended year of study Recommended semester
Faculty of Science Geoinformatics and Geography (1) Geography courses 2 Winter