Notesale: Turn your study into money

Document Preview

Extracts from the notes are below, to see the PDF you'll receive please use the links above

---

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

1

CONTENTS
Course
Code

Assignment No
...


For JanuaryJune 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

31st October, 2015

30th April, 2016

10

MCSL-025 MCA(II)/L-025/Assignment/15-16

Important Notes
1
...

2
...
For further details, please
refer to MCA Programme Guide
...
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)
...

4
...
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
...
Answer all the
questions
...
You may use illustrations and
diagrams to enhance the explanations
...
All the implementations
should be in C language
...


Write an algorithm for the implementation of a Dequeue
...


Implement multiple queues in a single dimensional array
...


(20 Marks)

3
...
Refer to various journals and
other online resources
...


(20 Marks)

4
...
Rest 20
marks are for viva-voce
...
Also in your programs give
appropriate comments to increase understandability
...

1
...
Describe and compare its features
...


(5 Marks)

(a)

What are the strategies followed in Windows 2000 for
backup?

(5 Marks)

What are the contents of Password files and where are they
located in Windows? Also, explain the concept of Shadow
passwords?

(5 Marks)

(a)

Name the various methods of authentication available in the
Windows 2000 operating system
...


Write step by step procedure to configure a Linux machine
to work with a network file system
...


(5 Marks)

(b)

3
...


(b)

2
...
It list all such file names having that given string and
store in a temp file “search_temp”
...
g
...


4

(10 Marks)

6
...


(a)

Compare FAT 16 and FAT 32 file systems
...


(5 Marks)

(a)

Explain the role and importance of following tools for quota
management in Linux
...


(5 Marks)

8
...
Rest 20 marks are for viva voce
...
You may use illustrations and diagrams to enhance your
explanations
...
Answer to each part of the
question should be confined to about 300 words
...


Construct an ER diagram for an Event Management System
...
Also, derive the unnormalized relational database
tables with the help of this diagram
...


Normalize the tables designed in Q1 till its requirements are
satisfied
...


Consider the following EMP table:

(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

Answer the following queries in SQL
...


Find all the ENAME’s whose salary is < Rs
...

Find total number of employees who work with
RESEARCH department
...

Count number of employees whose salary is between
Rs
...
12500
...

Find the employees whose designation is SALESMAN and
joined after 1st Aug, 1990
...

Count number of SALESMAN in SALES department
Count all the number of employees who are working with
the company
...

Sort the table by the SALARY, descending order
...

(5 Marks)

(b) Define the two principal integrity rules for the relational
model
...

5
...

Discuss types of applications suitable for hierarchical DBMS
and RDBMS
...


(7 ½ Marks)

(b) Discuss the concept of data independence and explain its
importance in a database environment
...
Rest 20
marks are for viva-voce
...
Also in your programs give
appropriate comments to increase understandability
...

1
...


(2 Marks)

Write a program to explain how array of objects may be
created in java
...


(4 Marks)

(b)

Explain followings in context of java, with the help of
examples
...


(2 Marks)

(b)

What is inheritance? Explain the advantage of inheritance
with an example program
...


(5 Marks)

(c)

3
...


(b)

2
...


(3 Marks)

(a)

What is polymorphism? Is Interfaces in Java, a kind of
polymorphism? Justify your answer with the help of an
example
...
Write a java program to
show how package is created
...


(5 Marks)

8

5
...
Explain hierarchy of different exception classes in java
...


(2 Marks)

(a)

What is I/O stream in java? Write a program in java to create
a file and copy the content of an already existing file into it
...
Make necessary assumptions and use
appropriate layout in your program
...
Also
write a program to find the length of a given string
...


(4 Marks)

(b)

What is a TCP/IP socket? Write a java program to create
socket
...


(2 Marks)

(c)

7
...


(b)

6
...


(3 Marks)

(a)

Explain basic networking features of java
...


(3 Marks)

(c)

What is servlet? Explain various ways of session management
in servlet programming
...
Answer all questions of each part
...
Lab records of each part will carry 10 marks
...
You may use illustrations and diagrams to enhance the explanations
...

PART-1: MCS-021
1
...


(5 marks)

2
...


(5 marks)

PART-2: MCS-022
1
...


(5 marks)

2
...
Connect a Printer physically to your
PC
...


Create a database consisting of Name of Alumni, Organization,
Designation, Programme of Study, Year of Passing, Enrollment
Number, Employment Status

(10 marks)

After creating the database, list the number of Alumni who have
done MCA
...


Write a program in Java for the addition of two sparse matrices
...


Write a program in Java that connects to a database and
generates a report consisting of the courses study center wise
where the student attendance to theory classes is at least 50%
...


(5 marks)

Note: You must execute the program and submit the program logic, sample inputs and
outputs along with the necessary documentation for this question
...


10



---