Consider the following tables and their respective degrees and cardinalities…
2023
Consider the following tables and their respective degrees and cardinalities in a database called SCHOOL: Select the degree and cardinality of the cartesian product of the tables STUDENT X TEACHER from the following options:
- A.
30 7500
- B.
200 325
- C.
30 325
- D.
200 7500
Attempted by 390 students.
Show answer & explanation
Correct answer: A
Degree of a table = number of attributes (columns)
Cardinality of a table = number of tuples (rows)
Given: STUDENT → Degree = 20, Cardinality = 300
TEACHER → Degree = 10, Cardinality = 25
For Cartesian Product (STUDENT × TEACHER): Degree = 20 + 10 = 30
Cardinality = 300 × 25 = 7500
So, the correct answer is 30 and 7500.