In systems analysis, a one-to-one relationship is a type of cardinality that refers to the relationship between two entities (see also entity–relationship model) A and B in which one element of A may only be linked to one element of B, and vice versa. In mathematical terms, there exists a bijective function from A to B. For instance, think of A as the set of all human beings, and B as the set of all their brains. Any person from A can and must have only one brain from B, and any human brain in B can and must belong to only one person that is contained in A.
A country has only one capital city, and a capital city is the capital of only one country. (Not valid for some countries).
In a relational database, a one-to-one relationship exists when one row in a table may be linked with only one row in another table and vice versa. It is important to note that a one-to-one relationship is not a property of the data, but rather of the relationship itself. A list of mothers and their children may happen to describe mothers with only one child, in which case one row of the mothers table will refer to only one row of the children table and vice versa. The real-world relationship that the data models is not one-to-one, because mothers may have more than one child, thus forming a one-to-many relationship.
data, model, systems, analysis, relationship, type, cardinality, that, refers, relationship, between, entities, also, entity, relationship, model, which, element, only, linked, element, vice, versa, mathematical, terms, there, exists, bijective, function, from. In systems analysis a one to one relationship is a type of cardinality that refers to the relationship between two entities see also entity relationship model A and B in which one element of A may only be linked to one element of B and vice versa In mathematical terms there exists a bijective function from A to B For instance think of A as the set of all human beings and B as the set of all their brains Any person from A can and must have only one brain from B and any human brain in B can and must belong to only one person that is contained in A A country has only one capital city and a capital city is the capital of only one country Not valid for some countries In a relational database a one to one relationship exists when one row in a table may be linked with only one row in another table and vice versa It is important to note that a one to one relationship is not a property of the data but rather of the relationship itself A list of mothers and their children may happen to describe mothers with only one child in which case one row of the mothers table will refer to only one row of the children table and vice versa The real world relationship that the data models is not one to one because mothers may have more than one child thus forming a one to many relationship See also editOne to many data model Many to many data model External links editDesign pattern many to many order entry Tomjewett com nbsp This systems related article is a stub You can help Wikipedia by expanding it vte Retrieved from https en wikipedia org w index php title One to one data model amp oldid 1216547420, wikipedia, wiki, book, books, library,
