Retrieve the Employee Name, Department Number and… – BIT Database Management System 2079 Solved

BIT Database Management System · 2079 · Solved Question with Answer

Retrieve the Employee Name, Department Number and Department Name of "John Smith" using Relational Algebra. The relations are given below.

a. EMPLOYEE ( Ssn, Fname, Lname, Bdate, Address, Sex, Salary, SuperSSN, Dno)

b. PROJECT ( Pnumber, Pname, Plocation, Dnum )

c. WORKS ON ( Essn, Pno, Hours )

d. DEPARTMENT (Dname, Dnumber, Mgr_ssn, Mgr Start date)

Solution

Retrieve the Employee Name, Department Number and Department Name of "John Smith" using Relational Algebra. The relations are given below. a.…