Consider the following two instances of relations X and Y: Relation X: Code…
2024
Consider the following two instances of relations X and Y:
Relation X:
Code | Item |
|---|---|
100 | A |
200 | B |
300 | B |
400 | C |
Relation Y:
Item | Quantity |
|---|---|
A | 5 |
B | 6 |
C | 3 |
How many total tuples will a Cartesian product between the two relations X and Y produce?
- A.
12
- B.
7
- C.
4
- D.
3
- E.
Question not attempted
Attempted by 296 students.
Show answer & explanation
Correct answer: A
Step 1: Count the number of tuples in Relation X. There are 4 tuples (100 A, 200 B, 300 B, 400 C). Step 2: Count the number of tuples in Relation Y. There are 3 tuples (A 5, B 6, C 3). Step 3: The Cartesian product of two relations is the product of their tuple counts. So, 4 × 3 = 12 tuples.