Course Code : MCSL-045
Course Title : UNIX and DBMS Lab
Assignment Number : MCA(IV)/045/Assignment/2018-19
Maximum Marks : 100
Weightage : 25%
Last Date of Submission : 15th October, 2018 (for July session)
15th April, 2019 (for January session)
The assignment has two parts A and B. Answer all the questions. Each part is for
20 marks. UNIX and DBMS lab record carries 40 Marks. Rest 20 marks are for
viva voce. You may use illustrations and diagrams to enhance the explanations.
Please go through the guidelines regarding assignments given in the MCA
Programme Guide for the format of presentation. If any assumptions made,
please state them.
Write the UNIX commands for the following:
(a) To wait for a specified number of seconds before exit.
(b) To arrange to print a file on the line printer without making you wait for the
command to finish.
(c) What are the differences among the following three commands?
i. cat file | pr
ii. pr < file
iii. pr file
(d) To change the command prompt from $ to ?.
(e) To grant the permissions of read, write and execute to the user and read only
to the group and others for any file using chmod.
(f) To direct a standard output to any file.
(g) To print all the filenames in the current directory that doesn’t contain the temp.
(h) To list all the filenames that others can read and write.
(i) To split a file test, which is containing 100 lines into 25 lines each.
(j) To display those lines that are common to file1 and file2.
(a) Write a shell program to translate all the lower case letters in any text file to
the upper case letters. (5 Marks)
(b) Given the filename by the user as the input, write a shell script to display the
first five lines of the file. (5 Marks)
(c) Write a shell script to display the list of the files whose filename consists of 4
characters (with any file extension) and filename starts with the alphabet f.
Design a database for maintaining inventory of a retail shop. You are required to
perform the following activities for the maintenance of the above:
(a) Create the database. (2 Marks)
(b) Write the following queries using SQL: (4 Marks)
(i) Find the details of the items whose sales have exceeded Rs. 2,00,000.
(ii) Find the details of the six items in terms of numbers/quantity in
alphabetical order that have got the maximum sale.
(iii) Find the names of those items that have an overall sale of 40% of what
have been procured.
(iv) Create a view of the items for the manager showing overall
performance of the week for each item.
(c) Create the procedures for the queries (i) to (iii) above. (3 Marks)
(d) Perform the following activities:
(i) Create a trigger that prints the daily catalog on change of a price of an
item. (2 Marks)
(ii) Create a trigger that increases the price of a specific item by a certain
percentage on a specific weekend. (3 Marks)
(e) Create a transaction that finds the total items sold per week and prints the
overall revenue generated. (3 Marks)
(g) Create two different types of users: the first user – a manager who can see
reports and change the items and its price value and second user who sells