AT: Well, I think I am a bit confused now. In my personal understanding, a relation is defined as a set of tuples. Then ... "in the relational model every relation represents a relationship". And then a quote from Chen: "each tuple of entities ... is a relationship". If I use the first and the second statements - I can say that a relationship is a set of tuples. The third statement says that a relationship is a tuple. So far, is a relationship a set of an element of a set? (Or may be a set of sets?)
GE: I argue that there is essentially no difference between relationships between entity (type tables) and between an entity and its attributes. They both represent relationships between two populations of things. Something is an attribute by virtue of there being a relationship. If relationships are represented by foreign keys and the entity tables must be in 1NF, as in the relational model, then all relationships must be at most Many-to-One (a very unnecessary limitation when modeling some user domain).
TF: The relational model was a mathematical construct, derived from set theory. Hence that particular terminology. The entity-relationship model is essentially a directed graph model, where relationships are prominent residents. Not so in the relational model (despite the name), where relationships (between relations, mind you) are not visible and in the SQL implementations is reduced to constraints. Relationships are about structure, which is as important as meaning (the semantics of the terms used in the universe being modeled).2. Quote of the Week
"In Relational Theory sometimes the relationships, where we do our Joins are much more important than the attributes on an Entity." (quoted in LinkedIn.com exchange)
3. To Laugh or Cry?
4. Of Interest
And now for something completely different
The PostWest (The future of the West is all behind it)
- Jews and Israel in a threatened, leaderless and delusional world
- What everybody does for no good reason with impunity but only Jews are not allowed to do even to save their lives: U.S. says kills up to 116 civilians in strikes outside war zones
- British Labour leader compares Israel to Islamic State
- Belgian Jewish student ‘gassed’ with deodorant by classmates in showers
- "Jews burn the best," sing Dutch teens at graduation party
- NYTimes: Self-determination is a bad thing only for Jews
- Brexit - The Movie
- Quartet's 10 recommendations to revive Israel-Palestinian peace talks
- Celebrating #Brexit: Why the EU doesn't deserve to exist
- Palestinian kills teen in Israeli settlement
- Abbas aide: 'Wherever you see an Israeli, slit his throat'
- Hamas calls for more violence amid blood-soaked days
Do you like this post? Please link back to this article by copying one of the codes below.URL: HTML link code: BB (forum) link code: