Ernest Adams
Constanze Bausch
Steve Bürk
Monika Halkort
Beate Hundsdörfer
Steffen Knop
Rainer Kürvers
Klaas Kuitenbrouwer
Raimo Lång
Simon Løvind
Mark Meadows
Andrew Otwell
Stephan Richter
Dick Rijken
Michael Rüger
Inga von Staden
Florian Thalhofer
Michael Valeur
Niels Wolf

Data Bases

Rainer Kürvers

Lecture and Case Studies

Module 2: Tuesday, July 9 th through Wednesday, July 10 th 2002


information is for human beings - it is a network, it is robust and it is effective. data is for computers - it is distinct, it is easy to disturb and it can be effective, sometimes. we will speak about the transformation of information into data structures. we will touch some acronyms like UML, XML, SQL and we will try not to get hurt by them.

Course Outline

Life is stranger than fiction. Our leitmotif during the two days will be a fictional but realistic situation from which we will derive requirements and a data model.

Day One (Lecture)


The real life situation.
Questions to be answered:


Questions to be answered:

Day Two (Exercise)


Use Case Analysis of the real life situation.


Class Diagram for the Use Cases of the real life situation.


The participants will learn the difference between human and technical information handling. It is the gap we need to close. They will learn to understand basic technical concepts of data manipulation and storage as well as the basic semantical concepts of the object paradigma.
They will know where the UML comes from, what it's purpose is and which parts of it they probably will not use. They will be able to analyze a given situation and formulate it as one or more Use Cases. They will practice how to derive a data model as Class Diagram from a Use Case.
Due to the integrated approach of UML we will occasionally cross the border between Use Cases and the Class Diagram, so there will be no strict separation between morning and afternoon topics on the second day.
What the participants will certainly not learn is: reliably creating a reliable data model, transferring a data model into a data base design, using UML for round-trip engineering. In short, they will not become programmers… but learn to communicate with programmers.



integrated UML-tool