Course: Database systems 1

« Back
Course title Database systems 1
Course code KGI/DASY1
Organizational form of instruction Lecture + Exercise
Level of course Bachelor
Year of study not specified
Semester Winter
Number of ECTS credits 5
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)
  • Snášel Václav, prof. RNDr. CSc.
  • Dobešová Zdena, doc. Ing. Ph.D.
Course content
Relational database model is explained as first. Practices are performed in the database program Microsoft Access in the computer laboratory. Creation tables, forms, broadcasts, inquiris, lineups and control menu are practised. Instruction to the SQL and modelling with the instrument of CASE studio are practised in the course. Examples are choosen from the different areas of the geography information systems (demography, geological database, geomorfological database, environmental database, hydrology). Sylabus: The basic attribute database system. Concept entity, attribute, dates types of attributes (line of value), relations, dedrees of relations, meaning of key, type of keys (candidates, primary, composite, foreign), integrity, reference integrity, types of database models (net's, hiererchical, relational), relational date's model, E-R diagram, indexes, unary operation restriction and projection, filters and questions, type of questions, normalization, language SQL.

Learning activities and teaching methods
Lecture
Learning outcomes
Students are acquaint with the basic topics from the database technology during the lecture.
Knowledge Define the main ideas and conceptions of the subject, describe the main approaches of the studied topics, recall the theoretical knowledge for solution of model problems.
Prerequisites
unspecified

Assessment methods and criteria
Mark

Recommended literature
  • Dobešová, Z. (2004). Databázové systémy v GIS, skriptum. Vydavatelství UP, Olomouc, 76 s.
  • Fikáček, I., Rozehnal, I., Fikáček, M. (1999). Microsoft Access 2000, podrobný průvodce začínajícího uživatele. Grada.
  • Kořínek, M. (2000). Microsoft Access 2000. Koop České Budějovice.
  • Pokorný, J., Halaška, I. (1998). Databázové systémy. Vydavatelství ČVUT.
  • Riordan Rebecca, M. (2001). Vytváříme relační databázové aplikace. Computer Press.
  • Šimůnek, M. (1999). SQL kompletní průvodce. Grada.
  • Voženílek, V. (2001). Geografické informační systémy I - pojetí, historie, základní komponenty. Olomouc: Vydavatelství UP.


Study plans that include the course
Faculty Study plan (Version) Branch of study Category Recommended year of study Recommended semester