In STUDENT table as SID is the primary key, there are 100 different SID s stored.
example:
SID |
SNAME |
01 |
Aaru |
02 |
Shiva |
.......
100
|
Varun
|
In ENROLL table as SID and CID together make a composite key, there is a possibility of same SID with 200 different CID
SID |
CID |
02 |
CID-01 |
02 |
CID-02 |
.......
02
|
CID- 200
|
In such case, STUDENT (JOIN) ENROLL can give a maximum of 200 tuples.
SID |
SNAME |
CID |
02 |
Shiva |
CID-01 |
02 |
Shiva |
CID-02 |
.........
02
|
Shiva
|
CID-200
|
Answer: 200