Fundamentals of Databases

Basic concepts of databases (- structure of DBMS; - transactions, ACID; - deadlocks; - indices; - trigger);
Relational database design (- Extended Entity Relationship-Model (ER, EER);

  • logical relational model; - normal forms); SQL (- DDL; - DML; - DQL)

Mode of delivery

face to face

Type

compulsory

Recommended or required reading and other learning resources/tools

Elmasri, Navathe: Grundlagen von Datenbanksystemen (aktuelle Auflage)

Planned learning activities and teaching methods

Integrated course: lecture, case studies, discussion

Assessment methods and criteria

Assessment is based on the final exam as well as on the quality of students' assignments, presentations etc.

Infos

Degree programme

Project Management & IT (Bachelor)

Cycle

Bachelor

ECTS Credits

3.00

Language of instruction

German

Curriculum

Part-Time

Academic year

2023

Semester

3 WS

Incoming

No

Learning outcome

At the end of this module, students will be able to design a database model for a particular task and implement it in a relational database. They will be able to run database queries and manipulate a database. Students will be able to understand and describe fundamental concepts and functions of DBMS.

Course code

0387-17-01-BB-DE-26