Saturday, 17 September 2016

NIELIT A Level Introduction to Database Management System Assignment

NIELIT A Level
Introduction to Database Management System
Assignment 12

a)Create a tables Employee with following columns :

Employee table
b)Create a table Department with following columns:

Department Table


c)Create a table project with following columns:

Project table
d)Create a table works_on with the following columns:

Works_on table

Write down following Insert Statement 

  • Using INSERT statement enter the following data in the Employee table:


employee table

  • Using INSERT statement enter the following data in the Department table:


Department Table

  • Using INSERT statement enter the following data in the Project table:

Project table
  • Using INSERT statement enter the following data in the works_on table : 


works_on table

SQL Statement Assignment 
  1. See the records of all the tables with SELECT command.
  2. List the Employee number of all the clerks.
  3. Get the employee numbers for all employees who have a leading job ( Analyst or
  4. Manager) in project P1.
  5. Get the employee number and first name of all employees whose first name starts
  6. with A.
  7. Find the employee details having Maximum salary.
  8. Find the employee details having second highest salary.
  9.  Insert the data of a new employee called Jullia Long , whose employee number is
  10. 11111. Her department no is not known yet.
  11. Change the name of the department of the employee James .The new department name is Sales.
  12. Find the employee number for all employees who are clerks or works in Department D3.
  13. Create a table Sample and get all the record from employee table with select statement.
  14. Alter table sample , add new column Telephone_no char(12) null.
  15. Drop the Column Telephone_no from Sample table.
  16. Get the list of all the employee except the employees having emp_no either 10102 or 9031.
  17. List the name of the project whose budget lies between 95000 to 12000.
  18. Get the names of all the employees whose first name contains the letter “a” as the second character.
  19. Get Full details of all the employees whose departments are located in Dallas.
  20. Get all jobs of the employees.
  21. List the project numbers for all the projects employing less than four persons.



Next Assignment