Relational Algebra (Natural Join Operation) 

Hello your DBMS PLAYLIST was very much helpful for our university exams please do continue the series asap please

Output: S_ID / S_Name / Rating / Age / B_ID / Date 22 / Tom / 7 / 20 / 101 / 10-May-21 58 / Rose / 10 / 21 / 103 / 05-Jan-22

2 rows ,6 columns

6 attributes and 2 tuples

Nesco is the best ❤

Two rows in output relation

There will be only two rows only, since there is only one common attributes between the two tables, we only need to compare the values or instances, so we get 22 and 58 are present on both tables so we will have two tuples with 7 columns.

S_ID,S_Name,Rating,Age,B_ID,Date

suppose in natural join, if the value of ratings in case of s_id of both table are different them what should be the output.

2 tuple and 7 attribute

109 is null

thanks for your help! i finished this series and I found it really helpful :)

💯

6 attributes and 2 tuples..

2 rows❤