Database Management System20795 marksBinary Relational Operations
Retrieve the TName, and No_of_priod of teachers who teach in 'ABC' school using Relational Algebra.TEACHER (TID, TName, TAddress, TQualification), SCHOOL (SID, SName, SAddress, SPhone), SCHOOL_TEACHER (SID, TID, No_of_Period)
Retrieve the TName, and No_of_priod of teachers who teach in 'ABC' school using Relational Algebra.TEACHER (TID, TName, TAddress, TQualification), SCHOOL (SID, SName, SAddress, SPhone), SCHOOL_TEACHER (SID, TID, No_of_Period) [5]
Relation Attributes ------ TEACHER (TID, TName, TAddress, TQualification) SCHOOL (SID, SName, SAddress, SPhone) SCHOOLTEACHER (SID, TID, NoofPeriod) --- Apply the Selection (σ) operation to filter the school with name 'ABC': $$\sigma{SName = 'ABC'} (SCHOOL)$$ This gives us the tuple(s) for 'ABC' ...