Course Code : MCSL-045
Course Title : UNIX and DBMS LAB
Assignment Number : MCA (4)/L045/Assign/12
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 31st October, 2012 (For July 2012 Session)
30th April, 2013 (For January 2013 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.
Question 1:
Write the UNIX commands for the following:
(a) To print the calendar for the current month.
(b) To append the contents of file2 after the contents of the file1 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 execute only permission 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 first 2 lines in a given file.
(5 Marks)
Question 2:
(a) Write a shell program to count no. of other symbols in a given file by the user.
(5 Marks)
(b) Write a shell script to find the difference between any two given dates.
(5 Marks)
(c) Write a shell script to display the smallest element in a given 2X2 matrix.
(5 Marks)
PART-II: MCS-043
Question 1:
(a) Create an appropriate database using Oracle for a study centre management system. (Perform Normalization till the required levels)
(10 Marks)
(b) Perform following queries using SQL:
(5 Marks)
(i) Find the name of the programmes those are been activated in the given study centre.
(ii) Find the no of students in BCA programme for the current year.
(iii) Display the corresponding Regional Centre Code if the study centre code is given.
(iv) Display the list of all the academic counsellors of MCA programme.
(v) Display the total no. of assignments received in the current session for the MCSL-045 course.
(c) Write appropriate triggers, exceptions and functions for the above study centre management system database schema and describe them briefly.
(5 marks)
IGNOU Coaching for BCA, MCA, MBA in Jaipur
Course Title : UNIX and DBMS LAB
Assignment Number : MCA (4)/L045/Assign/12
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 31st October, 2012 (For July 2012 Session)
30th April, 2013 (For January 2013 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.
PART-I: MCS-041
Write the UNIX commands for the following:
(a) To print the calendar for the current month.
(b) To append the contents of file2 after the contents of the file1 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 execute only permission 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 first 2 lines in a given file.
(5 Marks)
Question 2:
(a) Write a shell program to count no. of other symbols in a given file by the user.
(5 Marks)
(b) Write a shell script to find the difference between any two given dates.
(5 Marks)
(c) Write a shell script to display the smallest element in a given 2X2 matrix.
(5 Marks)
PART-II: MCS-043
Question 1:
(a) Create an appropriate database using Oracle for a study centre management system. (Perform Normalization till the required levels)
(10 Marks)
(b) Perform following queries using SQL:
(5 Marks)
(i) Find the name of the programmes those are been activated in the given study centre.
(ii) Find the no of students in BCA programme for the current year.
(iii) Display the corresponding Regional Centre Code if the study centre code is given.
(iv) Display the list of all the academic counsellors of MCA programme.
(v) Display the total no. of assignments received in the current session for the MCSL-045 course.
(c) Write appropriate triggers, exceptions and functions for the above study centre management system database schema and describe them briefly.
(5 marks)
IGNOU Coaching for BCA, MCA, MBA in Jaipur
BCA Coaching in Jaipur | MCA Coaching in Jaipur
IGNOU JAIPUR
Regional Director,
IGNOU Regional Centre,
70/79,
Sector - 7,
Patel Marg,
Mansarovar
Rajasthan - 302020
India
Ph :+91-0141-2785763 / 2785750
Fax :+91-0141-2784043
IGNOU Regional Centre,
70/79,
Sector - 7,
Patel Marg,
Mansarovar
Rajasthan - 302020
India
Ph :+91-0141-2785763 / 2785750
Fax :+91-0141-2784043
1 comments:
plsssss send me mcs45 assignment solution
Post a Comment