Database Systems

Modulnummer
CS1020
Modulverantwortliche
Burkhardt Renz
Dozenten
  • Achim Kaufmann
  • Burkhardt Renz
  • Kurzbeschreibung
    Students are acquainted with concepts of database management systems, they are capable to develop data models and they are proficient in the standard query language SQL.
    Qualifikations- und Lernziele

    Students are acquainted with concepts of database management systems, they are capable to develop data models and they are proficient in the standard query language SQL.

    Lerninhalte
    Part 1: Fundamentals
    • Overview of Database Management
    • Database System Architecture and Data Independence
    • Data Models
    Part 2: The Relational Model
    • SQL
    • Relations and Relational Algebra
    • Database Integrity
    Part 3: Database Design
    • Semantic Modeling - Entity/Relationship Model
    • Functional Dependencies
    • Normalforms: 1NF, 2NF, 3NF und BCNF
    • Schema Design
    Part 4: Transaction Management
    • Recovery
    • Transactions and Isolation Level
    Part 5: Application of Databases
    • Programming Database Access (JDBC)
    • Tasks of Administration
    Moduldauer (Semester)
    1
    Unterrichtssprache
    Deutsch
    Gesamtaufwand
    6 CrP; 180 Stunden, davon etwa 90 Stunden Präsenzzeit.
    Semesterwochenstunden
    6
    Lernformen

    Lecture 4 SWS, exercises 2 SWS

    Geprüfte Leistung

    Examination prerequisite: 2 certified written exercises, Examination: Written exam

    Bewertungsstandard
    according to examination regulations (§ 9)
    Häufigkeit des Angebots
    Semesterly
    Literatur
    • M. Schubert: Datenbanken: Theorie, Entwurf und Programmierung relationaler Datenbanken Teubner
    • R. Elmasri, S.B. Navathe: Grundlagen von Datenbanksystemen Pearson
    • G. Saake, K.-U. Sattler, A. Heuer: Datenbanken: Konzepte und Sprachen mitp
    • C. J. Date: Introduction to Database Systems Addison-Wesley
    • M.A. Kifer, A. Bernstein, P.M. Lewis: Database Systems: An Application-Oriented Approach Pearson/Addison-Wesley
    • H. Garcia-Molina, J.D. Ullman, J. Widom: Database Systems: The Complete Book Pearson Prentice-Hall
    Vorausgesetzte Module