Practice from Database Management System with detailed solutions and model answers from past Tribhuvan University exams.
Explain the difference between “Join” and “Natural Join” of algebriac operations with example.
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).\
What is tuple relational calculus? Explain.
Write short notes on:
a. Natural join
b. Shadow paging
What is tuple realtion calculus ? Given the following schema, write tuple relational calculus for selecting name and address of employee who are working in a company having Cid=E01 Employee(Eid, Ename, Address, Cid) Company(Cid, CName)
Explain relational algebra natural join (*) operation with example.