Tuple Relational Calculus (Example Queries)

DBMS: Tuple Relational Calculus (Example Queries)
Topics Discussed:
1. Tuple Relational Calculus, formulas with examples.
2. Free and bound variables in Relational Calculus.
3. Solved examples to find the ID, name, dept name, and salary for instructors whose salary is greater than $80,000.
4. Solved examples to find the instructor ID for each instructor with a salary greater than $80,000.
5. Solved examples to find the names of all instructors whose department is in the Watson building.
6. Solved examples to find the set of all courses taught in the Fall 2009 semester, the Spring 2010 semester, or both.
7. Solved examples to find only those course id values for courses that are offered in both the Fall 2009 and Spring 2010 semesters.
8. Solved examples to find all the courses taught in the Fall 2009 semester but not in the Spring 2010 semester.
Follow Neso Academy on Instagram: @nesoacademy(bit.ly/2XP63OE)
Contribute: www.nesoacademy.org/donate
Memberships: bit.ly/2U7YSPI
Books: www.nesoacademy.org/recommend...
Website ► www.nesoacademy.org/
Forum ► forum.nesoacademy.org/
Facebook ► goo.gl/Nt0PmB
Twitter ► / nesoacademy
Music:
Axol x Alex Skrindo - You [NCS Release]
#DBMSByNeso #DBMS #TupleRelationalCalculus

[@monicabattacharya6416]

Thank you soo much Neso ❤️❤️

[@Ar4an]

14:35 - mismatched brackets

[@pichazai]

thanks, these are so helpful🙏

[@nabajeeban_panda]

thanks a lot Neso Academy

[@Sara-oy6ly]

Thank you 🙂🙂

[@mahbuburrahman7993]

Hello - the opening and closing of the '{' and '}' brackets don't seem to match. Is that correct, or I am not able to follow the grouping properly.

[@graykaufmann]

You mean Example 4,5 and 6 right ?

[@manu-prakash-choudhary]

yes there is that issue

[@alokkshirsagar9995]

the brackets doesn't matches in last few examples

[@BhoomikaSaxena-bm7xk]

Saviour neso🙏

[@manu-prakash-choudhary]

can anyone tell the order of evaluation on TRC... I mean is it left to right or right to left ??? + in example 6 I am not able to figure out why it negated all the rows where u[courseid] = s[courseid]

[@annepuhemanthkumar1755]

Why not difference is not used in example 6

[@sivaranigade5027]

PLEASE REPLY SIR 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏. Please complete Java . I saw the website also still not completed yet.

[@modemharikumar9232]

instructor changed why? this instructor is well known for network security and computer network tutorials but this time we surprised with new instructor we need lot of dbms tutorials from neso academy

[@DITScience]

Yes why is it so

[@modemharikumar9232]

@@DITScience i don't know bro

[@obamacare8679]

arent these domain relational calculus?

[@louisebuijs3221]

i found this unclear. Would be nice to see a visual representation of a "tuple vairable"

[@akshatbankey8154]

When will this course on DBMS be completed ? Placements are on the edge if you could hurry that'd be great.

[@niteshkumarjha7914]

bhai lg gyi?

[@vishnu.s5093]

Who tf makes this kind of stupid theories and softwares... This guy is trying his best to make it understandable, still it's so hard

[@ArkapratimGhosh]

Some mf

[@gateeasycse]

T.sid=S.sid ,S.sid=T.sid are same??

[@Venkat_2o]

Yes

[@Venkat_2o]

Yes

[@Adnanlone-]

very bad