Question:
Observe the following PARTICIPANTS and EVENTS tables carefully and write the name of the RDBMS operation which will be used to produce the output as shown in RESULT ? Also, find the Degree and Cardinality of the result.
PARTICIPANTS
PNO | NAME |
---|---|
1 | Aruanabha Tariban |
2 | John Fedricks |
3 | Kanti Desai |
EVENTS
EVENTCODE | EVENTNAME |
---|---|
1001 | IT Quiz |
1002 | Group Debate |
RESULT
PNO | NAME | EVENTCODE | EVENTNAME |
---|---|---|---|
1 | Aruanabha Tariban | 1001 | IT Quiz |
1 | Aruanabha Tariban | 1002 | Group Debate |
2 | John Fedricks | 1001 | IT Quiz |
2 | John Fedricks | 1002 | Group Debate |
3 | Kanti Desai | 1001 | IT Quiz |
3 | Kanti Desai | 1002 | Group Debate |
CSKC| Created: 1-Jan-2019 | Updated: 4-Jan-2019|CBSE12A-2016