Question
Which one of the options given below refers to the degree (or arity) of a relation in relational database systems?
Official answer and solution
- Official answer
- A
- From
- Official GATE 2023 answer key
Solution
Apply standard relational database terminology for relation schema.
In the relational data model:
- The degree (or arity) of a relation is the number of attributes (columns) in its relation schema.
- The cardinality of a relation is the number of tuples (rows) currently stored in the relation.
Hence, degree refers to the number of attributes of its relation schema.
Final answer
Option (A)
Common trap
Confusing degree (number of attributes) with cardinality (number of tuples).
The answer is the one in the official GATE answer key. The solution is this site's own explanation.
Source
- Paper
- GATE 2023 Computer Science and Information Technology (CS)
- Question
- 16 of 65
- Section
- Computer Science and Information Technology
Report an error in this question
GATE questions are the work of the organising institutes. This site is independent and is not affiliated with them.