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

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 Sa 02.09.2017 07:00 to Mo 25.09.2017 07:00
Deregistration possible until Mo 16.10.2017 07:00

Details

max. 40 participants

Language: German

Lecturers

Gilbert Kotzbek

Classes (iCal) - next class is marked with N

Praktische Übungen:
MO 13.11.2017 15:30-18:30
MO 27.11.2017 15:30-18:30

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

Monday 09.10. 16:45 - 18:15 Hörsaal II NIG Erdgeschoß
Monday 16.10. 16:45 - 18:15 Hörsaal II NIG Erdgeschoß
Monday 23.10. 16:45 - 18:15 Hörsaal II NIG Erdgeschoß

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 / MariaDB.

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: 2017-11-10 noon
Part 2: 2017-12-15 noon

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 07.09.2020 15:42