department of informatics

Databases for Bachelor Studies 2014

Contacts
About
Dates: 
1. September 2014 - 11. December 2014
Description: 

The lecture introduces the area of databases: database draft, entity-relationship model, relational algebra, structured query language (SQL), architecture of database systems, concurrency control and transactions concept.
 

Data management: Components of a database system and advantages of the database deployment; Organisation, data architecture, data organisation and techniques.

Entity-Relationship Model: Entities, associations, relations; Aggregation, generalisation; Transformation rules for entity and relation sets.

Relational model: Normal forms; Functional, transitive and multivalued dependencies; Extension of the relational model.

Relational algebra: Set and relation oriented operators, different join operators, completeness, predicate calculus.

Structured Query Language (SQL): Introduction to SQL, data definition and manipulation, views concept, authorization, integrity conditions.

Architecture of database systems: Layers architecture, translation, query optimization, tree and space organised memory structures.
 

Multiuser operating: Transactions, serialisability, pessimistc and optimistic methods, two phase locking protocol.
 

Work with a database system: Data protection and security, archive after the generation principle, error treatment, tuning and optimization.
 

Post-relational databases: Object relational and object oriented databases, databases for online analytical processing (OLAP), fuzzy databases

Key Words: Database Management System, Entity Relationship Model, Query Language, Transaction Management, Data Protection and Security


The latest information and documents are available on Moodle.


 

Details
Lectures: 
  • Lectures: tuesday from 8:15 - 10h00, PER G120
  • Excersise: wednesday from 13:15 to 15:00 (every two weeks), PER F230 (starting from september 25th).
Term: 
Autumn
Language: 
English
Language: 
German
Curriculum: 
  • Bachelor Studies in Economics and Computer Science
Examination: 
  • Written examination at the end of the semester. All subjects treated in the lecture, in the exercises and in the given chapters of the textbook are relevant for the exam.
Literature