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 :
[Total Marks : 140
""'N Seat No.:
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. |
|
-Section No. (1,2,.....) |
Student's Signature
NIL
(2) Figure on the right indicate marks.
1 Write a program in C to Find the Factorial of a Given Number.
[25]
[25]
[40]
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 31st 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: |
Earning: Approval pending. |