The GATE Grind

GATE 2023 CS – Question 16

Databases · Relational Model: Relational Algebra, Tuple Calculus, SQL · 1 mark · Multiple choice

Which one of the options given below refers to the degree (or arity) of a relation in relational database systems?

  1. Number of attributes of its relation schema.
  2. Number of tuples stored in the relation.
  3. Number of entries in the relation.
  4. Number of distinct domains of its relation schema.

Practise this question in The GATE Grind →

Show answer and explanation

Correct answer: (A) Number of attributes of its relation schema.

Explanation

The degree (arity) of a relation is the number of attributes in its schema. The number of tuples is its cardinality.