Relationship of relationships and other inter-relationship links in E-R model

0
160

Authors: Arnold Rochfeld, Pascal Negros

Tags: 1992, conceptual modeling

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 occurring 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.

Read the full paper here: https://pdf.sciencedirectassets.com/271546/1-s2.0-S0169023X00X00997/1-s2.0-0169023X9290009Z/main.pdf?X-Amz-Security-Token=IQoJb3JpZ2luX2VjEMv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLWVhc3QtMSJGMEQCICsGQUwthVhumXQAfhzya3ckB%2FRfDL2Be8I8zHVbSKCTAiAhfO9Qq8LEOXKzCx1Z4OAegZKbsQOt5wzDj%2BuKH8UzXSq9Awj0%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F8BEAMaDDA1OTAwMzU0Njg2NSIMdRTgDzPO8pa4nBBwKpEDgaPeHMIlIyUPA0yT%2F2RRFepqfcevQPNF7dXARzM%2FoVnM02m2rDo2ZjCT3BnigMaNSQnh0%2BLI9ouwnhCXY5HMW8ADiGgEZ2QecJ3%2BrV7O2nKaniW7MTxXsq4JEIKBpZA1AmRmbXcdpe28crKaKkFV1MUlZoqU9vP11o7h0i%2BqyhN6StDoU15R0B47Fno2It17sdoC7kBoPuXazDKQmZvLtLzPJh2yLPfbCqg79WfvS4ShashzT0pDsIqQjnbICjyoytalgSTt69ktqfbGx2GSJBgRTTVYJ8E8VDtqhJTSycPdvbawl%2F67qBa4GbvicJnBj3fc9CXUUY%2BDSAAW%2FveRIQlaM%2Fj%2Fz6Q7%2BnbhQ%2FL94MJ60f2ivRVkFZ9m7FjXQVppamxyS2MCOsa%2Fkxlf2Zvw0gbOk2Ai9b81%2FC7XNuDKLWim%2BKUOyPQJ0xh1K3qVE1a2JbeZxozIvt2HSOUIeVJq77CTw4KfOZZqYJfgUCFYT961WEw6tYpQIG0IQYhtXCJrADaq3%2BKxe%2BqQ7b5G1SkpBg8w9vPy%2BwU67AFO%2B16QlVDKU%2F20Am8X3A4pz8Lf238idhexzJlzwMOVgHDi%2Bj8hDyE1Bt5I3AQx6BB5Kski0nVZtD98w4zil9P9%2FzJKGsoDsD2MStzVH%2F9dBr78ZCeA%2Bi7STlRXwyGch6cCkZkCpy0MqGk8c8%2Fa3vRJeWDB7YQe3G%2BtkY2KODz6fYKbSYX6z6O7WvC6gs4I5vQFM4f%2FF66Ia%2FyUt6tYWepFx%2BeDEuIEatXhiEnMoC0oRJ3MvSVtYzqefNkUzOg61MHoK7Ydj8Ui%2BM2W%2F2AasNgH37LsUSbcIi9CtkFd0e11fuCll9bb6HcdtLqhZw%3D%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20201006T194734Z&X-Amz-SignedHeaders=host&X-Amz-Expires=299&X-Amz-Credential=ASIAQ3PHCVTYTBEKGYNK%2F20201006%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=143dbac9f47b6ac30be56ccb848f5bc5a4fbb12290eafe9acef453aa42f88c7c&hash=04594c8e532d1245e5e3b3342c52b77130ea29ca026becf35ed3537bcdc31abf&host=68042c943591013ac2b2430a89b270f6af2c76d8dfd086a07176afe7c76c2c61&pii=0169023X9290009Z&tid=spdf-7d0e837f-8c27-4f07-9eb4-bbc96efad0e4&sid=486d779f37b05542706a4e676167ccab2c3agxrqa&type=client