Veer Narmad South Gujarat University 2011-2nd Year B.C.A Computer Application SD-1476 406 Practical ( Old & New ) ( Sem - 4 ) - Question Paper

SD-1476

Second Year B.C.A. (Sem. IV) Examination

April / May - 2011 Practical - 406

(New & Old Course)

[Total Marks : 140

Instructions :

(1)

6silq<3i Puunkiufl SnwiA u* qsq <KH=fl. Fillup strictly the details of signs on your answer book.

Name of the Examination :

S.Y. B.C.A. (Sem. 4)

Name of the Subject:

Practical - 406 (New & Old)

-Subject Code No.

1 4 7 6

-Section No. (1,2......): Nil

(2) Question is separate for old and new course.

1 Develope a GUI application which accept details for an 40 employee of a company. Accept personal details, salary information using seperate interactive forms. Store the information in database. Provide save, view, navigation commands. Also provide search facility based on employee code. Also display salary information for all employees department wise.

2 Only for old course students.    40

Consider following database and create appropriate tables providing appropriate constraints :

Emp-master (Emp-code, Emp-name, data-of-joinint, department-name, designation)

Emp-salary (Emp-code, basic, HRA, DA, CCA, PF, PT, Gross, net)

(a)    Name the employees and their salaries whose designation is "G.M.".

(b)    Name the employees who are earning highest in each department.

(c)    Calculate HRA (15% of basic), DA (51% of basic), CCA (10% of basic), PF (8.33% of basic), PT (Rs. 250 fixed). Also calculate gross and net salary.

3 (a) Write a java application which accept two strings. 25 Merge both the strings using alternate characters of each strings.

e.g. "Hello" and "Good".

Result should be, "HGeololdo".

(b) Create an applet which display a circle within a    15

Triangle. Circumfarence of circle is touching the triangle edges. Provide different colors to both objects.

4 Create a portal to display facilities provided by your    40

college. Create appropriate pages (Minimum five) that provide information regarding college. Also provide online student registration form. Provide appropriate front-end level constraints.

File and Viva.

SD-1476]    2    [ 500 ]

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

Earning:   Approval pending.