Module guide

Medientechnik/Wirtschaft plus (MW-plus)

Database Systems

Recommended prior knowledge

at least one programming languae

Teaching Methods Lecture/Lab
Learning objectives / competencies
  • to understand the importance, the value and the risks of data storage and data management in real world
  • to be able to apply the concepts of efficient data management in practice.
Duration 1 Semester
SWS 4.0
Effort
Classes 60
Self-study / group work: 90
Workload 150
ECTS 5.0
Max. Participants 36
Recommended Semester 6. Semester
Frequency Every sem.
Usability

Bachelor MWplus

Bachelor MI

Lectures

Labor Datenbanken

Type Labor
Nr. M+I224
SWS 1.0
Lecture Content
  • SQL: creating tables and manipulating data
  • databases in the WWW with JSP
  • mini project: developing a web-application with a relational database

 

Datenbanken

Type Vorlesung
Nr. M+I223
SWS 3.0
Lecture Content
  • Intro: database system, data model, database applications
  • The relational model: relations and attributes, relational algebra, selection, join, projection
  • SQL: schema definition, queries, data manipulation, views, consistency, ACID-principle, SQL-transactions
  • database design: design phases, semantic data modeling, dependencies, normalization, transforming the semantic scheme into a logical scheme
  • database programming: JSP, object-relational mapping, JDBC, stored procedures, trigger 
  • object-oriented und object-relational databases: shortcomings of the relational model, ODMG, object model, ODL, OQL, SQL-3
  • Database administration: RAID, indices, roles and rights
  • NoSQL-databases, CAP and BASE
Literature
  • A. Kemper, A. Eickler: Datenbanksysteme - Eine Einführung, 7. Auflage, Oldenbourg-Verlag, 2009
  • A. Heuer, G. Saake: Datenbanken: Konzepte und Sprachen, mitp-Verlag, 2008
  • R. Elmasri, S.B. Navathe: Fundamentals of Database Systems, Addison-Wesley, 2009
  • P. Gulutzan, T. Pelzer: SQL-99 Complete, Really, Miller Freeman, 1999
  • M. Schubert: Datenbanken, Theorie, Entwurf und Programmierung relationaler Datenbanken, Springer-Verlag, 2007
    (Im OPAC der Hochschule als e-book)
  • L. Piepmeyer: Grundkurs Datenbanksysteme – Von den Konzepten bis zur Anwendungsentwicklung, Hanser-Verlag, 2011 (Im OPAC der Hochschule als e-book)