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

Report as inappropriate Your report has been received

Description

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

Shared by: ulu37646

Tags

base 2, base 16, reverse number, C Programming, Thread Tools, Chat Scripts, don't know, Cooling Down, Yahoo Booters, money value

Stats

views:: 21
posted:: 7/12/2011
language:: English
pages:: 56

Public Domain

Document Sample

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

(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

(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

(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

(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.

(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.

(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.

(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.

(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.

(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.

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

MCSL-045P/S4
2,OOO