Veer Narmad South Gujarat University 2011-1st Year B.C.A Computer Application SD-1431 206 Practical ( Sem - 2 ) - Question Paper

SD-1431

Time : 5 Hours]

Instruction :

(1)

6silq<3i Puunkiufl SnwiA u* qsq d-onql. Fillup strictly the details of signs on your answer book.

Name of the Examination :

FIRST YEAR B. C. A. (SEM. 2)

Name of the Subject:

206 - PRACTICAL

-Subject Code No.

1 4 3 1

-Section No. (1,2,.....)

(2) Figure on the right indicate marks.

1    Write a C program to print a Fibonacci Series.    [25]

Hint: in which the next numbers is obtained by adding the previous 2 numbers. The few numbers are as follows.

1,1,2,3,5,8,13,21,.........

2    Write a program to do following on a given string.    [25]

Input: Patel Shiv Kumar Output: Patel Shiv Kumar

3    Create following tables with appropriate constraint    [40]

Studentmast( studno,studname,ccode, studcity, studage) Feemaster(studno, fee, amtpd)

Coursemst(ccode, cname)

(i)    Add at least 10 records

(ii)    Display all the student with same course code and course name

(iii)    Display the name of student living in Ahmedabad

(iv)    Count the number of student who have not paic the fees

(v)    Find out total amount of fees collected from the student whose course is BBA

(vi)    List the the name of student who are in same course and same city

(vii)    List the students name whose age is less than 19 List the detail of student whose course is BCA

4 From the following balances of accounts, prepare trial balance as on [30] 31-3-2010. Use suspense account if needed :

Name of Account Balance Name of Account Balance (Rs.) (Rs.) Building 25000 Purchases 90000 Creditors 65000 Cash and Bank 8990 Balance Opening Stock 40000 Machinery 25000 Furniture 8000 Purchase returns 8000 Depreciation on 400 Sales returns 10000 Furniture Debtors 75500 Wages 10000 Sales 156000 Outstanding wages 1000 Bad debts reserve 2000 Salary 10500 Discount received 1500 Office exp. 8000 12% taken on loan 5000 Discount allowed 3050 Bills receivable 20000 Bills payable 5000

5 Viva + Journal.    [20]

SD-1431]    2    [ 800 ]

Attachment: veer-narmad-south-gujarat-university-2011-b-c-a-computer-application-28209-1.pdf

Earning:   Approval pending.