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

SD-1435

First Year B. C. A. (Sem. II) Examination

April/May - 2011

206 - Practical

Time : 5 Hours]

Instructions :

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

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

(2) Figure on the right indicate marks.

1    Write a program in C to Find the Factorial of a Given Number.

2    Write a C program to find the sum of diagonal elements of a matrix.

3    Consider following relations in database and solve th|e queries

Book_mast(bookno,bookname,author,publisher, noofcopy) Studentmaster( libno, studentname, bookno, noofcopy) Transcation(tranno, trantype, libno, booknoi, nofocopy, trandate)

Give transction type = I for Issue and R for return

(1)    Give primary key and other constraints to each table

(2)    Display all books whose publisher is BPB

(3)    Display all student name who have more than two books

(4)    Display students who have books of Operating System

(5)    Delete records from studentmaster of all students who have VB.NET book

(6)    Change transaction type to R for all truncation whose transaction type is I and bookname is Let us C

(7)    Display all student name who have got book and whose publisher is TATA MACGRAW HILL

(8)    Count the no books which have been given to student whose name is DBMS

(9)    List the no of authors whose publisher is Bension Education

(10)    list no publisher whose books are in libarary

4 Create company of Jenis jariwala for the year 31^st March, 2008 and enter [30] the following balances under proper ledger in tally :

Jeniss capital A/C.	65,000
State Bank of India A/C.	42,000
Cash A/C.	3,200
Salaries A/C.	5,600
Purchases A/C.	4,560
Brokerage A/C.	650
Sales Tax A/C.	5,460
Sales A/C.	8,620
Purchase return A/C.	6,000
Wages A/C.	4,690
Snehal Vermas A/C.	3,588
SBI Loan A/C.	5,000
Computer A/C.	6,500
General Expenses	2,100
Rent received A/C.	360
Creditors A/C.	8,900
Viva + Journal.

SD-1435]    2    [ 800 ]

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

Earning:   Approval pending.