Credit points

6

Lecturer

Prof. D.r Ralf Möller

Time

Wednesdays, 2pm to 6pm

Location

Warburgstraße 28, Room 4015

Content

For downloading presentations click pdf or pptx.

1. Architecture of database systems , conceptual data modeling with the Entity-Relationship (ER) modeling language 
2. The relational data model:
   Referential integrity, keys, foreign keys, functional dependencies (FDs), canonical mapping of entity types and relationships in the relational model, update, insertion and deletion anomalies
3. Relational schema design theory:
   Relational algebra as a query language, determination of candidate keys, FD closure, attribute closure, determination of relational schemas from FDs, canonical cover 
4. Normal forms:
   Boyce-Codd normal form, lossless and dependency-preserving decomposition of relation schemas
5. Additional Normal forms:
   Third normal form, synthesis of relational schemas, inclusion dependencies, multiple-value dependencies
6. SQL: Practical query languages and integrity conditions without consideration of the conceptual data model
7. Relational Transformers for Prediction and Data Analysis