A task of analyzing database is given to the Database Administrator of the company having the following relational database and give an expression in relational algebra each of the following queries: Employee (person-name, street, city) Works (person name, company name, salary) Company ...
SIKSHAPATH Latest Questions
Design an E-R diagram for keeping track of the exploits of your favorite sports team. You should store the matches played, the scores in each match, the players in each match and individual player statistics for each match. Summary statistics ...
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.
Illustrate with example how can you apply the following command in SQL Order by In operator Like Operator
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.