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

SD-1430

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

*

* * *

* * * * *

jjg

2 Define structure employee with empcode, name, dept, salary. Write a [25] program in C to read 10 records and print department wise employee information in proper format.

3 Create following tables with appropriate constraint    [40]

Employee( empid, empname, city, salary)

Dependent( empid, dependentname, relation)

Position(empid, designation,date)

(i)    insert atleast 10 records

(ii)    list the employees long with their dependent and relation

(iii)    list the employees who are from Baroda or Anand

(iv)    count no of dependent of Mr Dharmesh Desai

(v)    list various designation in the company

(vi)    list the employee who have joined in current month

(vii)    count the employee who have manager as designation and have joined in current month

SD-1430]    1    [Contd...

20000	Sales	100000
25000	Purchase return	2000
10000	Bad debt reserve	1000
5000	Commission (Cr)	6000
2000	6% Loan from Jagin	10000
3000	Capital	60000
2000	Creditors	30000
3000	Bank Interest	1000
10000	Machinery	15000
25000	Debtors	40000
10000	Traveling Expenses	5000
5000	Drawings	10000
3000	Insurance	3000
	Motor Car	4000

SD-1430]    2    [ 800 ]

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

Earning:   Approval pending.