Create the procedures for the above queries.
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 appropriate database.
Write a shell script to find the day of the week when a date is given.
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.
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.
Write a shell program to count no. of lines, no. of blank spaces and no. of characters and number of words in a given file by the user.