In a Relational Database Management System (RDBMS), consider two tables:…
2026
In a Relational Database Management System (RDBMS), consider two tables: ‘STUDENTS’ with a degree of 10 and cardinality of 40 and ‘TEACHERS’ with a degree of 3 and cardinality of 5. What will be the degree and the cardinality of the resulting table if a Cartesian Product (STUDENTS × TEACHERS) is performed?
- A.
Degree = 13, Cardinality = 45
- B.
Degree = 13, Cardinality = 200
- C.
Degree = 30, Cardinality = 45
- D.
Degree = 30, Cardinality = 200
Attempted by 743 students.
Show answer & explanation
Correct answer: B
In a Cartesian Product (STUDENTS × TEACHERS):
Degree = sum of degrees
= 10 + 3 = 13
Cardinality = product of cardinalities
= 40 × 5 = 200
Thus, the resulting table has:
Degree = 13, Cardinality = 200
Correct answer: Option B