Skip to main content

Database Concepts

(in German: Database Concepts )

Module-ID: FIN-INF-100391
Link: LSF
Responsibility: Gunter Saake
Lecturer: Gunter Saake
Classes:
  • Lecture Database Concepts
  • Exercise class Database Concepts
 
Applicability in curriculum: - B.Sc. INF (bilingual): Informatik I - Pflicht

Abbreviation

DB1_en

Credit Points

5

Semester

Summer

Term

Duration

1 Semester

Language

english

Level

Bachelor

Intended learning outcomes:
The students ...

  • understand basic concepts of database systems
  • are able to model relational databases
  • are familiar with relational database languages
  • can develop database applications

Content:

  • Properties of Database Systems
  • Architectures
  • Conceptual Design of Relational Databases
  • Relational Database Model
  • Mapping of ER-Schemas to Relations
  • Database Languages (Relational Algebra, SQL)
  • Formal Design Criteria and Normalization
  • Database Application Programming
  • Further Database Concepts, e.g., Views, Triggers, Access Rights

Workload:
56 contact hours + 94 h self study

Pre-examination requirements: Type of examination: Teaching method / lecture hours per week (SWS):

Successful participation in the exercise

Written exam

  • 2 SWS Lecture
  • 2 SWS Exercise
Prerequisites according to examination regulations: Recommended prerequisites:

Cannot be attended together with “Datenbanken 1”

Media: Literature:

  • Datenbanken - Konzepte und Sprachen. Gunter Saake, Kai-Uwe Sattler, Andreas Heuer, March 2013, ISBN 3-8266-9453-8, MitpVerlag; Edition 5
  • Fundamentals of Database Systems. Ramez Elmasri, Shamkant B. Navathe, April 2010, ISBN 0-136-08620-9, Addison Wesley; Edition 6

Comments: