290236 PS Databases (2018W)

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).

Registration is open from Th 06.09.2018 07:00 to Th 20.09.2018 07:00
Registration is open from Fr 21.09.2018 08:00 to Tu 25.09.2018 20:00
Deregistration possible until Su 14.10.2018 23:59

Details

max. 40 participants

Language: German

Lecturers

Manuel Illmeyer

Classes

2018-11-12 16:45-18:15;
2018-11-19 16:45-18:15;
2018-11-26 16:45-18:15;
2018-12-03 16:00-19:00;
2018-12-10 16:00-19:00;

Ort: Computerkartographie Geographie NIG 1. OG (MM-Labor)

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 / Maria DF.

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: coming soon
Part 2: coming soon

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

Examination topics

Reading list

PowerPoint Folien

Association in the course directory

(BA GG 9.1) (B11-6.4)

Last modified: Mo 01.10.2018 15:28