Veer Narmad South Gujarat University 2011-3rd Sem B.C.A Computer Application SB-1450 Practicals -306 Second Year ( ) - Question Paper
SB-1450
Second Year B. C. A. (Sem. Ill) Examination
April/May - 2011 Practicals-306
Time : 5 Hours] [Total Marks : 140
Instruction :
N Seat No.:
6silq<3i Puunkiufl [qaim SuwiA u* qsq <KH=fl. Fillup strictly the details of signs on your answer book.
Name ofthe Examination :
S.Y. B.C.A. (Sem. 3)
Name ofthe Subject:
Practicals-306
|
-Subject Code No.: |
|
-Section No. (1,2......): Nil |
1 Write a program to create a single circular linked list do 40 the following.
(i) Insert (middle)
(ii) Delete
2 Write a program is C++ to display all the customers who 40 have deposited or withdrawn Rs. 25,000. The file has to store fields (No, Name) transaction (withdraw or deposit) amount.
3 Create the following tables with necessary constraints 40 publisher (Pub-id, name, addr, ph)
Book (B-id, name, pub-id, copies)
Member (m-id, name, m-dt)
Issue (Iss-id, m-id, b-id, iss-dt, ref-dt).
(1) Display all the books with copies more than 3.
(2) Display all the books published by "BPB".
(3) Display all the members who have borrowed books.
(4) Display the books which are issued today.
(5) Display details of publisher who had published book in "c".
(6) Add a collumn renalty to issue table with default value "o".
(7) Delete the member info whose membership "expired".
(8) Display the books which are never issued.
4 Viva & Journal. 20
SB-1450] [ 300 ]
|
Attachment: |
| Earning: Approval pending. |
