Scribd
Upload
3 views8 pages

DBMS Lab: Employee Data Analysis Tasks

The document contains instructions for exercises using an "Employee" table created in a DBMS lab. It instructs to create the table with fields like Empid, department, grade, salary, bonus points and insert 10-20 records with Empid as the primary key. It then lists queries to run on the table like listing employees in the "Testing" department, calculating average salary in "HR" department, counting employees in "Development" department with grade "B" and more.

Uploaded by

ꯚꯤꯛ ꯊꯣꯏ
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3 views8 pages

DBMS Lab: Employee Data Analysis Tasks

The document contains instructions for exercises using an "Employee" table created in a DBMS lab. It instructs to create the table with fields like Empid, department, grade, salary, bonus points and insert 10-20 records with Empid as the primary key. It then lists queries to run on the table like listing employees in the "Testing" department, calculating average salary in "HR" department, counting employees in "Development" department with grade "B" and more.

Uploaded by

ꯚꯤꯛ ꯊꯣꯏ
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Regno-19bps1006

Name-vikrant
Subject-dbms lab
Ex. 3 DML
13-12-19
Create table “Employee” and insert atleast 10-20 records. Set Empid as primary key.

Empid :

1. List the employee details in “ Testing“ department.


2. Calculate the average salary of all employees in “HR” department
3. Count number of employees in “ Developement” department and with “B” grade.
4. Calculate the total salary of all employees

5. Find the Lowest salary in “HR” department.


6. List the employee details who got the minimum bonus points

.How many employee earn salary more than 45000


Count number of employees in each department
.List the emp ID and name for all department whose salary is more than average.

. List the departments in which the average salary of the employees is greater than 40,000

You might also like