Question

Digital Infratech is a BPO Company. Its management has decided to use DBMS to
store all the data. You are hired by the company as its Database Administrator. Your
first assignment is to provide database support for storing/managing the data of all
its employees. Consider the following sample data and write SQL commands for the
following:
EMP_ID NAME GENDER DEPARTMENT SALARY
E101 RAJ DOGRA M FINANCE 20000
E102 SHIVANSH SINGH M IT 23000
E103 PRIYA ARORA F HR 60000
E104 SHIVAM GUPTA M FINANCE 55000
E105 GARIMA NEGI F IT 24000
E106 SHWETA SHARMA F SALES 34000
E107 SHREYA ANAND F IT 15000
E108 PRATEEK MITTAL M SALES 22000
E109 AKSHAY SHARMA M FINANCE 43000
E110 RADHIKA GARG F SALES 64000
E111 DEEP SINGH M SALES 78000
E112 SHEETAL GUPTA F FINANCE 35000
E113 RAJ KUMAR M HR 46000
E114 PAYAL GOEL F IT 72000
E115 DIKSHA SHARMA F SALES 45000
1. Create the table analyzing the sample data given. Identify and create the Primary
Key too.
2. ‘ROHAN VERMA’ has joined SALES department with a salary of Rs.25000. Insert a
record for him in the table.
3. The management of the company wants to get a report displaying all the names of the
employees sorted in descending order of their department name. Help the
management to do so.
4. ‘DIKSHA SHARMA’ has given an application to the management to correct the spelling
of her name to ‘DEEKSHA VERMA’. Do the needful.
Prepared by : Mrs. Rachna Khatri Page 2 of 2
SECOND TERM PROJECT WORK - DBMS
5. The management of the company has decided to increase the salary of all the
employees by 30%. Help the management to do so.
6. The management of the company wants to get a report displaying all the details of the
employees whose salaries are in the range of Rs. 20000 – Rs. 30000.
7. ‘RADHIKA GARG’ has resigned and is no longer the part of the company. How will you
delete her record from the database?
8. The management of the company has decided to reduce the salary of all the employees
of HR and SALES departments by 20%. Help the management to do so.
9. The management of the company wants to get a report displaying the details of the
female employees having salary more than Rs. 20000. Help the management to do so.
10. The management of the company wants to find out if they increase the salary of the
employees by IT department by 2500, what will be their new salaries. Help the
management to do so.
11. The management of the company wants to store the punctuality status of its
employees (whether punctual or not). Help the management to do so.
12. The management of the company wants to find out the details of the employees with
codes E104, E109, E106 and E119. Help the management to do so.
13. The company noticed that the names of the departments are too small and the field
to store it is of much larger size. Change the size of the field so that it can store 10
characters only.
14. The management of the company wants to delete all the records of the table. Help the
management to do so.
15. The management of the company decides to delete the table EMPLOYEE. Help the
management to do so.

546a27ebde88322f2f64156dfeb91f86.pdf

Answer 1

Prevalent factors like illiteracy levels, lack of general resistance due to malnutrition, lack of access to health care, lack of job opportunities, lack of access to safe drinking water, sanitation, etc., are the social indicators of poverty as seen by social scientists.

Answer 2

Answer:

pdf is not opening...........