GATE CSE 2023 | Question: 6

Question

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

• A. Number of attributes of its relation schema.
• B. Number of tuples stored in the relation.
• C. Number of entries in the relation.
• D. Number of distinct domains of its relation schema.

Comments

A Dumb Question!!

Answer 1

Relational Model Definitions:

A relation is a table with columns and rows.

An attribute is a named column of a relation.

A tuple is a row of a relation.

A domain is a set of allowable values for one or more attributes.

The degree of a relation is the number of attributes it contains.

The cardinality of a relation is the number of tuples it contains.

A relational database is a collection of normalized relations with distinct relation names.

The intension of a relation is the structure of the relation including its domains.

The extension of a relation is the set of tuples currently in the relation.

https://cmps-people.ok.ubc.ca/rlawrenc/teaching/304/Notes/304_3_Relational_by6.pdf 

https://dsf.berkeley.edu/jmh/cs186/f02/lecs/lec4_2up.pdf 

Comments

@Deepak PooniaSir Can u tell how to obtain the brekeley university lecture slides 

Answer 2

Degree in a relational database is simply the number of attributes in relations.

Option (A) is correct.

Answer 3

I dont know how was this question even given in the exam :)

Anyways answer is option a

Answer 4

The degree (or arity) of a relation in a relational database system refers to the number of attributes or columns in its relation schema. It indicates how many pieces of information are associated with each tuple (row) in the database table.

Correct Answer: Option (A) ->Number of attributes of its relation schema.