Universität Wien

040212 UK Introduction to relational databases (2017S)

4.00 ECTS (2.00 SWS), SPL 4 - Wirtschaftswissenschaften
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. 50 participants
Language: German

Lecturers

Classes (iCal) - next class is marked with N

  • Wednesday 15.03. 16:45 - 20:00 Hörsaal 13 Oskar-Morgenstern-Platz 1 2.Stock
  • Wednesday 29.03. 16:45 - 20:00 Hörsaal 13 Oskar-Morgenstern-Platz 1 2.Stock
  • Wednesday 26.04. 16:45 - 20:00 Hörsaal 13 Oskar-Morgenstern-Platz 1 2.Stock
  • Wednesday 10.05. 16:45 - 20:00 Hörsaal 13 Oskar-Morgenstern-Platz 1 2.Stock
  • Wednesday 24.05. 16:45 - 20:00 Hörsaal 16 Oskar-Morgenstern-Platz 1 2.Stock
  • Wednesday 14.06. 16:45 - 20:00 Hörsaal 5 Oskar-Morgenstern-Platz 1 Erdgeschoß
  • Wednesday 21.06. 16:45 - 20:00 Hörsaal 13 Oskar-Morgenstern-Platz 1 2.Stock

Information

Aims, contents and method of the course

- Semantic Data Modelling (EER)
- Relational Model
- Relational Algebra
- Functional Dependencies
- SQL
- Normalforms
- Data Integrity

Methods: The topics are presented during the lecture. There are exercises and a SQL project.

Assessment and permitted materials

30 % - Exercises
45 % - SQL Project
25 % - Participation: small tests and presentation of exercises

Minimum requirements and assessment criteria

[50%; 61%] Genügend (4)
]61%; 74%] Befriedigend (3)
]74%; 87%] Gut (2)
[87%; 100%] Sehr Gut (1)

Examination topics

Reading list

Alfons Kemper /André Eickler: Datenbanksysteme, 8. Auflage.

Association in the course directory

Last modified: Mo 07.09.2020 15:28