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

SD-1470

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 0

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

Create an application which maintain information about 40 the score of students of BCA studying in 1^st to 6^th sem. Design appropriate database and store information using GUI forms. List out name of topper from each semester and search top three students based on selected semester. Also display names of failures. Provide insert, update, delete and search facility.

2 Create webpage for ice-creame parlour and various    40

products provided by the parlour. The website provide facility to accept orders online. It check validity of product (must be available in list). Total order quantity must be greater than zero. Calculate total bill rate and tax (10% of total amount). Calculate bill amount.

3 Only for new course

(a)    Write a java code (application or applet) which    25 display current time and date. Use thread class to execute the code.

(b)    Write java application which accept a string and    15 display the string in reverse order by interchanging its odd positioned characters with even positioned characters.

Create a database by designing appropriate tables and normalizing it. Create tables which store information regarding various ice-creams products and sales informations. Solve following queries :

(a)    Display flavor of ice-creame which is sold maximum times.

(b)    Calculate total sales of ice-cream on current date.

(c)    Display bottom three ice-creams which are sold least.

(d)    Display total collection of sales for last month.

4 Viva.

5 File.

SD-1470]    2    [ 500 ]

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

Earning:   Approval pending.