In a Relational Database Management System (RDBMS), consider two tables:…
2026
In a Relational Database Management System (RDBMS), consider two tables: ‘FIRST’ with 3 columns and 5 rows, and ‘SECOND’ with 6 columns and 4 rows. What will be the degree and cardinality of the table resulting from the Cartesian Product (FIRST x SECOND)?
- A.
Degree = 9, Cardinality = 9
- B.
Degree = 9, Cardinality = 20
- C.
Degree = 18, Cardinality = 9
- D.
Degree = 18, Cardinality = 20
Attempted by 296 students.
Show answer & explanation
Correct answer: B
In a Cartesian Product:
Degree = sum of columns = 3 + 6 = 9
Cardinality = product of rows = 5 × 4 = 20