Relational Algebra (Set Intersection Operation)

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

[@Wallstreetavarice]

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 ❤️❤️❤️❤️

[@tanishhede2660]

Ans: Y Y N

[@microsoftdynasty7758]

Plz upload video on join operation

[@azizouldkherroubi4178]

Keep it up thanks for this informations🔥❤

[@prashantdiwakar325]

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

[@ismailfaridi]

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

[@jasminnavi]

thank you!

[@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

[@abrahammelese5167]

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.

[@Gauravkoshyari2911]

Graphians attendance lgao😅