One - to - many ( data model ) - Wikipedia One - to - many ( data model ) A mother may have many children, but a child has only one biological mother In systems analysis, a one - to - many relationship is a type of cardinality that refers to the relationship between two entities ( see also entity -- relationship model ) A and B in which an element of A may be linked to many elements of B, but a member of B is linked to only one element of A. For instance, think of A as mothers, and B as children. A mother can have several children, but a child can have only one biological mother. In a relational database, a one - to - many relationship exists when one row in table A may be linked with many rows in table B, but one row in table B is linked to only one row in table A. It is important to note that a one - to - many relationship is not a property of the data, but rather of the relationship itself. A list of authors and their books may happen to describe books with only one author, in which case one row of the books table will refer to only one row of the authors table, but the relationship itself is not one - to - many, because books may have more than one author, forming a many - to - many relationship. The opposite of one - to - many is many - to - one. See also One - to - one ( data model ) Many - to - many ( data model ) References External links Design pattern : many - to - many ( order entry ), Tomjewett.com This systems - related article is a stub. You can help Wikipedia by expanding it. Retrieved from `` https://en.wikipedia.org/w/index.php?title=One-to-many_(data_model)&oldid=788956645 '' Categories : Data modeling Systems theory stubs Talk About Wikipedia Português Edit links This page was last edited on 4 July 2017, at 13 : 45. About Wikipedia

Question: what is a one to many relationship in database
Answer: a type of cardinality that refers to the relationship between two entities