Consider the database schema below and answer the questions that follow using SQL.EMPLOYEE-EmpID Firstname. Lastname. Hows worked. Salary,SupervisorlID DepartmentlID)DEPENDANT->RependantID Firstname. Lastname. Age EmpID)SUPERVISOR->($upervisorID.Firstname. Lastname Address)DEPARTMENT->(RepartmentID departmentname)Retrieve all employees in "sales department" whose salary is between Ksh 30,000and Ksh 80,000.Retrieve the names of all employees in “marketing department" who work more thani.ii.10 hours and are supervisedd by "Fredrick Khamati".List the names of all employees who have a dependent with the same first name as111.themselves.iv.Retrieve all supervisors whose address is in "Nanyuki".For each department, retrieve the departmentlID. the number of employees in theV.department, and their average salary.Using a stored procedure.increase employee salary by 3% if his/her salary is belowV1.

Answered: i. Retrieve all employees in "sales…

Engineering

Computer Science

i. Retrieve all employees in "sales department" whose salary is between Ksh 30,000 and Ksh 80,000.

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

Similar questions

Warehouse Database Diagrams Tables System Tables FileTables dbo.invoicearchive dbo.invoicelineitems dbo.invoicesarchive E dbo.invoicesTerms1 dbo.invoicesTerms2 E dbo.invoicesTerms3 E dbo.vendors
Use single-row subquery in a HAVING clause. List customer numbers of customers who paid total amount (sum of quantity * paideach) of their orders less than the average of total amount of orders that paid by all customers. Include the following columns in the result. a. Customer Numberb. Total AmountHint: The subquery returns the average total amount that paid by all customers. We need to join two tables in this subquery and use group function to find average of total amount based on the number of customers.
Q4: Customer has treated his pet at Hilltop animal hospital. Hospital has issued an invoice as shown below. Using normalization rules, you are required to get pure logical schema up 3rd form. [15 Marks] Order number: Customer number: 9876 Customer name: Billy Customer address: 456 HighTower Street City-Country: Hong Kong, China Product No A123 B234 Order Form C345 1234 Desscription Date: 11/04/98 Pencil Eraser Sharpener Quantity 100 200 5 Unit Price $3.00 $1.50 $8.00
Look up student MAJOR and ROOM information based on the student NAME. Enter formula into B2. 1 NAME MAJOR ROOM 2 58 3 4 NAME MAJOR ROOM 5 $1 CIS DBH 6 S2 7 3 A/F DBH A/F DBH 8 $4 мом SCI 9 S5 мом DBH 10 56 CIS SCI 11 S7 CIS DBH 12 S8 A/F 13 S9 мом 14 S10 CIS Size Color Price Item T. 15 Size L T M 16 Color R. 17 Price 28 H. 29 30 XL R. 18
Find the managers who have given the most amount of money to a single organization. For the 3highest amounts, retrieve the manager name, organization name and total amount given. Using Mysql
Use a data set of property value from 2007 - 2019. The data contains sale price for houses and units with 1, 2, 3, 4, and 5 bedroom. The data is: date of sale; price in dollars; property type (unit or house); number of bedrooms Using R, calculate and show the mean price of the house properties and unit properties. ```{r} ```
1. List the book title and retail price for all books with a retail price lower than the averageretail price of all books sold by JustLee Books.
In light of the fact that percent is a wildcard character, how does the LIKE operator search for a literal percent sign (percent) within a character sequence?
ABC department store keeps information on departments, products, and employees. For each department, the department ID, name and office phone extension are stored. For each employee, the employee ID, and name are stored. A department can have many employees and each employee can be assigned to multiple departments. Each department is managed by one employee. Each department sells many products and each product is sold by only one department. Products can be shoes, clothes, or other miscellaneous. The product ID and price are stored for each product. No additional data is stored for the miscellaneous products. For all shoes, shoe type, shoe color and shoe size are also stored. For all clothes, the season (one of: winter, spring, summer, year-round) is stored. Clothes can be shirts, pants or dresses. For shirts, collar size, sleeve size and type are stored. For pants, waist size, length and type are stored. For dresses, size, and type are stored. Draw the Crow’s foot ERD (including all…
The file ClassificationData.xlsx (Screenshot attached below) contains the following information about the top 25 MBA programs: percentage of applicants accepted, percentage of accepted applicants who enroll, mean GMAT score of enrollees, mean undergraduate GPA of enrollees, annual cost of school (for state schools, this is the cost for out-of-state students), percentage of students who are minorities, percentage of students who are non-U.S. residents, and mean starting salary of graduates (in thousands of dollars).Use these data to divide the top 25 schools into 4 clusters, usingfor example the K-Means clustering algorithm, and interpret your clusters. The method is explained in our textbook: Section 8.8 in the Fourth and Fifth Edition or Section 14.3 in the Sixth Edition. More precisely, use Evolutionary Solver to find 4 schools to be used as cluster centers and to assign all other schools to one of these cluster centers. Each school is then assigned to the nearest cluster center,…
https://1drv.ms/x/s!Av-KKmo42J4EgXJFqbsHsb_jUdpA 1) The baseball worksheet contains US baseball player's team, position, and salary. Determine how many times the mode of baseball player’s salary is appeared in the data set? Group of answer choices 16 28 21 18 2) The baseball worksheet contains US baseball player’s team, position, and salary. Determine the shape of the distribution of baseball player’s salary and skewness value. Group of answer choices 1.84 and moderately skewed to left 1.84 and Highly skewed to right -1.84 and moderately skewed to right -1.84 and highly skewed to Left 3) The baseball worksheet contains US baseball player’s team, position, and salary. what is the second quartile of baseball player’s salary? Group of answer choices 4010021 4010054 1880000 1950347