Relational Algebra Operations - Binary

DBMS: Relational Algebra Operations - Binary
Topics discussed:
1. The JOIN Operation.
2. The THETA JOIN.
3. The EQUIJOIN Operation.
4. The NATURAL JOIN Operation.
5. The DIVISION Operation.
Follow Neso Academy on Instagram: @nesoacademy(bit.ly/2XP63OE)
Contribute: www.nesoacademy.org/donate
Memberships: bit.ly/2U7YSPI
Books: www.nesoacademy.org/recommende...
Website ► www.nesoacademy.org/
Forum ► forum.nesoacademy.org/
Facebook ► goo.gl/Nt0PmB
Twitter ► / nesoacademy
Music:
Axol x Alex Skrindo - You [NCS Release]
#DBMSByNeso #DBMS #RelationalAlgebraOperations

[@jimsf5093]

you are great ,you helped me pass my exams

[@Mamelcrispen]

How much did you get ?

[@azuboof]

thank u so much. the only helpful video i found after searching many others

[@bhojbhatchhetri6482]

Amazing explanation with examples! very easy to understand

[@izharkhankhattak]

Excellent job!

[@20SBOI]

Your explanation is great!

[@FunCorner5332]

Thank you! clear and concise explanation.

[@stargazing0010]

Wow , Explained so well. Thank You so much!!

[@sharifkakar85]

You are the best, Thank you very much 😍

[@abdulbasit0123]

the best, you nailed it

[@arts.maimounah]

Nice explanation , it is so clear and helpful. Thank you so much 😍♥️

[@leenaalessa]

Thank you so much !! This was very HELPFUL!

[@surajkumarpatra1979]

Thank you

[@DharmiDesai]

Thank you❤

[@Tprakh-iw6qt]

Excellent tutoring

[@sinchanayj795]

Thank you😇❤

[@Sara-oy6ly]

Thank you 🥰🥰🥰

[@haidarmohammad8510]

I can't express my feelings. Thanks...................

[@JD-SANJEY]

Good explanation ❤

[@yenosibinamakanjuola9249]

thank you sooo much

[@user-fc3rf1sj6l]

under standing all concepts in easy manner

[@dhaneshpt8641]

Thank you ma'am

[@palashsharma26]

You are a great help mam , please continue🥺🥺🥺🥺🥺🥺

[@HuyTran-oc4nw]

thanks a lot

[@sourabhhiremath8109]

thank you mam

[@tarakhanal1864]

Hi, I noticed a mistake at 4:06 where the result of the join operator shows value 2 instead of 5 for DNo column in first row.

[@faisalgull3600]

Hey i was Also thinking about it

[@aniruddharora4004]

ok, so the only condition to was that the SSN number was the same, that's why it is still present in the result of the join, the fact that both DNo. are same is confusing but it can maybe be explained by the fact the first DNo. it reads is that of the Deparment table, hence that is the DNo. that it uses for the 2nd column as well.

[@angminh2626]

@@aniruddharora4004 It's definitely a mistake.

[@canmalatyaloglu8690]

yuup

[@styxrakash4639]

You need to explain how each attribute (for division) is selected to be x or y this is a key step

[@Deepaksingh-zx1ty]

What to do with join operation without any condition?

[@kuchipudimanohar4256]

Mam, please continue this series and finish it early if possible. Thanks 🙏 mam

[@52_shiwani29]

Can u please post the relational calculus operations

[@amazinggaming9870]

Watching this half an hour before exam

[@najmiyamuhammed6592]

Why did u put mgrssn in the natural join condition..

[@HuyTran-ii4kj]

I can ask some questions, cant' I? Why do some docs that I saw on the Internet say that the natural join operator, looks like this ⋈? Why in this video does she uses * symbol?

[@Ayonokyoji]

no you can't

[@eriktruong9856]

Can I ask why it is called division operation? Is it possible to relate this to the division we are familiar with?

[@misbahulislam999]

I humble request you mam plz continue the DBMS LEC.

[@rishabhverma6685]

is this playlist completed ?

[@rodm8113]

you swapped join and natural join symbols!

[@abdulelahal-yousuf1198]

At 11:50, how is it stated that Dno=Dnumber?

[@abdulelahal-yousuf1198]

Oh your using p for rename

[@yemayam4414]

This is confusing. Why do you give an example before briefly explaining what the operation even is?

[@dhanyarineesh8699]

🙏

[@abhishekasthana1911]

Very good video however the same point gets repeated so many times which could be avoided. Need not compare each tuple with each tuple everytime.

[@rockeveryday5823]

In 5:13, in result table, first tuple, how did fred DNo changed where it was 5 And how that tuple combined while DNo is different tho SSN is same as DNo is common attribute here?

[@lazzy5173]

I spotted that as well, assuming it's a mistake.

[@debjeetpaul449]

yeah! it's a mistake...

[@paribayan2106]

For renaming DNum to DNo you put Mgr-ssn instead of DNo in parantesis around 12:10 .

[@L33TTechReviewer]

that's how it is. she's renaming all the attributes in the Department entity with what is in the parenthesis of the rho/renaming operation.

[@rajeshprajapati4863]

That is fine. DNum will be the new name of Departments's DNo. attribute and keeping Mgr_SSN as it is.

[@srinivasreddy1226]

Fast videos on dbms

[@shashankh654]

notes of playlist

[@subhrajeetpradhan925]

Have some better communication skill...

[@rafiulfaisal6240]

Don't use lady voice.. its annoying ..

[@kangmoabel]

What's the matter ?

[@laaori]

So incredibly disrespectful and very useless comment. Go watch a different channel if you dislike her teaching, but she is an excellent teacher.

[@Satish-jl7ud]

Yes, i agree😶

[@Munnu-hs6rk]

I agree its distracting and annoying

[@krisgamingtm8234]

​@@Munnu-hs6rk how is it distracting though?

[@daipayanhore3726]

Thank you