Relational Algebra (Set Intersection Operation)

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

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

50% 1

DBMS: Relational Algebra (Set Intersection Operation)
Topics discussed:
1. Recap of various additional operations in relational algebra.
2. Basics of Set Intersection (∩) operation in relational algebra.
3. Syntax and working of Set Intersection (∩) operation in relational algebra.
4. Solved examples using Set Intersection (∩) operation in relational algebra.
5. Justification on achieving Set Intersection (∩) operation using fundamental set difference operator in relational algebra.
6. Homework problem to check if the commutative property holds true on a few relational algebra operations including the Set Intersection (∩).
Follow Neso Academy on Instagram: @nesoacademy(bit.ly/2XP63OE)
Contribute: www.nesoacadem...
Memberships: bit.ly/2U7YSPI
Books: www.nesoacadem...
Website ► www.nesoacadem...
Forum ► forum.nesoacad...
Facebook ► goo.gl/Nt0PmB
Twitter ► / nesoacademy
Music:
Axol x Alex Skrindo - You [NCS Release]
#DBMSByNeso #DBMS #RelationalAlgebraOperations

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

26 сен 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

Q1. Yes Q2. Yes Q3. No -> Counterexample: Let A = {1,2} and B = {2,3} then A - B = {1} and B - A = {3}, so A - B != B - A. Thus (-) is not commutative.

@hezekiahaero2194 Год назад

I am taking BSIT and we have a subject for Introducing to fundamentals of Databases and your channel helped me to survive my midterm. I'm on my finals , and i hope you will include the additional operations ( assignment operation, natural join and division operation ) it would help me a lot ♥️

@debrajdas8591 Год назад

Q1 and Q2 these realtional algebra operation are commutative bc according to commutative a*b = b*a so R U S will produce same as S U R but last one will not be commutative bc R - S is not same as S - R

@prashantdiwakar325 Год назад

Love your classes ❤️🙂❤️❤️ please upload ppt as well sir ❤️❤️❤️❤️

@azizouldkherroubi4178 Год назад

Keep it up thanks for this informations🔥❤

@microsoftdynasty7758 Год назад

Plz upload video on join operation

@jasminnavi Год назад

thank you!

@prashantdiwakar325 Год назад

Sir can you complete this series before gate????

@muthulakshmi-rz1ox Год назад

Please bring micro processor and micro controllers and software engineering subject

@rupalkharya7102 Год назад

Without normalisation denormalization data integrity referential integrity Functional dependency concept dbms are not complete

@ismailfaridi Год назад

Answer: 1. (R∪S) is commutative. 2. (R∩S) is commutative. 3. (R-S) is not commutative.

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

Ans: Y Y N

@abrahammelese5167 10 месяцев назад

yes the aRE COMMUTATIVE

@abdikadirmohamed3935 Год назад

Q1) No, the relational algebra operation R U S is not necessarily commutative. Q2) Yes, he relational algebra operation R ∩ S is commutative. Q3) No, the relational algebra operation R - S is not commutative.