Write the UNIX commands for the following:
(a) To print the calendar for the current month.
(b) To append the contents of file1 after the contents of the file2 and redirect them to a new file3.
(c) To print the first difference between any two given files.
(d) To change the command prompt from $ to !.
(e) To grant the permissions of r w x to the user and read, execute permissions to the group and others for all the files in a current directory.
(f) To direct a standard output to any of the line printer.
(g) To list all the files in the current directory whose file names starts with f.
(h) To execute some command even after logout.
(i) To split a file splittest, which is containing 20 lines into 5 lines each which are directed to four various files.
(j) To display the last 2 lines in a given text file.

 

Write appropriate triggers, exceptions and functions for the above study centre management system database schema and describe them briefly.

Write a shell program to count number of characters, number of lines and no. of other symbols in a given file.

Perform following queries using SQL:

(i) Find the name of the programmes those are been activated in the given study centre = “111”.
(ii) Find the no. of fresh admission students in MCA and BCA programmes for Jan-2023 session allotted to study centre = “456”.
(iii) Display the corresponding Regional Centre Code if the study centre code is given.
(iv) Display the list of all the academic counsellors who are counselling for MCSL-045 course.
(v) Display the total no. of assignments received in the current session for the MCSL-045 course.

Write a shell script to convert all the lower case letters to uppercase in a given text file.

Create an appropriate database for a study centre management system. (Perform Normalization till the required levels) with meaningful data of 10 records each per table

Write the UNIX commands for the following:
(a) To print the calendar for the current month.
(b) To append the contents of file1 after the contents of the file2 and redirect them to a new file3.
(c) To print the first difference between any two given files.
(d) To change the command prompt from $ to !.
(e) To grant the permissions of r w x to the user and read, execute permissions to the group and others for all the files in a current directory.
(f) To direct a standard output to any of the line printer.
(g) To list all the files in the current directory whose file names starts with f.
(h) To execute some command even after logout.
(i) To split a file splittest, which is containing 20 lines into 5 lines each which are directed to four various files.
(j) To display the last 2 lines in a given text file.

Write a shell script to find whether the given year is a leap year or not.