Degree and cardinality of a relation in relational database are 4 and 3…
2023
Degree and cardinality of a relation in relational database are 4 and 3 respectively. If 3 attributes and 4 tuples are added to the relation, what will be its new cardinality and degree?
- A.
7, 6
- B.
7, 7
- C.
8, 6
- D.
More than one of the above
- E.
None of the above
Attempted by 1745 students.
Show answer & explanation
Correct answer: B
In a relational database, the degree of a relation refers to the number of attributes (columns), and the cardinality refers to the number of tuples (rows). Given: Original degree = 4, Original cardinality = 3. When 3 attributes are added: New degree = 4 + 3 = 7. When 4 tuples are added: New cardinality = 3 + 4 = 7. Therefore, the new degree is 7 and the new cardinality is 7.