Course Content

Other Courses

Tribhuvan university BIT BIT Curriculum Database Management System Old Questions 2079

Database Management System - Old Questions

Question Answer Details
Syllabus Notes Old Questions Unit Wise Questions Question Bank

8. Retrieve the Employee Name, Department Number, and Department Name of 'John Smith' using Relational Algebra. The relations are given below.
EMPLOYEE (Ssn, Fname, Lname, Bdate, Address, Sex, Salary, SuperSSN, Dno)
PROJECT (Pnumber, Pname, Plocation, Dnum)
WORKS_ON (Essn, Pno, Hours)
DEPARTMENT (Dname, Dnumber, Mgr_ssn, Mgr_start_date) [5]

5 marks
Asked in 2079

Answer

Back to Question Paper
AI Generated Answer

AI is thinking...