top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is Relationship and degree of a Relation?

+2 votes
390 views
What is Relationship and degree of a Relation?
posted Jan 30, 2014 by Mona Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

0 votes

Relationship means how two (or more) tables are connected with each other.

There are three type of relationships
1) One to one
2) One to many
3) Many to many
Say we have table1 and table2

For one to one relationship, a record(row) in table1 will have at most one matching record or row in table2
For one to many, a record in table1 can have more than one record in table2 but not vice versa if record from table2 is also connected to more then one record of table1 then it is called many to many.


The degree of a relation is the number of attributes n of its relational schema. An example of a relational schema for a relation of degree seven, which describes university students, is the following:
STUDENTS(Name, Ssn, Home_phone, Address, Office_phone, Age, Gpa)

answer Jan 30, 2014 by Jai Prakash
0 votes

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

answer Aug 16, 2014 by anonymous
...