Domeinmodellering/2010-11/Assignments/Opdracht04-A02/2 Opdrachtbeschrijving
== Lecture A2: Schema relations, frequently occurring constraints
Background
First we will focus on the most essential constraints, those that are required to guarantee the unique correspondence between the (concrete) things in the application domain and the (abstract) objects in the information system. Then we discuss the two main variants to identify objects uniquely.
We discuss when two conceptual schemata are seen as equivalent, and introduce the concept of schema transformation as a rule to transform a schema into an equivalent other schema.
We introduce a rich set of graphical constraints that occur frequently in practical situations.
Material
In this lecture we focus on chapter 3 of the lecture notes.
Targets
After this study task you will be able to:
- understand and appreciate the unique and total role constraints.
- explain weak and strong identification.
- explain schema equivalence and schema transformations.
- define and use the frequently occurring constraints presented in this chapter.
- perform elementary schema quality checks.
What you have to do
- Read exercises 3 and 4 from the Collection of Elaborated Exercises.
- Make exercises 1, 2, 3, 4 and 5 from the current chapter. (2h)
Deadline for submitting exercises: Oct 11, 2010
| Volgens mij moet deze datum bijgewerkt worden? | ||
| Patrick Uiterwijk → Domeinmodellering | Remove this comment when resolved! | |
| Bedankt Patrick, datum aangepast! |  |
|
| Theo van der Weide → Domeinmodellering | Remove this comment when resolved! | |
| Ik heb even het jaartal van de nieuwe datum aangepast in 2010, de dag en maand hetzelfde gelaten. | ||
| Patrick Uiterwijk → Domeinmodellering | Remove this comment when resolved! | |
Reflection/Discussion
See previous assignment for general reflection remarks.
Specific for this assignment. Are uniqueness and total role constraints such that all entity types are correctly identified?
