Question

A relation in MySQL database consists of 2 tuples and 3 attributes. If 2 attributes are deleted and 4 tuples are added, what will be the cardinality of the relation?

Options

• 4

• 5

• 6

• 7

Answer 1

6

Explanation:

Cardinality of a relation is the number of tuples (rows) it contains.
Originally, there are 2 tuples and 4 more are added, so cardinality = 2 + 4 = 6.
(Deleting 2 attributes changes the degree (number of columns), not the cardinality.)