Observe the following MEMBER and ACTIVITY tables carefully and write the name of the RDBMS operation,
Observe the following MEMBER and ACTIVITY tables carefully and write the name of the RDBMS operation, which will be used to produce the output as shown in REPORT? Also, find the Degree and Cardinality of the REPORT.
| MEMBER | |
| MNO | NAME |
| 101 | Jahan Dogra |
| 202 | Yog Sen |
| 301 | Ahmed Saad |
| ACTIVITY | |
| CODE | ANAME |
| 1 | SWIMMING |
| 2 | FOOTBALL |
| MNO | NAME | CODE | ANAME |
| 101 | Jahan Dogra | 1 | SWIMMING |
| 101 | Jahan Dogra | 2 | FOOTBALL |
| 202 | Yog Sen | 1 | SWIMMING |
| 202 | Yog Sen | 2 | FOOTBALL |
| 301 | Ahmed Saad | 1 | SWIMMING |
| 301 | Ahmed Saad | 2 | FOOTBALL |
4 views
1 Answers
Join operation or MEMBER U ACTIVITY
Degree of Report = No of columns
(No of Attributes) = 3
Cardinality Report = No of Rows
(No of tuples) = 6
4 views
Answered