The number of attributes in relation is called as its

2013

The number of attributes in relation is called as its

  1. A.

    Cardinality

  2. B.

    Degree

  3. C.

    Tuples

  4. D.

    Entity

Attempted by 59 students.

Show answer & explanation

Correct answer: B

Concept

In the relational model, two distinct properties describe the size of a relation (table). The degree is the number of attributes (columns) in the relation, also known as its arity. The cardinality is the number of tuples (rows) in the relation. These count different things: degree counts columns, cardinality counts rows.

Application

The question asks for the term that counts the number of attributes (columns) in a relation. By definition, the count of attributes is the degree. So the value that completes the sentence is Degree.

Contrast

  • Cardinality counts tuples (rows), not attributes, so it answers a different question.

  • Tuples are the rows themselves; a row is an instance of data, not a count of columns.

  • Entity is an ER-model concept (a real-world object that becomes a table); it is not a count of attributes.

Explore the full course: Btsc Lab Assistant