Universität Wien

290236 PS Databases (2020W)

2.00 ECTS (1.00 SWS), SPL 29 - Geographie
Continuous assessment of course work
Moodle

Registration/Deregistration

Note: The time of your registration within the registration period has no effect on the allocation of places (no first come, first served).

Details

max. 30 participants
Language: German

Lecturers

Classes

INFO (01.11.2020): die LV findet ab November ausschließlich digital statt

Mo 09.11.2020 09:15 - 11:15 Uhr GIS-LAB
Mo 16.11.2020 09:15 - 11:15 Uhr GIS-LAB
Mo 23.11.2020 09:15 - 11:15 Uhr GIS-LAB
Mo 07.12.2020 09:15 - 11:15 Uhr GIS-LAB
Mo 14.12.2020 09:15 - 11:15 Uhr GIS-LAB
Mo 11.01.2021 09:15 - 11:15 Uhr GIS-LAB

Information

Aims, contents and method of the course

The aim of the lecture is to give participants insight into (relational) databases. Furthermore, the students should be equipped with basics of the SQL syntax.
After completion this course, students should be able to design a database as well as to implement it into a DBMS.
The course offers an introduction to (relational) databases. The following topics will be discussed: definitions, E/R-model, relational model, SQL
Lecture, discussion and practice with MySQL / Maria DB.

Assessment and permitted materials

Assessment of the final project, knowledge review

Minimum requirements and assessment criteria

Assessment of a final project, which consists of two sub-areas:
Design of a data base (40 % of the final mark)
Implementation of the developed data base design (30 % of the final mark)
Knowledge review (30% of final mark)

Deadlines:
Part 1: coming soon
Part 2: coming soon
Part 3: last unit

Examination topics

Reading list

PowerPoint Folien

Association in the course directory

(BA GG 9.1)

Last modified: Th 07.01.2021 13:09