Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 5 of 42

Solved 2024 Sample Question Paper CBSE Class 12 Computer Science (083) — Question 5

Back to all questions
5
Question

Question 5

In MYSQL database, if a table, Alpha has degree 5 and cardinality 3, and another table, Beta has degree 3 and cardinality 5, what will be the degree and cardinality of the Cartesian product of Alpha and Beta?

  1. 5, 3
  2. 8, 15
  3. 3, 5
  4. 15, 8
Answer

8, 15

Reason — When performing a Cartesian product (cross join) of two tables, the resulting table retains all columns from both tables. Therefore, the degree of the Cartesian product is the sum of the degrees of the two tables i.e., Degree of Alpha + Degree of Beta = 5 + 3 = 8. Similarly, the cardinality of the Cartesian product is the total number of rows resulting from the cross join, which is the product of the cardinalities of the two tables, i.e., Cardinality of Alpha * Cardinality of Beta = 3 * 5 = 15.