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

SD-1474

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

April / May - 2011 Practical - 406

(New & Old Course)

Time : Hours]    [Total Marks : 140

Instruction

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 4

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

1 Create web-design for a hospital which provide    40

information about, facility, doctors and various instruments. Also provide facility to register apointment with doctor online.

2 Only for new students.

(a)    Create java application which display clock.    25 Display time using thread concept.

(b)    Create an applet which display a square within    15 a circle. Provide apropriate colors to both objects.

2 Only for old course students    40

Create following tables :

Doctor-master (Doc-no, Doc-name, Speciality)

Doctor-master (Pat-code, Pat-name, date-of-registration, next-apointment-date, Doc-no).

(a)    Create above tables and provide appropriate constraints.

(b)    Name doctors and total-patients they are having.

(c)    Which doctor have highest number of patients ?

(d)    Which doctor does not have given any apointment on tomorrow ?

Create GUI application which provide navigation, delete, 40 update, insert and search facility for Airline ticket Booking. Maintain booking information for various destinations from Bombay. The prize is fix for adult and child. Create appropriate database. Display destination-wise ticket booking details. Also provide date-wise ticket-booking and collection detail.

Viva.    10

Practical journal.    10

SD-1474]    2    [ 800 ]

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

Earning:   Approval pending.