back to table of content


INFB  Databases I CourseINF
Lecturers : Prof. Dr. rer. oec. habil. Manfred Günther   eMail | Homepage
Term3
Course Classification : Informatics BachelorCH4
Language : Deutsch Type L E
Type of examination : PL  Credits
Method of evaluation : written examination 120 min 
Requirements :  
Cross References :  
Previous knowledges :  
Aids and special features : Mode of assessment
Course examination / oral examination with prerequisite exercises
Graded: yes
Overall grade is the course examination / oral examination grade. 
Teaching aims : Knowledge and understanding of basic concepts necessary for designing and implementing databases Students will be able to apply this knowledge to ER-modelling in practical exercises, relational data model depictions, using SQL to describe schemes, data manipulation in connection with practical exercises on their own databases. 
Contents :

Introduction
Concept of database systems and architecture
Data models and data modelling:
- Entity relationship model / modelling
- Relational model: structure, operations, integrity
- Normalisation theory
Relational data manipulation / SQL
Variants of creating SQL applications
Transactions 

Literature : Ramez Elmasri / Shamkant B. Navathe Grundlagen von Datenbanksystemen PEARSON Studium 2002
Andreas Heuer, Gunter Saake, Kai-Uwe Sattler: Datenbanken kompakt mitp Verlag 2001
Heuer, A. / Saake, G. Datenbanken Konzepte und Sprachen mitp Verlag 1. Nachdr.
Matthias Schubert: Datenbanken Theorie, Entwurf und Programmierung relationaler Datenbanken B.G. Teubner 2004  


back to table of content