Consider the following relations X(S, Si, C) and Y(S, P, D) . Number of tuples…
2023
Consider the following relations X(S, Si, C) and Y(S, P, D) .
Number of tuples obtained by applying cartesian product over X and Y are :
- A.
16
- B.
12
- C.
04
- D.
32
Attempted by 412 students.
Show answer & explanation
Correct answer: A
Answer: 16 tuples.
Explanation:
Count the tuples in each relation.
Relation X has 4 tuples.
Relation Y has 4 tuples.
Apply the rule for cartesian product: multiply the counts of tuples from each relation.
Compute the result: 4 × 4 = 16.
Note: The cartesian product does not consider matching attribute values; it pairs every tuple of the first relation with every tuple of the second, regardless of attribute values.
A video solution is available for this question — log in and enroll to watch it.