Consider the database schema below and answer the questions that follow using SQL.EMPLOYEE->(EmpID,Firstname,Lastname,Hows_worked, Salary, SupervisorID,DepartmentID)DEPENDANT->(DependantID,Firstname,Lastname,Age,EmpID)SUPERVISOR->(SupervisorID,Firstname,Lastname,Address)DEPARTMENT->(DepartmentID,departmentname)Retrieve all employees in “sales department” whose salary is between Ksh 30,000 and Ksh 80,000.Retrieve the names of all employees in “marketing department” who work more than 10 hours and are supervisedd by “Fredrick Khamati”.List the names of all employees who have a dependent with the same first name as themselves.Retrieve all supervisors whose address is in “Nanyuki”.For each department, retrieve the departmentID, the number of employees in the department, and their average salary.Using a stored procedure,increase employee salary by 3% if his/her salary is below Ksh 20000

1. Retrieve all employees in “sales department” whose salary is between Ksh 30,000 and Ksh…

Answered: Consider the database schema below and…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Consider the database schema below and answer the questions that follow using SQL.

EMPLOYEE->(EmpID,Firstname,Lastname,Hows_worked, Salary, SupervisorID,DepartmentID)

DEPENDANT->(DependantID,Firstname,Lastname,Age,EmpID)

SUPERVISOR->(SupervisorID,Firstname,Lastname,Address)

DEPARTMENT->(DepartmentID,departmentname)

Retrieve all employees in “sales department” whose salary is between Ksh 30,000 and Ksh 80,000.
Retrieve the names of all employees in “marketing department” who work more than 10 hours and are supervisedd by “Fredrick Khamati”.

List the names of all employees who have a dependent with the same first name as themselves.

Retrieve all supervisors whose address is in “Nanyuki”.
For each department, retrieve the departmentID, the number of employees in the department, and their average salary.
Using a stored procedure,increase employee salary by 3% if his/her salary is below Ksh 20000

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 5 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions