Question
Observe the following STUDENTS and EVENTS tables carefully and write the name of the RDBMS operation which will be used to produce the output as shown in LIST? Also, find the Degree and Cardinality of the LIST.
STUDENTS
| No | Name |
| 1 | Tara Mani |
| 2 | Jaya Sarkar |
| 3 | Tarini Trikha |
EVENTS
| EVENTCODE | EVENTNAME |
| 1001 | Programming |
| 1002 | IT Quiz |
LIST
| No | Name | EVENTCODE | EVENTNAME |
| 1 | Tara Mani | 1001 | Programming |
| 1 | Tara Mani | 1002 | IT Quiz |
| 2 | Jaya Sarkar | 1001 | Programming |
| 2 | Jaya Sarkar | 1002 | IT Quiz |
| 3 | Tarini Trikha | 1001 | Programming |
| 3 | Tarini Trikha | 1002 | IT Quiz |
Solution
Cartesian Product
Degree = 4
Cardinality = 6



