Universität Wien

290009 PS Introduction to Databases, Group B (2016W)

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. 40 participants
Language: German

Lecturers

Classes (iCal) - next class is marked with N

Practice units:
10/27/2016 and 11/03/2016, 12.00-15.00, Computerkartographie Geographie NIG 1.OG (GIS-Labor)

  • Monday 03.10. 10:15 - 11:45 Hörsaal 4C Geographie NIG 4.OG C0409
  • Monday 10.10. 10:15 - 11:45 Hörsaal 4C Geographie NIG 4.OG C0409
  • Monday 17.10. 10:15 - 11:45 Hörsaal 4C Geographie NIG 4.OG C0409

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 MS Access / MySQL.

Assessment and permitted materials

Assessment of the final project.

Minimum requirements and assessment criteria

Assessment of a final project (as a group), which consists of two sub-areas:
Design of a data base (50 % of the final mark)
Implementation of the developed data base design (50 % of the final mark)

Deadlines:
Part 1: 12/01/2016 noon
Part 2: 01/20/2017 noon

Compulsory attendance: One theory unit and practice unit respectively can be missed only.

Examination topics

Reading list

PowerPoint slides

Association in the course directory

(BA GG 9.1) (B11-6.4)

Last modified: Mo 07.09.2020 15:42