Agenda

Database Design
Abstraction levels for good database design - The requirement analysis - Fundamentals of Entity-Relationship Model - Key - Characterization of relationship types - Existence-dependent entity types - Generalization - Aggregation - Combining generalization and aggregation - Consolidation - Conceptual modeling with UML
The Relational Model
Definition of the relational model - Mapping a conceptual schema to a relational schema - Refinement of the relational schema - Relational Algebra - The relational calculus
Relational Query Languages
History - Data types - Schema definition - Schema change - Basic data manipulation - Simple SQL queries - Queries using multiple relations - Aggregate functions and grouping - Nested queries
Data Integrity
Referential Integrity - Ensuring referential integrity - Verification of static integrity constraints - Triggers
Relational design theory
Functional dependencies - Key - Determination of functional dependencies - Anomalies - Decomposition of relations - Normalization and Normal Forms
Transaction Management
Requirements for transaction management - Transaction types - Properties of transactions - Transaction management in SQL - State transitions of a transaction
Security Aspects
Discretionary Access Control - Access Control in SQL - Refinement of the authorization model - Mandatory access control - Multilevel databases - Cryptography
Object-oriented databases
Evaluation of relational database systems - Advantages of object-oriented data modeling - Properties of objects - Definition of object types - Modeling the behavior - Type hierarchy
XML Data Modeling and XML Integration
Hierarchical modeling using XML - XML integration in relational databases - Storage models - SQL and XML
Trainer

Marco Skulschus (born in Germany in 1978) studied economics in Wuppertal (Germany) and Paris (France) and wrote his master´s thesis about semantic data modeling. He started working as a lecturer and consultant in 2002.
Publications
- Grundlagen empirische Sozialforschung ISBN 978-3-939701-23-1
- System und Systematik von Fragebögen ISBN 978-3-939701-26-2
- Oracle PL/SQL ISBN 978-3-939701-40-8
- MS SQL Server - T-SQL Programmierung und Abfragen ISBN 978-3-939701-69-9
Projects
- He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining.
Research
He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.
