Relationship

Relationship : The manner in which two entity or object types are associated with each other. Relationships may be one to one, one to many, or many to many, as determined by the meaning of the participating entities and by business rules. Synonymous with association. Relationships can express cardinality (the number of occurrences of one entity related to an occurrence of the second entity) and/or optionality (whether an occurrence of one entity is a requirement given an occurrence of the second entity).

[Category=Data Quality ]

Source: Larry English, http://www.iaidq.com/main/glossary.shtml , 08-Feb-2009 12:09

---

These advertisers support this free service

---

Relationship - An association between occurrences of one or more entities. A 1-to-1 relationship means that the first entity has one and only one other entity. (For example, a person is supposed to have only one Social Security Number. This is an example of a relationship that would be 1-to-1 in a perfect world, but actually isn't.) A 1-to-many relationship means that one entity is related to many others. For example, the name "John" is held by many people. A many-to-many relationship means just what it says. For example, there are many products for sale in the grocery store, and many people who shop there. Many-to-many relationships have to be resolved to be useful. For instance, one person will buy many products during a single transaction. One vendor will provide many products to the store during a different type of transaction.

[Category=Data Governance ]

Source: The Data Governance Institute, 22 December 2009 10:13:02, http://www.datagovernance.com/glossary-governance/

---

Relationship - 1. What one entity has to do with another.

2. Any significant way in which two things of the same or different type may be associated.

[Category=Data Warehousing ]

Source: Aexis Business Intelligence, 23 December 2010 17:06:04, http://www.aexis.eu/DataWarehouse-Glossary/

---

Relationship - In a conceptual data model, an association between two entities, or between one entity and itself.

[Category=Data Quality ]

Source: DAMA UK, 19 July 2011 10:15:34, http://www.damauk.org/glossary.php

---

relationship - [database structures] An association or link between two objects in a database. Relationships can exist between spatial objects (features), between nonspatial objects (rows in a table), or between spatial and nonspatial objects.

[Category=Geospatial ]

Source: esri, 01 August 2012 09:01:27, http://support.esri.com/en/knowledgebase/GISDictionary/term/abbreviation