Degree of relation - Definition - Database

Q.  What is a degree of relation?
- Published on 26 Aug 15

a. It is the number of attributes of its relation schema.
b. The number of relationships with other tables
c. Number of association among two or more entities
d. Number of foreign key dependencies

ANSWER: It is the number of attributes of its relation schema.

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 02 Nov 15
    - The number of attributes n of its relational schema is the degree (or arity) of a relation.

    - 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)"

    - The three main relational degrees are:

    1. Ornary (one relational connection)
    2. Binary (two relational connections)
    3. Ternary (three relational connections)
    4. n-ary (used when there are many connections)

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲