Abstract The concept of relationship has hitherto been defined as an association between entities. This definition is too restrictive and is inadequate for the modelling of certain phenomena occuring within the corporate context. When links appeared between relationships, the conventional Entity-Relationship model would transform the original relationships into entities and then establish a relationship between them. This transformation of the nature of a conceptual object does not stem from any need to represent a managerial reality, but from a modelling constraint. This article extends the notion of relationship by allowing for the expression of relationship between relationships whenever given conditions of the collections are verified. If these conditions are not verified, but links do exist between of given relationships, we suggest that these constraints be expressed using operators, such as exclusion, inclusion, simultaneity, totality, etc. These extensions all strive to achieve the same aim, which is to allow for clear modelling of the complex objects and links that occur within companies.
[1]
Peter P. Chen.
The entity-relationship model: toward a unified view of data
,
1975,
VLDB '75.
[2]
Toby J. Teorey,et al.
ER model clustering as an aid for user communication and documentation in database design
,
1989,
CACM.
[3]
E. F. Codd,et al.
Normalized data base structure: a brief tutorial
,
1971,
SIGFIDET '71.
[4]
T. J. Teorey,et al.
A logical design methodology for relational databases using the extended entity-relationship model
,
1986,
CSUR.
[5]
Daniel Pascot,et al.
Conception d'un système d'information: construction de la base de données
,
1980
.