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 table? Also, find the degree and cardinality of the table.
STUDENTS |
NO. |
NAME |
1 |
Tara Mani |
2 |
Jaya Sarkar IST |
3 |
Tarini Trikha |
EVENTS |
EVENTCODE |
EVENTNAME |
1001 |
Programming |
1002 |
ITQuiz |
No. |
Name |
EVENTCODE |
EVENTNAME |
1 |
Tara Mani |
100 |
Programming |
1 |
Tara Mani |
1002 |
ITQuiz |
2 |
Jaya Sarkar |
1001 |
Programming |
2 |
Jaya Sarkar |
1002 |
ITQuiz |
3 |
Tarini Trikha |
1001 |
Programming |
3 |
Tarini Trikha |
1002 |
ITQuiz |