FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -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.

Detailed explanation-2: -Different numbers of entities can appear on each side of a relationship. For example, each customer can buy any number of products, and each product can be bought by any number of customers. This is known as a many-to-many relationship. We can also have one-to-many relationships.

Detailed explanation-3: -For example, it is possible for more than one student to work on a project. A group of five college students is given a project that they must accomplish in a month’s time. It shows a Many-to-One relationship.

Detailed explanation-4: -An entity may be involved in any number of relationships, and each relationship may be of any degree. Furthermore, two entities may have any number of binary relationships between them, and so on for any n entities (see n-ary relationships defined in the “General n-ary Relationships” section below).

Detailed explanation-5: -Three types of relationships can exist between two entities, which are given below and also discussed in this article with examples.