Consider the following Data Base schema Employee (Eno, EName, Salary, Dno, Mgr_Eno) Department (Dno, DName) Project (Pno, Pname, Dno) Write the following queries in SQL: Display the name of all the employees along with the name of their managers.
SIKSHAPATH Latest Questions
Illustrate with example how can you apply the following command in SQL Order by In operator Like Operator
Use the method of Lagrange an multipliers to solve the following NLPP. Does the solution maximize or minimize the objective function? Optimize Z = 2x12+ x22+3x32+10x1+8x2+6x3-100 Subject to x1+x2+x3 = 20 x1, x2, x3 ≥ 0
Create a trigger which will work before deletion in employee table and create a duplicate copy of the record in another table employee_backup.
Create a row trigger which ensures that whenever salary is updated in the emp table, then some message is displayed to the user and if new salary is lesser than old salary display the difference between both the salaries.
Create a row trigger which ensures that whenever salary is updated in the emp table, then some message is displayed to the user and if new salary is lesser than old salary display the difference between both the salaries.