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

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:

Name of the Balance Name of the Account Balance Account Rs. Rs. Capital 200000 Bad Debts 3000 Purchases 180000 Discount received 10000 Bills payable 10000 Creditors 130000 Goods Return (Cr) 16000 Opening Stock 92000 Goods Return (Dr) 20000 Salary 18000 Sales 330000 Outstanding wages 2000 Drawings 30000 Wages 20000 Bad debts reserve 4000 6% Loan 10000 Furniture 17000 Machinery 50000 Building 50000 Advertise expenditure 4000 Cash and bank 1980 Discount Allowed 6100 balances Bills receivable 40000 Freight and Octroi 8000 Investment 8000 Debtors 151000 Stationary-Printing 4000

5 Viva + Journal.    [20]

SD-1436]    2    [ 800 ]

1

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: veer-narmad-south-gujarat-university-2011-b-c-a-computer-application-28204-1.pdf

Earning:   Approval pending.