Lectures 0/4/0/0, ECTS: 5

Semantic Data Modeling (first edition),

Prentice Hall, Hemel Hempstead (1992),

ISBN 0 - 13 - 806050 - 9.

J.H. ter Bekke,

Semantic Data Modeling (second print),

Faculty ITS, TU Delft (2001)

J.H. ter Bekke,

Database Ontwerp (derde druk),

Kluwer Bedrijfswetenschappen, Deventer (1993),

ISBN 90 - 267 -1864 - 0.

J.H. ter Bekke,

Database Ontwerp (derde druk, tweede oplage),

Faculteit ITS, TU Delft (2001)

Second quarter, Tuesday and Thursday 13.30 - 15.30, Room FF (Zuidplantsoen 4).

Derde kwartaal, Maandag, Zaal G (Mekelweg 4).

The course introduces fundamental concepts and general principles of data modeling. Practical cases illustrate the theory where appropriate. Recent developments in the database area are included. The course is organized in four main parts:

Overview of the discipline, including an assessment of the relational theory. An overview of seven modern data modeling approaches is also presented in this part.

Fundamentals of data modeling, introducing semantic concepts leading to proper object modeling.

Data modeling, illustrated with numerous practical examples. Conversion into suitable traditional models (including relational), by applying just a few simple rules, makes the collection of data and query structures reliable and easier to understand.

Case studies. Semantic data modeling is illustrated with several cases. They illustrate data modeling in complex situations and the problem of formulating queries in practical environments.

Relational systems have become widely accepted the last few years. However, many pitfalls have also been discovered in the relational theory. The course presents an in-depth analysis of the problems and offers a deeper understanding. By putting emphasis on the semantic structure of a database, reliable solutions are created for both data modeling and data manipulation problems. The theory is based on both theoretical and practical research. It is illustrated with many examples and exercises.

Table of Contents (Sheets in pdf-format, 7KB)

1 Introduction (Sheets in pdf-format, 17 KB)

2 Classical approaches (Sheets in pdf-format, 16 KB)

3 Relational pitfalls (Sheets in pdf-format, 64 KB)

4 Modern approaches (Sheets in pdf-format, 63 KB)

5 Basic notions (Sheets in pdf-format, 26 KB)

6 Semantic concepts (Sheets in pdf-format, 17 KB)

7 Semantic operations (Sheets in pdf-format, 21 KB)

8 Semantic integrity (Sheets in pdf-format, 15 KB)

9 Design methods (Sheets in pdf-format, 7 KB)

10 Conceptual design (Sheets in pdf-format, 44 KB)

11 User views (Sheets in pdf-format, 6 KB)

12 Data manipulation (Sheets in pdf-format, 16 KB)

13 Physical design (Sheets in pdf-format, 22 KB)

14 Case study 1: Bank (Sheets in pdf-format, 10 KB)

15 Case study 2: Vehicle registration (Sheets in pdf-format, 4 KB)

16 Case study 3: Working conference (Sheets in pdf-format, 5 KB)

17 Case study 4: Mail-order house (Sheets in pdf-format, 36 KB)