Cheap and Secure Web Hosting Provider : See Now

Assignment MCA 2nd semester 2016-2017


We recommend you to search for the uploaded assignments. In search box. If you did not find the desired assignment, please comment or subscribe the newsletter.

Thanks


MASTER OF COMPUTER
APPLICATIONS (MCA)
MCA/ASSIGN/SEMESTER-II
ASSIGNMENTS
(July - 2015 & January - 2016)
MCS-021, MCS-022, MCS-023, MCS-024, MCSL-025
SCHOOL OF COMPUTER AND INFORMATION SCIENCES INDIRA GANDHI NATIONAL OPEN UNIVERSITY MAIDAN GARHI, NEW DELHI – 110 068
CONTENTS
Course
Assignment No.
Submission-Schedule
Page
Code



No.


For July-
For January-



December
June Session



Session







MCS-021
MCA(II)/021/Assignment/15-16
15th October, 2015
15th April, 2016
3





MCS-022
MCA(II)/022/Assignment/15-16
15th October, 2015
15th April, 2016
4





MCS-023
MCA(II)/023/Assignment/15-16
15th October, 2015
15th April, 2016
6





MCS-024
MCA(II)/024/Assignment/15-16
15th October, 2015
15th April, 2016
8





MCSL-025
MCA(II)/L-025/Assignment/15-16
31st October, 2015
30th April, 2016
10





Important Notes
1.Submit your assignments to the Coordinator of your Study Centre on or before the due date.
2.Assignment submission before due dates is compulsory to become eligible for appearing in corresponding Term End Examinations. For further details, please refer to MCA Programme Guide.
3.To become eligible for appearing the Term End Practical Examination for the lab courses, it is essential to fulfill the minimum attendance requirements as well as submission of assignments (on or before the due date). For further details, please refer to the MCA Programme Guide.
4.The viva voce is compulsory for the assignments. For any course, if a student submitted the assignment and not attended the viva-voce, then the assignment is treated as not successfully completed and would be marked as ZERO.
2
Course Code
:
MCS-021
Course Title
:
Data and File Structures
Assignment Number
:
MCA(II)/021/Assignment/15-16
Maximum Marks
:
100

Weightage
:
25%
Last Dates for Submission
:
15th
October, 2015 (For July 2015 Session)


15th
April, 2016 (For January 2016 Session)
This assignment has four questions which carry 80 marks. Answer all the questions. Each question carries 20 marks. You may use illustrations and diagrams to enhance the explanations. Please go through the guidelines regarding assignments given in the Programme Guide. All the implementations should be in C language.
1.
Write an algorithm for the implementation of a Dequeue.
(20 Marks)
2.
Implement multiple queues in a single dimensional array. Write
(20 Marks)

algorithms for various queue operations for them.

3.
Write a note of not more than 5 pages summarizing the latest
(20 Marks)

research in the area of “Trees”. Refer to various journals and


other online resources. Indicate them in your assignment.

4.
What are AVL trees? What are Red-Black trees? What are the
(20 Marks)

differences between them?

3
Course Code
:
MCS-022
Course Title
:
Operating System Concepts and


Networking Management
Assignment Number
:
MCA(II)/022/Assignment/15-16
Maximum Marks
:
100
Weightage
:
25%
Last Dates for Submission
:
15th October, 2015 (For July 2015 Session)


15th April, 2016 (For January 2016 Session)
There are eight questions in this assignment which carried 80 marks. Rest 20 marks are for viva-voce. Answer all the questions. Also in your programs give appropriate comments to increase understandability. Please go through the guidelines regarding assignments given in the Program Guide for the format of presentation.
1.
(a) What is the significance of VPN? Name some VPN
(5 Marks)

technologies supported by Windows 2000.


(b) Write step by step procedure to configure a Linux machine
(5 Marks)

to work with a network file system.

2.
(a) List any two existing virus protection tools available today in
(5 Marks)

the Market for Windows. Describe and compare its features.


(b) Describe the process of sharing network in Linux and
(5 Marks)

Windows 2000.

3.
(a) What are the strategies followed in Windows 2000 for
(5 Marks)

backup?


(b) What are the contents of Password files and where are they
(5 Marks)

located in Windows? Also, explain the concept of Shadow


passwords?

4.
(a) Name the various methods of authentication available in the
(5 Marks)

Windows 2000 operating system.


(b) How would you set the IP address of a LAN card in
(5 Marks)

LINUX?

5.
(a) Write a shell script that searches the file contents in a
(10 Marks)

directory and its sub-directories for a text string given by the


user. It list all such file names having that given string and

store in a temp file “search_temp”. It should have user friendly messages e.g. “File does not exit” , “Do you want to search again”, etc.
4
6.
(a) How Linux and Windows 2000 manage the domains? Also,
(10
Marks)

explain how trust relationship is created and managed



between domains in Windows 2000?


7.
(a) Compare FAT 16 and FAT 32 file systems.
(5 Marks)

(b) Discuss the features of GNOME configuration tool.
(5 Marks)
8.
(a) Explain the role and importance of following tools for quota
(5 Marks)

management in Linux.



(b) List and describe the various security features in Linux.
(5 Marks)
5
Course Code
:
MCS-023
Course Title
:
Introduction to Database Management


Systems
Assignment Number
:
MCA(II)/023/Assignment/15-16
Maximum Marks
:
100

Weightage
:
25%
Last Dates for Submission
:
15th
October, 2015 (For July 2015 Session)


15th
April, 2016 (For January 2016 Session)
This assignment has five questions of 80 marks. Rest 20 marks are for viva voce. Answer all questions. You may use illustrations and diagrams to enhance your explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation. Answer to each part of the question should be confined to about 300 words.
1.
Construct an ER diagram for an Event Management System.
(20 Marks)

Clearly indicate the entities, relationships, cardinality and the key

constraints. Also, derive the unnormalized relational database



tables with the help of this diagram.




2.
Normalize the tables designed in Q1 till its requirements are
(20 Marks)

satisfied.






3.


(1 x 15 = 15 Marks)







ENAME
DEPT-NAME
DESIGNATION
SALARY DATE-OF-JOIN


KARAN
ACCOUNTING
DIRECTOR
50000
Nov 17, 2012









FARAH
RESEARCH
ANALYST
30000
Dec 03, 1991









SCINDIA
RESEARCH
ANALYST
30000
Dec 09, 2002


JOY
RESEARCH
MANAGER
29750
Apr 02, 2011


BHASKAR
SALES
MANAGER
28500
May 01, 1999


CHANDER
ACCOUNTING
MANAGER
24500
Jun 09, 2000









ANIL
SALES
SALESMAN
16000
Feb 20, 1991


TOMAR
SALES
SALESMAN
15000
Sep 08, 2001


MILIND
ACCOUNTING
CLERK
13000
Jan 23, 2002


SAXENA
SALES
SALESMAN
12500
Sep 28, 1999









TOMAR
SALES
SALESMAN
14500
Feb 22, 1997


ANAND
RESEARCH
CLERK
11000
Jan 12, 1993


GEORGE
SALES
CLERK
9500
Dec 03, 1990


SURESH
RESEARCH
CLERK
8000
Dec 17, 1992









6
4.(a) Discuss the advantages and disadvantages of hierarchical database management system in comparison with RDBMS. Discuss types of applications suitable for hierarchical DBMS and RDBMS.
(b)Define the two principal integrity rules for the relational model. Discuss why it is desirable to enforce these rules.
5.(a) Describe the main aims of the conceptual, logical and physical database design phases.
(b)Discuss the concept of data independence and explain its importance in a database environment.
7
(5 Marks)
(5 Marks)
(7 ½ Marks)
(7 ½ Marks)
Course Code
:
MCS-024
Course Title
:
Object Oriented Technologies and Java
Assignment Number
:
MCA(II)/024/Assignment/15-16
Maximum Marks
:
100
Weightage
:
25%
Last Dates for Submission
:
15th October, 2015 (For July 2015 Session)


15th April, 2016 (For January 2016 Session)
There are eight questions in this assignment which carried 80 marks. Rest 20 marks are for viva-voce. Answer all the questions. Also in your programs give appropriate comments to increase understandability. Please go through the guidelines regarding assignments given in the Program Guide for the format of presentation.
1.
(a)
What is Object Oriented Programming? Explain features of
(5 Marks)


Object Oriented Programming .


(b)
What is platform independence? Explain why java is platform
(2 Marks)


independent.


(c)
Write a program to explain how array of objects may be
(3 Marks)


created in java.

2.
(a)
Write a java program to demonstrate use of different data
(4 Marks)


types available in java.


(b)
Explain followings in context of java, with the help of
(6 Marks)


examples.



(i)
Class and objects



(ii)
Abstraction and encapsulation



(iii) Application program and applet program

3.
(a)
What is static variable and static method? Explain why main
(2 Marks)


method in java is always static.


(b)
What is inheritance? Explain the advantage of inheritance
(5 Marks)


with an example program. What are different types of



inheritance supported by java?


(c)
Explain the steps involved in creating a distributed
(3 Marks)


application using Remote Method Invocation (RMI).

4.
(a)
What is polymorphism? Is Interfaces in Java, a kind of
(2 Marks)


polymorphism? Justify your answer with the help of an



example.


(b) Explain the need of package in Java. Write a java program to
(3 Marks)


show how package is created.


(c)
What is rule of accessibility? Explain different level of
(5 Marks)


accessibility in java.




8

5.
(a)
What is abstract class? Explain need of abstract class with the
(2 Marks)


help of an example.


(b)
What is an exception? Explain haw an exception is handled in
(6 Marks)


Java. Explain hierarchy of different exception classes in java.



Also explain why is it not necessary to handle runtime



exception?


(c)
Write a java program to create two threads with different
(2 Marks)


priority.

6.
(a)
What is I/O stream in java? Write a program in java to create
(4 Marks)


a file and copy the content of an already existing file into it.


(b)
Create an Applet program to display your brief profile with
(4 Marks)


your photograph. Make necessary assumptions and use



appropriate layout in your program.


(c)
Differentiate between String and StringBuffer classes. Also
(2 Marks)


write a program to find the length of a given string.

7.
(a)
What is need of layout manager? Explain different layouts
(4 Marks)


available in java for GUI programming.


(b)
What is a TCP/IP socket? Write a java program to create
(3 Marks)


socket.


(c)
Explain the need of JDBC? Explain steps involved in
(3 Marks)


connecting a databases using JDBC.

8.
(a)
Explain basic networking features of java.
(2 Marks)

(b)
What are principles of event delegation model? Explain
(3 Marks)


different sources of events and event listener.


(c)
What is servlet? Explain various ways of session management
(5 Marks)


in servlet programming.

9
Course Code
:
MCSL-025
Course Title
:
Lab Course
Assignment Number
:
MCA(II)/L-025/Assignment/15-16
Maximum Marks
:
50
Weightage
:
25%
Last Dates for Submission
:
31st October, 2015 (For July 2015 Session)


30th April, 2016 (For January 2016 Session)
This assignment has four parts. Answer all questions of each part. Each part is of 10 marks. Lab records of each part will carry 10 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 Programme Guide for the format of presentation.

PART-1: MCS-021

1.
Write a program in C language for addition of two numbers
(5 marks)

which have at least 20 digits each.

2.
Write a program in C language that will accept a Graph as input
(5 marks)

and will generate its Minimum Cost Spanning Tree.


PART-2: MCS-022

1.
Write a shell script in Linux/Unix that accepts a text file as
(5 marks)

input and prints the number of words in the file which have at


least one vowel as output.

2.
Your PC is on a network. Connect a Printer physically to your
(5 marks)

PC.


PART-3: MCS-023

1.
Create a database consisting of Name of Alumni, Organization,
(10 marks)

Designation, Programme of Study, Year of Passing, Enrollment


Number, Employment Status


After creating the database, list the number of Alumni who have


done MCA.


PART-4: MCS-024

1.
Write a program in Java for the addition of two sparse matrices.
(5 marks)
2.
Write a program in Java that connects to a database and
(5 marks)

generates a report consisting of the courses study center wise


where the student attendance to theory classes is at least 50%.


Make assumptions wherever necessary.

Note: You must execute the program and submit the program logic, sample inputs and outputs along with the necessary documentation for this question. Assumptions can be made wherever necessary.
10

0 comments:

Post a Comment

Let us know your responses and feedback