What is the degree of relationship in Database?

They have: 14 posts

Joined: Aug 2008

Please anybody tell me about the degree of relationship in Database.

decibel.places's picture

He has: 1,494 posts

Joined: Jun 2008

"degree of relationship" is a concept for developing "relational databases"

Maybe this will help..

Degree of relationship
One-to-many relationships

This means how many of one entity can be related to how many of the other(s). Ask yourself how many of each entity there can be.

In this kind of relationship one of the entities can be related many times to another entity. For example, one excavation can contain many finds; one person can commit many crimes.

One to many relationships are common and are well handed by relational databases.

Think of LinkedIn - you have your connections (1st degree), their connections (2nd degree), their connections' connections (3rd degree)

They have: 1 posts

Joined: Apr 2009

Degree of relationship refers to the number of participating entities in a relationship. If there are two entities involved in relationship then it is referred to as binary relationship. If there are three entities involved then it is called as ternary relationship and so on.

On the other hand, it is the cardinality of relationship that defines the number of instances of one entity as it relates to the number of instances of the other entity. Based on the different combinations between two entities we can have either one-to-one, one-to-many or many-to-many relationship.

They have: 14 posts

Joined: Aug 2008

Then how will we design any flow chart?

decibel.places's picture

He has: 1,494 posts

Joined: Jun 2008

I think you need two views (I am not an expert at this):

  1. A tree structure, perhaps, with relations between "nodes" like a geneology family tree
  2. Also, a venn diagram, showing overlapping (common) relations

Try using Google Charts!

They have: 10 posts

Joined: May 2009

Degree means simple relations b/w tables

Like one-to-one, one-to-many, many-to-many.
1-to-1, suppose ItemID in one table is forign key to Company list. [So for one company there will be one Item so 1-to-1 relation]

1-to-many, suppose ItemName in one table is forign key to Company list. [So for one company there will be many Item with same name so 1-to-many relation]

many-to-many, suppose AccountID in diff banks in one table is forign key to The withdrawdetails list. [So for each account there will be many withdraw entiries so its many-to-many relation]

He has: 53 posts

Joined: Jun 2010

Hi, According to me,"degree of relationship" simply refer to the concept of, how many number of entities associated with the relationship and in general way we categories as

Binary relationships, the association between two entities is the most common type in the real world. A recursive binary relationship occurs when an entity is related to itself. An example might be "some employees are married to other employees".

A ternary relationship involves three entities and is used when a binary relationship is inadequate. Many modeling approaches recognize only binary relationships. Ternary or n-ary relationships are decomposed into two or more binary relationships.

They have: 1 posts

Joined: Aug 2010

Degrees are defined prior to people being awarded them.The degree of relationship is the number of occurrences in one entity which are associated to the number of occurrences in another.There are three degrees of relationship, known as:

1. one-to-one
2. one-to-many
3. many-to-many

They have: 1 posts

Joined: May 2012

Following are the degrees of Relationships.
1. Single Entity - Unary
2. Double Entities - Binary
3. Triple Entities - Ternary
4. N Entities - N- ary

Following are the types of Relationships.
1. one-to-one
2. one-to-many
3. many-to-many

Please refer http://msdn.microsoft.com/en-us/library/bb399189.aspx

Thanks
Manish

Thanks
Manish

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.