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

SD-1472

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

April / May - 2011 Practical - 406

(New & Old Course)

[Total Marks : 140

Instruction

6silq<3i Puunkiufl SnwiA u* qsq 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

-Subject Code No.

1 4 7 2

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

Create a database, which maintain student information.

The database must contain personal information regarding students and their academic information. Design GUI forms which provide facility of insert, update, delete, navigation of records and search specific records based on city and name.

2 Create webpages for placement agency. This website    40

accepts biodata of clients, including personal details and educational qualification. Also provide appropriate constraints to check that the email address and phone numbers are valid. Name, address and eductaional qualification fields are compulsary. Provide appropriate webpage design including required images.

3 Only for new course students    40

(a)    Write a javacode which accept start and end    25 alphabates in sequance from start position till end position providing one second intervals using thread.

(b)    Create on applet which display name of your city 15 within a triangle which is inside a circle and vertices of triangles are on the circumference of the circle. Provide separate colors to the triangle and circle.

Only for old course students.    40

Create appropriate tables and normalize them to solve given queries :

Store personal and marks related informations for students of BCA.

Solve following queries :

(a)    Name all students who born in the month of June and July.

(b)    Name the student who got highest in Paper-3.

(c)    Name the student who is eldest among all.

(d)    Name bottom five students who scored lowest.

Viva.    10

File.    10

SD-1472]    2    [ 800 ]

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

Earning:   Approval pending.