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)
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.
shilpamg posted this at 12:07 — 2nd September 2008.
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]
sandeep Kumar posted this at 05:57 — 14th July 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.
rmartin345 posted this at 03:20 — 28th August 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:
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.
decibel.places posted this at 15:28 — 1st September 2008.
He has: 1,494 posts
Joined: Jun 2008
"degree of relationship" is a concept for developing "relational databases"
Maybe this will help..
Think of LinkedIn - you have your connections (1st degree), their connections (2nd degree), their connections' connections (3rd degree)
DBPro posted this at 01:29 — 17th April 2009.
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.
shilpamg posted this at 12:07 — 2nd September 2008.
They have: 14 posts
Joined: Aug 2008
Then how will we design any flow chart?
decibel.places posted this at 13:02 — 2nd September 2008.
He has: 1,494 posts
Joined: Jun 2008
I think you need two views (I am not an expert at this):
Try using Google Charts!
pulseraiser posted this at 14:48 — 30th May 2009.
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]
sandeep Kumar posted this at 05:57 — 14th July 2010.
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.
rmartin345 posted this at 03:20 — 28th August 2010.
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
manish posted this at 07:17 — 2nd May 2012.
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.