Pages

Tuesday, 26 June 2012

PGDCA/MCA 1st Year ASSIGNMENTS

 

MASTER OF   COMPUTER APPLICATIONS

(PGDCA/MCA 1st Yr)


           





ASSIGNMENTS
Year 2012



















JAIPUR NATIONAL UNIVERSITY
JAIPUR



 
 








Course Code
:
PGDCA/MCA – 101
Course Title
:
Fundamental of Computer
Maximum Marks
:
30



There are Three questions in this assignment. Answer all questions. All questions
are equal marks.

Q.1 a) Write a note on
a)      Third generation computers.
b)      Write the applications of computer in business.
c)      With a neat diagram, explain the functional unit of computer.
d)     Explain application software.


Q.2 a)  Write notes on :

a) RAM and ROM

b) Optical media.

c) What are sign numbers and explain the conditions of overflow and underflow by  
                    using 2’s complement?.

                   b) Explain different items in desktop.

c)       LAN and WAN 

d)      What is a transmission mode? Explain various transmission modes of data.

Q 3. Write notes on :

a) Computer virus

b) E-mail.

                c) Topologies

                d) De Morgan’s Theorem




Course Code
:
PGDCA/MCA – 102
Course Title
:
PC Software
Maximum Marks
:
30

There are three questions in this assignment.  Answer all the questions.  All Questions are equal marks.  

Q.1 (a) What is Mail Merge?  Write all steps to create mail merge.

       (b)  Write short note on.
                 (a) Goal Seek 
                 (b) Function in Excel
                  (c) Differentiate between VLOOKUP() AND HLOOKUP() functions in MS_EXCEL.
               
       (c)  Define Macro.  Write steps to create Macro.

Q.2 (a) What is a template ? Explain with an example.

       (b) Explain the process of Auto Correct.

       (c) Write steps to perform the following tasks:-
              (i)  Setting up a mail account
              (ii) Applying stationery
              (iii) Sending & Receiving Mails
              (iv) Creating a contact in Address Book

Q.3 (a) Explain the ways to apply transition in slides.

       (b) How do you draw different shapes using AutoShapes.

       (c) Explain the process to insert sound & Image in Power Point Presentation.

 


Course Code
:
PGDCA/MCA – 103
Course Title
:
Database Management System
Maximum Marks
:
30

There are three questions in this assignment.  Answer all the questions.  All Questions are equal marks.  
Q.1 (a)  List Five Responsibilities of the DB manager.

        (b) Give the limitations of E-R model? How do you overcome this?

        (c)  What are the types of transparencies that a distributed database must support? Why?

Q.2 (a)  What is an active database?
       
        (b) (i) Highlight the features of object oriented database 
              (Ii) Compare file system with database system (

        (c) Explain the architecture of DBMS. (

Q.3 (a) What are the steps involved in designing a database application? Explain with an
                   application.

        (b) What is Normalization? Explain 1NF, 2NF, 3NF and BCNF with suitable example

        (c) What is concurrency control? How is it implemented in DBMS? Explain.












Course Code
:
PGDCA/MCA – 104
Course Title
:
Programming in ‘C’ & Data Structure
Maximum Marks
:
30

There are three questions in this assignment.  Answer all the questions.  All Questions are equal marks.  

Q1 (a)  Differentiate between call by value & call by reference.  Explain recursive function with
             an example.

       (b) Write a ‘C’ program to find a second largest number from the single array of 10 values. 

      (c)  What are pre-processor directives?  And also define command line arguments?


Q.2 (a) Create a structure student with data members roll no., name, and write a program to read & display data of 5 students?

        (b) Explain user define function?  Differentiate between user defined & Library function? 

        (c)  Write a ‘C’ program to find largest between 3 numbers using recursive function.

Q3 (a) Describe stack and write algorithm for push and pop operations.

       (b) What are the difference between tree and binary tree? Give an example to differentiate  
              pre-order and post order traversals.

       (c) Define push table? Describe the difference between quick sort and merge sort with an
             example






Course Code
:
PGDCA/MCA – 105
Course Title
:
Operating System Principles
Maximum Marks
:
30

There are three questions in this assignment.  Answer all the questions.  All Questions are equal marks.  
Q1 (a) Define file. Discuss various file operations including file structure, file sharing and
            file protection.

      (b) Define deadlock. What are the different methods to solve the deadlock problem?
            Explain deadlock prevention algorithms.

       (c) What is operating system? Describe the following operating system:-
             (i) Batch processing system            (ii) Time sharing system
             (iii) Real time system                       (iv) Personal Computer system

Q2 (a) Explain the following:-
(i)     Paging
(ii)   Segmentation
(iii) Swapping
(iv)  Fragmentation
       (b) Explain First Fit, Best Fit and Worst Fit allocation algorithm.

      (C) Define the concept of demand paging. Explain hardware support for demand
             paging.

Q3 (a) Explain the following page replacement algorithm:-
(i)     FIFO          
(ii)   LRU
(iii) Optimal
(iv)  Second chance algorithm
 (b) What do you understand by I/O Interface. Explain various I/O techniques.

 (c) What is disk scheduling? Explain FCFS and SSTF scheduling techniques. 






Course Code
:
PGDCA/MCA – 106
Course Title
:
Computer Networks & Internet Concept
Maximum Marks
:
30

 

There are three questions in this assignment.  Answer all the questions.  All Questions are equal marks.  
                                                           
Q1 (a) What is OSI security architecture? Explain different approaches of security model
            and different phases of security lifecycle.

      (b) What do you mean by E-Commerce? How computer is useful in e-governance and
            common public services?

      (c) What is digital signature? Explain the properties and requirements of digital
            signature.

Q2 (a) Define a  Virus? What are the typical phases of operation of virus or worms?
            Differentiate between Trojan horse, Virus and worms.

      (b) Explain the following:
(i) IP Address
(ii) URL
(iii) DNS
(iv) Subnet Mask

       (c) Explain the ATM reference model. Define ATM virtual circuit.

Q3 (a) Distinguish between peer to peer and client server network. Explain advantage
            and disadvantage of Network.

      (b) Differentiate between IEEE 802.3, 802.4 and 802.5 standards. Explain frame
            format of the above.

      (c) Write short notes on :-
(i)     FTP
(ii)   DHCP
(iii) NFS
(iv)  SMTP
(v)    TCP/IP





Course Code
:
PGDCA/MCA – 107
Course Title
:
System Analysis & Design
Maximum Marks
:
30

There are three questions in this assignment.  Answer all the questions.  All Questions are equal marks.  

 

Q1 (a) Why is data processing essential? Explain advantage and disadvantages of manual
            and electronic data processing comparing them.

      (b) What do you mean by nature of information and principal source of information?

      (c) What are the measures of Physical security? Explain it?

Q2 (a) What is system development life cycle? How it is related to system analysis?
            Differentiate between system analysis and system designing.

       (b) Define the system. Explain its features. Describe the different types of systems.

       (c) What do you mean by system testing? What are the levels of quality assurance?
             Explain briefly.

Q3 (a) How many types of software’s are there? Explain the various phases of hardware
            and software selection processes.

      (b) What do you mean by system security? What are the measures of physical
            security? Explain.

       (c) What is normalization? Explain different forms of normalization? 








Course Code
:
PGDCA/MCA – 108
Course Title
:
OOP’s Programming Using in ‘C++’
Maximum Marks
:
30

 

There are three questions in this assignment.  Answer all the questions.  All Questions are equal marks.  
Q1 (a) What is polymorphism? What are the difference between compile time and run
            time polymorphism?

       (b) Explain different types of data types with example.

       (c) What is virtual base class? How do you pass base class constructors in the
             derived class?

Q2 (a) What is inheritance? Explain various types of inheritances with example to
             show inheritance.

      (b) What are manipulators? How do you use manipulators to format I/O? Explain.

      (c) What is constructor? Explain default constructor and implicit constructor? Give an
            example to declare multiple constructor in a class.

Q3 (a) What is inline function? What is difference between friend function and inline
             function?

     (b) What is function overloading and operation overloading? Give a suitable example
           to show the both types of overloading.
   
      (c) Write short notes on :-
(i)     Recursion
(ii)   Command line arguments
(iii) Storage class specifies


Friday, 22 June 2012

Web-Based Computing


Web-Based Computing

Web has become ubiquitous

PCs most prevalent devices

More devices becoming networked to allow web access

New category of devices to manage web traffic among similar servers: load balancers

Use of operating systems like Windows 95, client-side, have evolved into Linux and Windows XP, which can be clients and servers