Question

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

Answer 1

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