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

SD-1473

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

-Subject Code No.

1 4 7 3

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

Create a database for vehicle service job contains job-master (job-no, vehicle-no, attend (y/n), type of job (accident, service, color), job-description, entrydate, delivery date). Write a vb.net code which provide facility of DML, navigation and search operation. Provide search facility on vehicle-no and jobtype jointly, display result in datagridview.

40

2 Create a webpage which display information about a    40

medical shop. The registered user can order medicines online. Provide appropriate constraints to accept user's personal information using form. Also provide facility to order for medicines which provide facility to order multiple medicines and calculate total Bill-amount.

3 For new course students    40

(a)    Write a java code which accept names and age of 25 10 students. Sort the names of students age wise in ascending order. Display the names of students using thread class at interval of one seconds.

(b)    Write a java application which display a pentagon containing a circle within the pentagon where the circumference of the circle touches to the dges of the pentagon. Provide separate colors to both the objects. Display your name in center position of the circle.

3    For old course students.    40

Use the tables from question one and provide appropriate

constraints. Solve following queries :

(a)    Name (number of) the vehicle_no where type of job is accident.

(b)    Display total numbers of vehicles delivered in last one week.

(c)    How many vehicles are delivered in less than 5 days during last month ?

(d)    Display total vehicles serviced for each types of job.

(e)    Count total number of vehicles not attended till now.

4    Viva.    10

5    Practical journal.    10

SD-1473]    2    [ 800 ]

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

Earning:   Approval pending.