Relational Algebra Operations - Binary

Подписаться 2,6 млн

Просмотров 230 тыс.

50% 1

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

Опубликовано:

28 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 69

@bhojbhatchhetri6482 Год назад

Amazing explanation with examples! very easy to understand

@jimsf5093 2 года назад

you are great ,you helped me pass my exams

@Mamelcrispen 11 месяцев назад

How much did you get ?

@izharkhankhattak 2 года назад

Excellent job!

@stargazing0010 2 года назад

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

@azuboof Год назад

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

@tarakhanal1864 2 года назад

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 2 года назад

Hey i was Also thinking about it

@aniruddharora4004 2 года назад

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 2 года назад

@@aniruddharora4004 It's definitely a mistake.

@canmalatyaloglu8690 Год назад

yuup

@sharifkakar85 2 года назад

You are the best, Thank you very much 😍

@FunCorner5332 Месяц назад

Thank you! clear and concise explanation.

@arts.maimounah 2 года назад

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

@leenaalessa 2 года назад

Thank you so much !! This was very HELPFUL!

@20SBOI Месяц назад

Your explanation is great!

@surajkumarpatra1979 Год назад

Thank you

@haidarmohammad8510 Год назад

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

@abdulbasit0123 5 месяцев назад

the best, you nailed it

@DharmiDesai Год назад

Thank you❤

@user-fc3rf1sj6l 5 месяцев назад

under standing all concepts in easy manner

@sinchanayj795 Год назад

Thank you😇❤

@Sara-oy6ly Год назад

Thank you 🥰🥰🥰

@Tprakh-iw6qt 20 дней назад

Excellent tutoring

@palashsharma26 2 года назад

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

@yenosibinamakanjuola9249 Год назад

thank you sooo much

@JD-SANJEY 3 месяца назад

Good explanation ❤

@dhaneshpt8641 11 месяцев назад

Thank you ma'am

@HuyTran-oc4nw 6 месяцев назад

thanks a lot

@styxrakash4639 4 месяца назад

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

@sourabhhiremath8109 8 месяцев назад

thank you mam

@Deepaksingh-zx1ty Год назад

What to do with join operation without any condition?

@52_shiwani29 2 года назад

Can u please post the relational calculus operations

@kuchipudimanohar4256 2 года назад

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

@eriktruong9856 2 года назад

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

@HuyTran-ii4kj 2 года назад

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

@najmiyamuhammed6592 3 месяца назад

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

@amazinggaming9870 4 месяца назад

Watching this half an hour before exam

@misbahulislam999 2 года назад

I humble request you mam plz continue the DBMS LEC.

@yemayam4414 8 месяцев назад

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

@rishabhverma6685 2 года назад

is this playlist completed ?

@abdulelahal-yousuf1198 Год назад

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

@abdulelahal-yousuf1198 Год назад

Oh your using p for rename

@rodm8113 Год назад

you swapped join and natural join symbols!

@rockeveryday5823 4 месяца назад

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?