# “Relation” versus “relationship”

What is the difference between relation and relationship?

Some say that relationship often refers to social connections. For instance,

She has a close relationship with her daughter.

the relationship between poor housing and health problems (Longman Dictionary)

the special relationship between Britain and the US (Longman Dictionary)

-

While relation and relationship refer to the connection between two things, relation shades more toward the way things are connected, while relationship refers to the connection itself. The difference is not spacious.

-
Example: "The size of the targets bore no relation to their importance." [NOAD] This is different from "The two friends enjoyed a very close relationship." – Robusto Mar 5 '11 at 11:19
Moreover, relation is more formal and has a technical meaning in mathematics. – Ganymede Mar 21 '15 at 13:45
@Robusto You should give the examples in the answer itself. – Colas May 29 '15 at 13:23
@Robusto ^ This. – Peter Raeves Dec 17 '15 at 15:49

To me, the main difference is that relationship is broader than relation:

• both can mean “the way in which two or more concepts, objects, or people are connected”;
• in addition, relationship can mean “the state of being connected”.

So, in “She has a close relationship with her daughter”, because you're talking about the fact a particular existing connection, I wouldn't use “relation”.

In your second example, if “the relationship between poor housing and health problems” is merely an academic study of the possible correlation, then “relation” would fit well.

In the third, again, the “special relationship” is a particular, existing connection, so “relation” wouldn't fit the bill. In addition, “special relationship” is a well established phrase since post-World War II times.

-

There's other meanings as well...

"Fred has had [sexual] relations with Sally."

"I hate having to invite my poor relations to parties, because they always steal the silverware."

In the database sense, without being pedantic about the academically correct definitions of "Relation" and "Relationship", especially at the physical level when we are discussing tables (not tuples) but in keeping with the English meaning ...

• A real (table) or derived (columns from more than one table) is a Relation

• but most developers will cringe at, it is not commonly understood
• therefore we commonly call them tables or derived tables
• and therefore the Relationships can be simply Relations between tables

• both defined (as Foreign Keys) and not (derived, as per other data values, such as related by date or time or some other value)
• personally I would capitalise the formally defined Relations and leave the derived or projected relations uncapitalised.
-
Re „at the physical level when we are discussing tables (not tuples)“ – Why do you contrast tables with tuples? A table is the physical pendant of a model relation, a tuple is the model pendant of a physical record, aren't they? – Gerold Broser Oct 18 '15 at 18:45

Relationship means "bond" while relation means "connection", used in formal and informal lexicon.

-
Since a bond is a connection, this is not really helpful. (Not to mention how this one-liner compares to the older answers.) – RegDwigнt Feb 28 '13 at 10:18

## protected by RegDwigнt♦Feb 28 '13 at 10:15

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site.