Veer Narmad South Gujarat University 2011-1st Year B.C.A Computer Application SD-1433 206 Practical ( Sem - 2 ) - Question Paper
SD-1433
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 ofthe Examination :
FIRST YEAR B. C. A. (SEM. 2)
Name ofthe 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 to calculate Sum of digits of Integer Number, (ex : 123 = 1+2+3 - 6)
[25]
2 Write a C program to read a statement and count the number of lineis, [25] words and characters.
Create the following table with appropriate constraint
[40]
Employee(e_no, e_name, street, city)
Work (e_no, companyname, designation, salary)
Company (companyname, companycity)
(i) Insert the records
(ii) Display employee name, company name, designation and salary
(iii) Display all employee information whose designation is officer
(iv) Display all employees information whose salary is higher than manager salary and whose company name is ABC Bearing Ltd
(v) List all employees who are working in company at Mumbai
(vi) Give increment of Rs 500 to all employees whose designation is clerk
(vii) Count how many employees are working in company ABC Bearing Ltd and whose designation is Worker
4 Create company of M/S Akashlal & Co. and prepare final account for the [30] month of Feb., 2006 with the help of the following transactions entering them in Tally.
Feb. 2 Started business with cash Rs. 25,480, furniture Rs.
50.000 stock of goods Rs. 20,000 debtors Rs.
10.000 creditors Rs.15,000 and 16% Urvi Dhimars loan of Rs. 30,000.
Feb.5 Opened account with Bank of Baroda with Rs.5,000.
Feb.8 Bought goods @10% trade discount from Sunny Rs.3,000 and sold them to Sanjay @ a profit of 25%.
Feb. 15 Receiver an order for supplying goods from Mahesh Rs. 10,000.
Feb. 18 Sold goods of Rs. 15,000 to Nilesh @ 10% cash discount and 5% trade discount.
Feb.22 Sent goods to Mahesh as per his order.
Feb.25 Sold personal car for Rs. 50,000 and invested Rs. 30,000 out of it in business.
Feb.28 Paid salary Rs. 2,000 and rent Rs. 500.
5 Viva + Journal. [20]
SD-1433] 2 [ 500 ]
Attachment: |
Earning: Approval pending. |