Write a shell script to find the day of the week when a date is given.

Perform following queries using SQL:

(i) Find details of dependents for employee having name AJAY.

(ii) Find the name of the manager of the department in which employee with ESSN Code 5078 works.

(iii) Find the name of all employees whose age is less than 18 years.

(iv) Find the DOB of the son of the employee having employee code ESSN 5078.

(v) Find the details of the departments in which the employee having employee code ESSN 5078 has worked

Write the UNIX commands for the following: (a) To display the first 10 lines in a given file.

(b) To kill a particular process with a PID.

(c) To append the contents of xyz after the contents of the abc and redirect them to a new mnp.

(d) To print the first difference between any two given files.

(e) To change the command prompt from $ to *.

(f) To grant the permissions of read, write and execute to the user and read and write only to the group and others for all the files in a current directory.

(g) To direct a standard output to any of the line printer.

(h) To list all the files in the current directory whose file names starts with c.

(i) To execute some command even after logout

(j) To split a file splittest, which is containing 20 lines into 5 lines each which are directed to four various files.

Consider the following employee database schema:

EMPLOYEE (ESSN, ENAME, DEPT_NO, SALARY) DEPENDENT (ESSN, DEPEND_NAME, RELATION, DOB) DEPARTMENT (DEPT_NO, DEPT_NAME, MANAGER)

Create the procedures for the above queries.

Write appropriate triggers, exceptions and functions for the above employee database schema.

Write a shell script to display the largest element in a given 4X4 matrix.