Veer Narmad South Gujarat University 2011-1st Year B.C.A Computer Application SD-1436 206 Practical ( Sem - 2 ) - Question Paper
SD-1436
First Year B. C. A. (Sem. II) Examination
April/May - 2011
206 - Practical
[Total Marks : 140
Time : 5 Hours]
Instructions :
(1)
6silq<3i Puunkiufl SnwiA u1 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,.....) |
""'N Seat No.:
Student's Signature
NIL
4 From the Following balances taken from the books of Prema Industries [30] as on 31-7-2010. Prepare a trial balance in the form of a statement:
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5 Viva + Journal. [20] |
SD-1436] 2 [ 800 ]
2 Create a structure Item with fields itemcode, price, qty. Take array of [25] structures and input the value of member variables and display output in proper format.
3 Create following tables with appropriate constraint [40]
Itemmst( item no, item_name, quantity, purchaserate)
Billmst(billno, itemno,quantitysold, sellprice, selldate)
(i) insert atleast 10 records
(ii) display all itemno, item name, quantity, selling price and selling date
(iv) change the purchase rate of items whose name start with B and quantity is
greater than 15
(v) display the name of item which was sold in current month
(vi) count no of item starts whose name start with A
(vii) count no of bill generated in current months
(viii) display the item who have highest price.
Attachment: |
Earning: Approval pending. |