Veer Narmad South Gujarat University 2011-2nd Year B.C.A Computer Application SD-1471 406 Practical ( Old & New ) ( Sem - 4 ) - Question Paper
SD-1471
Second Year B.C.A. (Sem. IV) Examination
April / May - 2011 Practical - 406
(New & Old Course)
[Total Marks : 140
Time : Hours]
Instruction :
"x Seat No.:
6silq<3i Puunkiufl SnwiA u* qsq <KH=fl. Fillup strictly the details of signs on your answer book.
Name ofthe Examination :
S.Y. B.C.A. (Sem. 4)
Name ofthe Subject:
Practical - 406 (New & Old)
Student's Signature
|
-Subject Code No. |
|
-Section No. (1,2......): Nil |
Create GUI application which perform add, delete, insert, update, search and navigation operation for following database.
40
Create appropriate tables to maintain information about various items sold by the restaurant. Also maintain information about bills generated for customers.
Generate reports which display week-wise and day-wise bill-collection and item-wise bill collection.
2 Create and design website for a resaturant. 40
Display various special offers given by the owners. Also provide online order facility.
3 Only for new course 40
(a) Create an applet which display rectangle having a 15 circle inside the rectangle.
(b) Create an application which accept ten names. 25 Display the names using thread at an interval of 2 seconds.
Create following tables :
Item-master (Item-code, Item-name, cost)
Bill-master (Bill-code, Bill-date, Bill-amount)
Bill-detail (Bill-code, Sr.-no., Item-code, Qty)
Solve following queries :
(a) Create above tables and provide appropraite records.
(b) Name the item which is sold maximum.
(c) Display total bill-cost for current-date.
(d) Display bill-details having bill-amount greater than 500.
4 Viva.
10
10
5 Practical journal.
SD-1471] 2 [ 800 ]
|
Attachment: |
| Earning: Approval pending. |
