Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Program That Accepts a Number in Decimal Format and Prints in Reverse Order Words - PDF

VIEWS: 28 PAGES: 56

Program That Accepts a Number in Decimal Format and Prints in Reverse Order Words document sample

More Info
									                                   MCA (Revised)
                     Tefrr-End Practical Examination
                                  Decembet, 2006

                                   AND WEB DESIGN
                            CONCEPTS
            MCSL-016 INTERNET
                   :

Time allowed:2 hours                                                        Maximum Marks: 50


 Note:      There are two questionsin this paper carrying 20 marks eoch. 70 morks ore t'or
            uiua-voce.


1.   Createa form in HTMI- to fill up an examinationform and perform the validationchecksusing
     JavaScript.                                                                               20

     .      Name : Text Box

     .      Program : Combo Box

     .      Enrolment Number : Text Box

     .      SubjectCode : Combo Box

     Note :

     (i)    Enrolment Number should be minimum of 10 digits.

     (ii)   Subject Code should be alphanumeric, not exceeding six characters.


2.   Write a code in HTML to design a page with two frames. The frames should remain
     proportionate even when the page is resized.                                    20




MCSL-o6P/S
      1   1                                                                                5,OOO
                                           MCA (Revised)
                        Term-End Practical Examination
                                          December, 2006

             MCSL-016: INTERNETCONCEPTSAND WEB DESIGN

Timeallowed:2hours                                                                Maximum Marks: 50


     Note:   There are two questionsin this paper carrying 20 marks each. 70 morks are for
             uiua-uoce.


l.     Design a web page having a forrn as given below to purchasea plane ticket :                     20

       .     Flight Number -     Text Box

       r     Starting from -    Combo Box

       r     Destination-      Combo Box

       .     Credit Card -     Text Box

       r     Date of joumey -     Combo Box
                                  (one for each :
                                  day, month and year)

       Also perform validation checks on Flight Number, Date of joumey and Credit Card (it should
       not exceed 15 digits) using VBScript.


2.      Create a home page of your regional centre in the following format :                           20

                        Regional Centre Information

              Program link                          I Information
              No. of Study Centre
              Examinationrelated matters

        On clickingthese links, appropriate information shouldbe displayedin the Information column.




 MCSL-o16P/S2                                                                                     4,000
                                       MCA (Revised)
                        Term-End Practical Examination
                                     December, ?OOG

             MCSL-016 INTERNET
                    :               AND WEB DESIGN
                             CONCEPTS

Timeallowed:2hours                                                               Mqximum Mqrks : 50


 Note : There are two questions in fhis paper carrying 20 marks each. 70 marks are lor
        uiua-uoce.


1.   (i)     Write HTML code to develop a web page with the following format :

                                   Framel

                   FrameZ    Frame3     Frame4    Frame5

     (ii) . Creale a text box in frame 2, 3 and 4 and a text box and a button in framel.

     liii)   Clicking the button in framel, addition of numbersgiven in frame2, frame3 and frame4
             should be displayedin frameL.

     (iv) Insert an image in frameS.                                                                20


2.   Using Jarnscript, create a web page having 3 image files insertedon it, which switch between
     one another as the mouse points over the image and also its backgroundcolour changes.        20




MCSL-o16P/S3                                        1                                          2,000
                                       MCA (Revised)
                         Term-End Practical Examination
                                      December, 2006

                     :               AND WEB DESIGN
                              CONCEPTS
              MCSL.O16 INTERNET
                                                                              Maximum Mqrks: 50
Timesllowed:2hours

                                                                            L0 morks are for
 Note :       There are two questions in this paper carrying 20 marks each'
              uiua-uoce.

                                                                                                 20
1.   write HTML code to generatethe following output :

                    Weather        Today's Weather
        \
      City                     Max.            Min.
                \

      Delhi

         Shimla

         Srinagar

                                                                          validation of each field
2.   Createa form in HTML containing the following fields and perform the
                                                                                                   20
     using VBScriPt.

     .        Credit Card number      : Text

     .        Password                : Text

     .        Amount to be            : Text
              wiihdrawn

      Note ;

      (il      Credit Card number must be of 70 digits'

      (ii)     Possurord must be minimum of 4 digits'

      (iii)    Amount to be withdrawn should not exceed 75,000/- at o time.




                                                                                               2,000
 MCSL-o16P/S4
                                           MCA (Revised)
                            Term-End Practical Examination
                                         December, 2006


                        MCSL.O17: C AND ASSEMBLYLANGUAGE
                                  PROGRAMMING

                                                                                     Maximum Marks : 50
    Timeallowed:2hours

                                                                                               in this
.   Note :        There are two parts (C Progromming and Assembly Language Programming)
                                                                                        which you are
                  paper. Eoch part is for 7 hour duration. Attempt only thqt part(s) in
                  not successfulas Yet.


                                                     PART I
                                                C Programming


                                                                                    is    5 marks'
     Note :       Answer the following question.It carries20 marks snd the viua-uoce t'or

                                                                                and print them in sorted
    1.     write an interactivec program which will read-in five studentrecords
                                                                              the members for the first
           order. Each record should be representedby a c structure having
                                                                                   by their first name'
           name, last name and student roll-number (an integer).Sort the records
                                                                                                         20
           You can read-in the information from the consoleor from a file"




                                                     PART II
                                          emblY Language Programming


                                                                                    is    5 morks'
         Note :    Answer the following question.It corries20 marks and the uiuo-uoce for

                                                                              inputs and print out their
     2.    Write a program in assemblylanguagewhich will read-in four decimal
                                                                                                           20
           sum and the averagein decimal numbers'




                                                                                                      5,000
     M C S L - o 1 P l S1
                 7
                                      MCA (Revised)
                       Term-End Practical Examination
                                    Decembet, 2006


                   MCSL-O : C AND ASSEMBLYLANGUAGE
                        17
                            PROGRAMMING

Timeallowed:2hours                                                             Maximum Marks: 50

Note:        There are two parts (C Programming and AssemblyLanguageProgramming) in this
             pqper. Eachpart is for L hour duration. Attempt onlg that part(s) in which you are
             not successfulos yet.


                                               PART I
                                          C Programming



 Note : Answer the following question, It carries20 marks and the uiua-uoceis t'or 5 morks.

1.     Write an interactiveC program that reads characterstrings from the standardinput (keyboard)
       and prints them in the reverse.Use pointers.                                                20



                                            PART II
                                 Assembly Language Programming



     Note:   Answer the following question.It carries20 marks and the uius-uoce Jor 5 marks'
                                                                              is


2.     Write an assembly language program that will take three decimal inputs and display the
       minimum of them.                                                                       20




MCSL-o 7PlS2
     1                                                                                         4,000
                                    MCA (Revised)
                    Term-End Practical Examination
                                  Decembet, 2006


                                       LANGUAGE
                 MCSL-O : C AND ASSEMBLY
                      17
                          PROGRAMMING

Timeallowed,2hours                                                           Maximum Marks : 50

Nofe :    There are two parts (C Programming and Assembly Languqge Programming) in this
          paper. Each part is fo, t hour duration. Attempt only that part(s) in which you are
          not succes ul os yet.
                   tf


                         ,                   PART I
                                        C Programming



 Note : Answer the following question. It cqrries20 marks and the uiua-uoceis t'or 5 mqrks.

1.   A baby creche charges Rs. 4/- per hour until 9.00 PM, Rs. 3/- per hour between 9.00 PM
     and midnight, and Rs. 3.50 per hour after midnight. Write a program that reads the creche
     startingtime in hours and minutes and the endipgtime in hours and minutesand then computes
     the baby-sitter'sfee.                                                                      20



                                         PART II
                              Assembly Language Programming



 Note : Answer the following question. lt carries 20 marks and the uiuq-uoce for 5 marks.
                                                                           is


2.   Write an assemblylanguageprogram which will read-in decimal numbers as input repeatedly
     until a zero value is entered and print the sum of all the digits entered.              20




MCSL-o7PlS3
      1                                                                                     2,000
                                        MCA (Revised)
                          Term-End Practical Examination
                                      Decembet, ?OOG


                         MCSL-017: C AND ASSEMBLYLANGUAGE
                                   PROGRAMMING

Time allowed: 2 hours                                                             Maximum Marks: 50

.Note:       There are two parts (C Programming and Assembly Lorguog. Programmingj in this
             paper. Each part is t'or 7 hour duration. Attempt only that part(s) in which you are
             not success/ul as yet.


                                                PART I
                                            C Programming


     Note : Answer the following question. It carries20 marks and the uiua-uoce for 5 morks.
                                                                              is


l.     (a)   Write an interactive C program to compute the product of two matrices of size n x m
             andmxk.                                                                                 10

       (b)   Write a program that reads a line (string of alphabets)from the keyboard, convertsthem
             to lower case, s€paratesthe line into different words which are to be printed on separate
             lines.                                                                                    10
             Example : THIS IS A MANGO.
             Output :
                   this

                   is
                   a
                   mango




M C S L - 01 7 P t S 4                               1                                           'P.T,O.
                                         PART II
                             Assembly Language Programming

  Ngte : Answer the following question. It carries20 marks and the uiua-uoceis for 5 marks.
                                                           ,        .
2. Write an assemblylanguageprogram to compute the product of two decimal inputs.           20




MCSL-017Pt54                                                                           2,000
                                           MCA (Revised)
                       Term-End Practical Examination
                                         Decembet, 2006

                 :         COURSE
         MCSL-025 LABORATORY      (FORDATA AND FILE
           STRUCTURES,          DBMS LAB & JAVA
                      NETWORKING.
                       PROGRAMMING}

Timeallowed:3 ours
             h                                                                      Mqximum Marks: 700


     Note:   There are lour sections(Data and File Structures, Networking, DBMS Lab and Joua
             Programming) in this paper. Eoch s;ectionis t'or 40 minutes duration. Attempt only
             that part(s) in which you are not successfulas yet.
             Answer all the questions in each section. Eoch section carries 20 marks and the
                     is
             uiua-uoce for 5 marks


                                  SECTION A : Data and File Structures


                            'C'
l.     Write a program in         languagethat accepts5 stringsas input and prints them in lexicographic
       order.                                                                                              10


                             'C'
Z.     Write a program in        languageto accept a paragraph of text as input. The program should
       print the list of words and the number of occurrences each word in the paragraphas output' 10
                                                           of




M C S L - 0 2 5 P /1
                   S                                                                                 P.T.O.
                                       SECTION B : Networking

      Perform practicals 7 to 4 on Linux/LJnix/IAlindows
                                                       2000. e. 5 is on Sheilprogramming.

 l.   Run the following commands and write the use of each command
                                                                   :                        2
      (a)   telnet

      (b)   tracert

      (c)   drivers

      (d)   fc

 2.   Make your own subdirectories
                                 cailed first and secondin your home directory.

 3'   Write a shell script which returns the PID of a process.Provide necessaryinput.

4-    connect and configure your computer with a Local Network printer.

5.    Monitor the IP routing status.




MCSL-025P/S1
                                                 SECTIONC:DBMSLab

l.      (a) ,Create database customersof a shop. The detailsof the table that is to be createdare
                            for
              given below :

              Table : Customer
                            -   CustomeLid
                            -   Name
                                                          :
                            -   Area         i
                            -   Phone

        (b)    Enter at least 5 setsof meaningfuldatain the table and answerthe following queriesusing
                                                                                                       15
               SQL
               (il    Print the entire customer table.
               (iil   Delete record where area is NULL.
                                                                 'A' as first letter in their names'
               (iii) Find the names of those customerswho have

               (iv) Update phone numbers of all customersto have a prefix as your city sTD code.
               (v)    Display area and number of recordswithin each area'




                                                                                                       P.T.O.
     M C S L - 0 2 5 P /1
                        S
                                SECTION D : Java Programming


 1 . write a program in Java that acceptstwo strings 51 and
                                                               52 as input. The program should
     checkif either of the input stringsis a substring the.other and give
                                                     of                   appropriatemessage
                                                                                           as
     output.
                                                                                                 10

 2 . write a program in Java to launch 5 threads.Eachthreadshould
                                                                 incrernenta countervariable.
     Run the program with synchronization.
                                                                                                 10




MCSL-O25P/S
          1
                                                                                         5,000
                                      MCA (Revised)
                       Term-End Practical Examination
                                     December, 2OOG

         MCSL-025 LABORATORY
                 :         COURSE (FORDATA AND FILE
           STRUCTURES.          DBMS LAB & JAVA
                      NETWORKING,
                       PROGRAMMING}

Timeallowed:3hours                                                             Maximum Marks : 100


     Note : There are four sections(Data and File Struch)res, Networking, DBMS Lab and Jova
            Programming)in this paper. Eqch sectionis for 40 minutes duration. Attempt only
            that port(s) in which you ore not successful yet.
                                                       as
            Answer all the questions in eqch section. Eoch section carries 20 mqrks and the
                    is
            uiua:uoce for 5 marks.


                             SECTION A : Data and File Structures


                          'C'
l.     Write a program in     languagethat acceptstwo singly linked lists A and B as input. Now,
       the program should print a singly linked list that consistsof only those elements which are
       common to both A and B.                                                                       70


                          'C'                                                                        10
2.     Write a program in     languageto implement a queueusing two stacks.




MCSL-O IS2
     25P                                                                                        P.T.O.
                                      SECTION B : Networking

      Perform practicals 7 to 4 on Linun/Unix/lhlindows 2000. e. 5 is on shell programming.


 l.   Run the following commandsand write the use of each command :

      (a)   pathping

      (b)   drivers

      (c)   chkdsk

      (d)   hostname



2-    Find your Ethernetphysicaladdress
                                      usingappropriatecommand.                                3


3.    Find the files in your home directory whose accesspermissionsare set to rwxrw<rw:<,     4


4.    Find the round-trip delay to any websiteusing appropriate command.


5.    Set the executiontime of a job so that it can run automatically after20 minutes.




MCSL-O25P/S2
                                      SECTIONC:DBMSLab

 1.   Create the following tables :

      Table : Order_Party
                                                                                            L0
                -   Order_number
                -   Order_date
                    Customer_code
      Table : Order
                -   Order_number
                -   Item_code
                -   Quantity
      Designateappropriate field(s)of both tables as keys.


2'    Create a form for data entry to both the tablesmentioned in the
                                                                      above question.       10




MCSL-025P/S2
                                                                                        P.T.O.
                                SECTION D : Java Programming


l.   Write a program in Java for the addition of two complex numbers.                             10


2.   Write a program in Java that acceptsa file as input and counts the number of words in it'    10




 MCSL-025Pt52                                                                                    4,000
                                        MCA (Revised)
                    Term-End Practical Examination
                                      Decembet, ?OOG

      MCSL-025 LABORATORV
              :         COURSE (FORDATA AND FILE
        STRUCTURES.          DBMS LAB & JAVA
                   NETWORKING.
                    PROGRAMMING)

Timeallowed:3hours                                                           Maximlrm Marks: 100


 Note : There are four secfions (Dat:a and File Structures, Networking, DBMS Lab and Jaua
        Programming)in this paper. Each sectionis for 40 minutes duration. Attempt only
        that part(s) in which you are nof success/u as yet.
                                                    I
        Ansi;werall the questions in each section. Each section carries 20 marks and the
                  is
          uivq-uoce for 5 marks.


                                SECTION A : Data and File Structures


                        'C'
1.   Write a program in     language to implement a Dequeue using pointers. All operations
              with a Dequeueare to be implemented.
     associated                                                                            10


                          'C'                                                                10
2.   Write a program in         language to implement Kruskal's algorithm.




MCSL-025 /S3
       P                                                                                  "P.T.O.
                                                                                                            SECTION B : Networking

                                                           practicals 7 to 4 on Linux/Unix/11/indows
                                                                                                   2009. e. 5 is on shell programming.
                                                                                                               { itrl-s;,:.;l'.r,iut:l ;li$
                                                                                                                                l!' *,
                                                                                                                                                                             2
                 (a)             nslookup

                 (b)             route

             (c)                 lpq,                               .i
                           '
                       ' ..1                                   it    1
                                     -r. ::' . , .:.
                           1     .          .




             (d)                 netdius
                                                   .r.i.'T




2.          Displaythe namesof all files in the                                                                                               are larger than 600 KB.        3
 . 1 . . . r .     : , _ ; r .                         ,   i         : l ' . ' , :




3.          Send multiplefiles to a printer. Also, write the cornmand that is to be ex<ecuted remove any
                                                                                            to
            file from print queue.


4.          create a cnonjob that sendsyou a messageafter every10 minutes.

            ..4...,                  ::..,'                                          :t.r   ,-'.   :,. :... .._ :_,.   ..,,             ..:          :
                                                                                                                                               :..


5.         Customize configure
                   and       IP$gppoltcypnd                                                                                   rylesfol transport;r.ngde the'localcomputer.
                                                                                                                                                     o.n




MCSL-O25P/S3
1.   Createthel followingtable and perform the necessarytasks ,
              ' v'vwrll5 lqvreqrrut                  - r t . r - , , - i {efined be[ow i
                                                                         i,                                             .          r.
                                                                                                                                            ...:,i
                                                                                                                                            ,:..i'i'i
                                                                                                                                                        *
                                                                                                                                                        i
                                                      .   r;.: lir.';-.,                     1,1r,; 1l.-,:',:.      Il,i:,...-;"


     (a)   Create the following table named Train :                                                                                                     5

              ,.. --:,Namg                !'t ': :   ' ! ' : . '' '   :.':   "r':' ':: ;'':;':   "'r ''
                                                                                                                  '-'       :i                 :        l'
                                                                                                          ""':'
                                                                                                                                        '
                      Train number
                  -   Source station
                  -   Destination-station
                  -   Number-of-coaches
     (b)   Now, enter at least 5 sets of data in the above'table and answer the following queries
           usingSQL ,                                                                             75

           (i)    Find the number of the train whose name is "Circar express'!.
           (ii)   List the names of all trains whose source station is "New Delhi".
           (iii) Find the number of coachesof the train bearing number "262'1.".
           (iv) List the numbers of all trains which have more than 20 coaches.
           (v)    Find the numbers of all trains whose destinationstation is "New Delhi" and have
                  not more than 15 coaches.




MCSL-025P/S3
                                   SECTION D,: Java Prograrnrning


 l.   write a program in Java for addition of two matrices.                                      10

 2 . Write a program in Java that accepts two strings as input and concatenates them. Don't
      any library function for concatenation.                                                    10




MCSL-025P/S3                                     4                                            2,000'
                                     MCA (Revised)
                      Term-End Practical Examination
                                   f)ecembet, 2006

       McsL-025: LABoRAToRy
                          couRsE (FoR DATAAND F|LE
         STRUCTURES, NETWORKING.
                               DBMSLAB & JAVA
                                     PROGRAMMING}

Time allowea t S hours
                                                                            Maximum Mqrks ; 100

 Note:    There are four sections(Datq and File Structures, Networking, DBMS Lab and
                                                                                      Jaua
          Programming) in this papen Eqch section is for 40 minutes duration. Attempt only
          that part(s) in which you are not successful yet.
                                                     os
          Answer all the guestions in each section. Each section carries20 marks and
                                                                                       the
          viua-uoceis for 5 marks.


                           SECTION A : Data and File Structures


1.   Write a program in 'C' languageto implement Heap Sort.
                                                                                             10


2-   write a program in 'c' languageto implement Linear search using pointers.
                                                                                             10




MCSL-O25P/S4                                                                            P.T-.O.
           .                             SECTIONB:Networking

     Perform procticals 7 to 4 on LinuxlUnix/\\lindows 2000. Q. 5 is on shell programming.


1.   Run the following commandsand write the use o{ each command :

     (a)       ipconfig

     (b)       rsh

     (c)       ftp

     (d)       diskpart


2.   Find and list the devicesthat are availablein your system.


                                                                    't'.
3.   Use the ls command unj grnp to display all names starting with


4.   Use lingeror         who to get a list of userson the machine


5.   When you install a Modem, how do you enable/disablecall waiting on the computer ?       7




MCSL_O25P/S4
                                       SECTIONC:DBMSLab

1.                                                      tasksdefinedbelow.
     Create the following table a d perform the necessary

     (a)   Create the following ta e named Hospital     :

                    Hospital-nam
                    Hospital-addr
                    City
                    Department-1
                    Department-Z
                    Department-3
                     Number of P tients
                     Number-of-D tors
                     Number-of-A bulances
     (b)   Now, enter at least 5 sets of data in the above table and answer the following queries
           usingSQL :                                                                             15
           (i)    Find the names f hospitals where the number of patients are more than 1000.

           (ii)   Find the departm nts that are available in hospitals in New Delhi.

           (iii) List the names o hospitals which do not have ambulances.

           (iv) List the names      nd addresses of hospitals which do not have more than two
                  departments.

           (v)    Find the city wh re there are large number of hospitals.




 MCSL-025Pt54                                                                                   P.T.O.
                                 SECTION D : Java Programming


l.   Write a program in Java to copy a file to anotherfile.                10


2.   Write a program in Java to store information relatedto students.      10




MCSL-025P/S4                                                            2,000
                                     MCA (Revised)
                         Term-End Practical Examination
                                    December,        2006


              MCSL-036 LABORATORY
                      :          COURSE (FOROOAD'
            SOFTWARE ENGINEERINGAND ACCOUNTANCYAND
                              MANAGEMENT}
                      FINANGIAL

Timeallowed:Shours                                                        Maximum Msrks ; 100


 Note : There are three sections in this paper. Each section is for one hour, including the
        uivq-uoce.Attempt only that part(s) in which you are not successfulas yet. Answer
        all the questions in each section. Section A and Section B carry 25 morks for the
        problem, and viuo-uoceis for 5 marks, respectiuely. Section C carries 30 rnarks for
        the problem, and uiua-uoce   for 10 mqrks. Assumptions con be made whereuer
             necessary.


                         SECTION A : Obiect Oriented Ana$sis    and Design



1.   Draw the use cases and define all the classesfor a "student Admission System". Make
     necessary
             assumptions.                                                                75



2.    Draw the sequenceand collaborationdiagramsfor the systemgiven in Question L above'               10




                                                                                             ,   . '   i , ,   ,


                                                                                           D T N
M C S L - 0 3 6 P / S1                                                                     | . | .vr.
      ".,'                         SECTlONB:SoftwareEngineering
             ,,

 l.      Develop the SRS for the "student Admission System". Make necessaryassumptions.     7

 2-      Draw the following diagramsfor the problem given in Question 1 of this section :
                          ':.: : . . : ,     :                      I
         (a) DFDs upto appropriate llvels                                                   o
         (b)      ER diagrams




M C S L - 0 3 6 P / S1
                    SECTION C : Accountancy and Financial Management

l.   Post the following transactionsof ABC Services prepare the joumal, ledger and trialbalance,
                                                   to
     using Tally (or any other similar software).                                                30
          2006
          April                                                             Rs.

            1       Started business with cash                            10,000
           2        Deposited in the Bank                                  4,000
           3        Furniture purchased for cash                            1,500
           4        Purchased goods for cash                               3,000
           8        Old furniture sold for cash                            6,000
           15       Paid taxes in cash                                     3,000
           28       Received cash from Mr. Z                              30,000
           30       Bank interest credited                                 4,000
           30       Paid Rent                                              7,000
           30       Paid Salary                                            7,000




MCSL-036P/S
          1                                                                                 4,000
                                   MCA (Revised)
                    Term-End Practical Examination
                                 Decemb-et, 2006                             'l   j   :.'   :.',




           MCSL-036 LABORATORY
                   :           COURSE(FOROOAD,
         SOFTWARE ENGINEERINGAND ACCOUNTANCYAND
                   FINANCIALMANAGEMENT}

Timeallowed:Shours                                                        Maximum Marks: 700


 Note : There are three sections in this paper. Each section is for one hour, including the
        uiua-uoce.Attempt only that part(s) in which you are not successt'ul yet. Answer
                                                                            as
        all the guestions in each section. Setction and Section B carry 25 marks for the
                                                   A
        problem, qnd uiua-uoce for 5 marks, respectiuely. Section C carries 30 marks t'or
                               is
        the problem, and uiua-uoce   for 70 marks. Assumptions con be made whereuer
          necessary,


                   SECTION A : Object Oriented Analysis and Design



1.   Draw the use casesand define all the classesfor a "Hospital Management System". Make
     necessaryassumptions                                                                 1.5



2.   Also, draw the sequenceand collaborationdiagramsfor the systemgiven in Question 1 above. 10




MCSL-036P/S2
      :i                       SECTlONB:SoftwareEngineering

l.   Develop the SRS for a "Hospital ManagementSystem",,Make necessaryassumptions.        T

2-   Draw the following diagramsfor the problem given in
                                                           Queption 1 of this sgction :
     (a)   DFDs upto appropriate levels                                                   9
     (b)   ER diagrams                                                                    9




MCSL.O36P/S2
                      SECTION C : Accountancy and Financial lVlanagement

l.   Post the following transactionsof YYZ Co. to prepare the joumal, ledger and trial balance,
     using Tally (or any other similar software).                                               30


                2006
                                                                                Rs.
                June
                  1       Mr. A started business with cash                    5,000
                 2        Deposited in the bank                                 500
                 3        Furniture purchased for cash                          204
                 5        Purchased goods for cash                              400
                  9       Purchased goods from Mr. B on credit                1, 0 0 0
                 15       Goods sold to Mr. B for cash                          600
                 25       Goods sold on credit to Mr. C                         300
                 28       Received cash from Mr. C                              300
                 30       Paid Rent                                             100
                 30       Paid Salary                                           204




MCSL-036P/S2                                                                                4,O00
',
     ,,: ': .' :i"




                     ' ;
                           . , . . t   r   i : - 1
                                      MCA (Revised)
                       Term-End Practical Examination
                                    Decembet, 2006

                      :          COURSE
               MCSL=036 LABORATORY      (FOROOAD'
             SOFTWAREENGINEERINGAND ACCOUNTANCYAND
                              MANAGEMENT}
                      FINANCIAL

Timeallowed:3hours                                                           Maximum Mqrks: 700


     Note:   There are three sections in this paper. Eoch section is for one hour, including the
      '
             uiua-uoce.Attempt only that part(s) in which you are not successfulas yet. Answer
             all the guestions in each section. Section A and Section B carry 25 marks for the
             problem, and uiua-uoce for 5 marks, respectiuely. Section C corries 30 marks lor
                                    is
             the problem, and uiua-voce   Jor 70 morks. Assumptions con be made whereuer
             necessary.


                      SECTION A : Obiect Oriented Analysis and Design



l.     Draw the use cases and define all the classesfor a "Railway Reservation System". Make
       necessaryassumptions                                                                  75



2.      Also, draw the sequenceand collaborationdiagramsfor th'b systemgiven in Question 1 above' 10




MCSL-036P/S3                                                                                  P.T.O.
                                  SECTION B : Software Engineering

  1.   Develop sRS for the "Railway Resenration
                                               system,,. Make.necessary
                                                                      assumptions.

 2.    Draw the following diagramsfor the probrem given
                                                        in euestion 1 of this section :
       (a)   DFDs upto appr;priate t"u"t,
                                                                                          9
       (b)   ER diagrams
                                                                                          9




MCSL-036P/S3
                                                                    /
                     SECTION C : Accountancy and Financial Management

1.   Post the following transactionsof James to prepare the journal ledger and trial balanceusing
     Tally (or any other similar software).                                                       30


          2003
                                                                             Rs.
          April
            1        Started business with cash                             6,000
            2        Deposited in the bank                                  2,000
            3        Furniture purchased (cash)                             1,500
            5        Purchased goods for cash                               1,100
            6        Old furniture sold for cash                            3,000
            7        Purchased goods from ABC (on credit)                   2.000
           10        Received cheque of money due to ABC

           72        Deposited the cheque in Bank

           15        Paid taxes in cash                                     1,500
           T6        Goods sold to John for cash                            2,504
           18        Goods sold on credit to Staiin                         2,200
           30        Bank interest credited                                 1,700
           30        Paid Rent                                              2,300
           30        Paid Salary                                            2.500




MCSL-036P/S3                                                                                  2,000
                                       MCA (Revised)
                        Term-End Practical Examination
                              December, 2006

                MCSL-036 : LABORATORYCOURSE (FOR OOAD,
              SOFTWAREENGINEERING  AND ACCOUNTANCYAND
                        FINANCIALMANAGEMENT}

Timeqllowed:3hours                                                            Maximum Marks : 100

     Nofe :   There are three sectionsin this paper. Each section is for one hour, including the
              uiua'uoce.Attempt only that part(s) in which you are not successt'ul yet. Answer
                                                                                 as
              all the questions in each section. Section A and Section B carry 25 marks for the
              problem, and uiua-uoce for 5 marks, respectiuely.'sectionC carries30 marks for
                                      is
              the problem, and uiua-uocefor 70 marks. Assumptions con be made whereuer
              necessary,


                       SECTION A : Object Oriented Analysis and Design



l.     Draw the use cases and define all the classesfor a "Payroll Processing System". Make
       necessary
               assumptions                                                                  15


2.     Also, draw the sequenceand collaborationdiagramsfor the systemgiven in Question 1 above. L0




MCSL-036P/S4                                                                                      .
                                                                                             P . TO .
                               SECTION B : Software Engineering

1.   Develop SRS for the "Payroll Processingsystem". Make necessaryassumptions.

2.   Draw the following diagramsfor the problem given in euestion 1 of this seclion

     (a)   DFDs upto appropriate levels

     (b)   ER diagrams




MCSL-036P/S4
                     SECTION C : Accountancy and Financial Management

1 . . Post the following transactionsof Wilson & Co. to prepare the joumal, ledgerand trial balance,
      using Tally (or any other similar software):                                                   30

          2006
                                                                               Rs.
         August
            1        Started business with cash                                 800
           2         Deposited in the bank                                      800
           3         Furniture purchased for cash                               500
           5         Purchased goods for cash                                   700
           7         Old furniture sold for cash                              1 100
           8         Purchased goods from Mr. Y (on credit)                   1 300
           9         Received cheque due to Mr. Y

           T2        Deposited the cheque into Bank

           15        Paid taxes in cash                                         800
           T6        Goods sold to Z & Co. for cash                           5,300
           24        Goods sold on credit to Mr. A                            2,400
           28        Received cash from Mr.. A                                3,400
           30        Bank interest credited                                   1, 0 0 0
           30        Paid Rent                                                1,800
           30        Paid Salary                                              1.800




MCSL-036P/S4                                                                                    2,000
                                MCA (Revised)
                        Term-End practical Examination
                                      Decembet, 2006


                         MGSL-045: UNIX AND DBMS LAB

                                                                                  Msximum Marks ; 50
Timeallowed:2hours

                                                                   part is t'or t hour durqtion'
Note :      Theresre two parts(UNIX and DBMS) in this paper. Each
                                                                     as yet'
            Attempt only that part(s) in which you are not successlul


                                                   PART I
                                                    UNIX


                                                                 and the viua-uoce is t'or
Note :       Answer the fotlowing questions. They carry 20 marks
            5 marks.


1.    Write and executethe UNIX commandsfor the following :

      (a)   To split a file containing100 lines into 25 lines each'

      (b)   To print the information about the active processes'
                                                               password'
      (c)   To change the current passwordof the user to a new

      (d)   To print the last twenty lines of a text file'
                                                                          directory for a given pattem
      (e)   To searchall ihe files and the directorieswithin a particular
            of the string.

                                                                    letters and print the same in the
 2.   Write a shell script to take your name as input in upper case
      lower case.

                                                                  in a text file and displaysthe altered
 3.   Write a shell script which deletesall the odd numberedlines
                                                                                                         10
      output in a seParatetext file.




                                                                                                    P.T.O.
 M C S L - 0 4 5 P /1
                    S
                                                       PART II
                                                       DBMS

      Note :    Answer the following questions. They
                                                     carry 20 marks. and t.he uiua-uoce
                                                                                      is for
                5 marks.

  l'     create a relational databasewith the following
                                                        retationsand insert meaningfuldata in them.
                                                                                                       10
              ENROLL (S*, C#, Section)
                TEACH (prof, C*, Section)
                ADVISE (prof, S*)
                PRE_REQ(C#, pre_C#)

               GRADES (S#, C#, Grade, year)
               STUDENT (S*, Sname)

        where s# representsstudent number,
                                             c# representscourse number, prof is thesis
        of s*' Pre-c# is prerequisitecourse,                                            advisor
                                             sname is student name. perform Insertion,
        Updation and Drop operations on the                                            Deletion,
                                             created relations.

 2'     consider'the above relations and execute
                                                    the following queries ,                  ^"I -
                                                                                             2:x4=70
        (a)    List all studentstaking courseswith a particular
                                                                faculty.                         \
        (b)    List a[ studentstaking at least one course
                                                         that their advisor teaches.
        (c)ust those professorswho teach more
                                               than one section of the same course
       (d)Listthecoursesthataparticularstudentcanenrollini'e.haspassedthenecessary
                                                                      -'-v Fswvs urs
           prerequisitecoursesbut not the
                                          courseitself.




MCSL-045P/S
          1
                                                                                               4,000
                                         MCA (Revised)
                         Term-End Practical Examination
                                       Decembet, 2006


                           MCSL-045: UNIX AND DBMS LAB

Timeallowed:2hours                                                                Maximum Marks : 50

Note :       There are two parts (UNIX and DBMS) in this paper. Eachpart is lor 7 hour duration.
             Attempt only that part(s) in which you are not successfulas yet.


                                                   PART I
                                                    UNIX


Note :       Answer the foltowing questions. Theg carry 20 marks and the uiua-uoce for
                                                                                 is
             5 marks.


1.    Write and executethe UNIX commandsfor the following :

      (a)    To run a program at lower priority.

      (b)    To compare any two files and show the differences.

      (c)    To show the text file on display terminal with paging control.

      (d)    To display the date and time.

      (e)    To count the number of words in a text file.


2.    Write a shell script to accept a string as input and display the number of charactersincluding
      the specialsymbols.


3.    Write a shell program to sort a given file which consistsof a list of numbers, in descending
      order.                                                                                       10




M C S L - 0 4 5P I S 2                                                                           P.T.O.
                                               PART II
                                                DBMS

Note :     Answer the following questions. They carry 20 marks and the uiua-uoceis for
           5 marks.

l.   Create a relational databasewith the following relations and insert meaningful data in an
     Orcheshadatabase.                                                                  5+3+:2=70
           CONDUCTS (Conductor, Composition)
           REQUIRES(Composition,Instrument)
           PTAYS (Player,Instrument)
           UKES (Player,Composition)

     and perform Insert, Delete, Update operations on the created relations. Create a view to
     display the names of players who play guitar and flute.

2.   Considerthe above relations and executethe following queries r                        2lx4=10
                                                                                            2
     (a)   List all the players who play the instrument "GUITAR".

     (b)   List all the compositionswhich require the "CASIO" instrument.

     (c)   List all the players and their instrumentswho can be part of the Orchestrawith a given
           name as input.

     (d)   List all the playersw-hocan play 2 or more instruments.




MCSL-045P/S2                                                                                  4,000
                                         MCA (Revised)
                         Term-End Practical Examination
                                       Decembet, 2006
                                                                       \

                           MCSL-045: UNIX AND DBMS LAB

Timeallowed:2hours                                                                    Maximum Marks : 5A

 Note :      There sre two parts (UN/X and DBMS)in fhis paper. Eachpart is for t hour durqtion.
             Attempt only that part(s) in which you are not successful yet.
                                                                     as


                                                   PART I
                                                    UNIX


Note :                                                                            is
             Answer the t'ollowing questions. They carry 2A marks and the uiua-uoce for
             5 marks.


1.    Write and executethe UNIX commandsfor the following :

      (a)    To set read, write and executepermissionsfor user, group and other, for a specifiedfile.

      (b)    To change the ownership of a file.

      (c)    To list all the information about the files and the directoriesin the current directory.

      (d)    To find the files that match specifiedcriteria.

      (e)    To display who is logged on to this terminal.


2.    Write a shellscript to write the initialsof any name given as input.

      Example : VIJAY KUMAR

      Output : VK


3.    Write a shell program to create a directory "D" in the current directory, then transfer all the
      files having file name starting with "d" from the current directory to the directory "D".       10



M C S L - 0 4 5P / S 3                                                                                  P.T.O.
                                                  PART II
                                                  DBMS

Note :     Answer the following questions. They carry 20 marks and the uiua-uoceis t'or
           5 marks.

1.   Createa relational databasewith the following relationsand insert meaningfuldata in them.
                                                                                          5+3+2:70

           EMPLOYEE (Emp*, Emp-name, Profession)
           PRODUCT (Prod#, Frod-name, Prod-details)
           JOB-FUNCTION (Job*, Title)
           ASSIGNMENT (Emp#, Prod#, Job#)

     And perform Insert, Delete, Update, Drop operations on the created relations.

     Find the code of employeesand code of products involved in execution of Job#=123.

2.   Considerthe above relations and executethe following queries :                         2lx*-fi
                                                                                              2
     (a)   List all employeeswho are involved in producingsimilar products.

     (b)   List all the products and their details.

     (c)   List all the titles of the jobs for the employeeswho are producing the same product.

     (d)   List all the employee numbersand their names.




MCSL-045
       P/S3                                                                                       2,OOO
                                           MCA (Revised)
                         Term-End Practical Examination
                                         flecembet, 2006


                            MCSL-045: UNIX AND DBMS LAB

Timeqllowed:2hours                                                                  Maximum Marks: 50

Note :       There are two parts(UNIX and DBMS)in this paper. Eachpart is for t hour duration'
             Attempt only that part(s) in which you are not successfulas yet.


                                                     PART I
                                                      UNIX


Note :       Answer the following questions. They carry 20 mqrks qnd the uiua-uoceis for 5
             morks.


1.    Write and executethe UNIX commandsfor the following :

     . (a)   To displaythe online manualfor the command"su".

      (b)    To display the last five lines in a text file.

      (c)    Pipe the output of the "who" command to the sort command.

      (d)    Kill a processwith its PID.

      (e)    List the detailsof the largestfile in the current directory'


2.    Write a shell script to append the contents of any three text files into a new text file.      5


3.    Write a shell program to encrypt any text file with the logic of your own choice (example,you
                   'A'    'C'; 'B' by 'D' etc. or any other replacement your choice)to encryptthe
                                                                        of
      may replace by
      file data.                                                                                    10




MCSL-045 /S4
       P                                                                                          P.T.O.
                                                 PART II
                                                 DBMS

 Note :     Answer the following questions. They carry 2(i marks and the uiua-uoce
                                                                                 is for
            5 marks.

 l'   Createa relationaldatabasewith ihe following relationsand insert meaningfuldata in a Driving
      Schooldatabase.
                                                                                           S+S+2=j0
            STUDENT (St_Name,Class#, Th_Marks, Dr_marks)
            STUDENT_DR_TEACHER(St_Name,Dr_T_Name)
            TEACHER_TH_CLASS (Class*, Th_T_Name)

            TEACHER_VEHICLE (Dr_T_Name,License#)
            VEHICLE (Ucense#, Make, Modet, year)

      Perform Insertion, Deletion, Updation and Drop operations ori the above relations.
                                                                                         Find the
      details of the vehicles owned by Dr. Murthy.

2'    Perform followingqueriesusing the relationscreatedin
                                                               Q l through SeL statements. 2lx4=10
                                                                                             z
      (a)   List all the teacherswho teach theory as well as the driving lessonsto the students.

      (b)   List the teacherswho can drive all the vehicles.

      (c)   List all the studentswho are leaming the driving from "Raj".

      (d)   List all the "Ucense#" of the teachers.




MCSL-045P/S4
                                                                                                   2,OOO

								
To top