Question-7

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

• Number of attributes of its relation schema.
• Number of tuples stored in the relation.
• Number of entries in the relation.
• Number of distinct domains of its relation schema.

Answer

• Number of attributes of its relation schema.
• Number of tuples stored in the relation.
• Number of entries in the relation.
• Number of distinct domains of its relation schema.

Solution

The degree or arity of a relation in a relational database system refers to the number of attributes or fields in its relation schema. Therefore, the correct answer is the number of attributes of its relation schema, which represents the arity of a relation.