Osmania University (OU) 2008 M.C.A Computer Aplications Programming Lab-V(D.B.M.SLab) - Question Paper

FACULTY OF INFORMATICS

M.C.A. II-Year I-Semester exam

ques. Bank for Practical ques. Paper

Subject : Programming Lab-V

(D.B.M.S. Lab)


1. Create a table to represent sb-account of a bank consisting of account-no,
customer-name, balance-amount.
Write a PL/SQL block to implement deposit and withdraw. Withdraws should not be allowed if the balance goes beneath Rs.1000.

2. Create The subsequent 2 tables :

College-info
Faculty-info
College-info consists of fields : college-code, college-name, address
Faculty-info consists of fields : college-code, faculty-code, faculty-name,
qualification, experience-in-no-of-years, address.
The field college-code is foreign key.

(a) Design a form to accept the data from the user.
(b) Generate queries to do the subsequent :
(i) List all those faculty members whose experience is greater than or equal to 10 years and have M. Tech degree.
(ii) List all those faculty members, who have at lowest 10 years of experience but do not have M. Tech degree.

3. Create the subsequent tables for Library info System :
Book : (accession-no, title, publisher, author, status)
Status could be issued, current in the library, sent for binding, and cannot be
issued.
Write a trigger which sets the status of a book to "cannot be issued", if it is
published 20 years back.

4. Create the subsequent tables for Library info System :
Book(accession-no, title, publisher, author, status, date-of-purchase)
Status could be issued, current in the library, sent for binding, and account be
issued.
(a) Create a form to accept the data from the user Create a form to accept the
data from the user with improper validation checks.
(b) Generate queries to do the subsequent :
(i) List all those books which are new arrivals. The books which are acquired during the last six months are categorized as new arrivals.
(ii) List all those books that cannot be issued and purchased 20 years ago.

5. Create the subsequent tables :
Student(roll-no, name, date-of-birth, course-id)
Course (Course-id, name, fee, duration)
(a) Create a form to accept the data from the user with improper validation
checks.
(b) Generate queries to do the subsequent :
(i) List all those students who are greater than 18 years of age and have chosen for
MCA course.
(ii) List all those courses whose fee is greater than that of MCA course.






..2

..2..

6. Create the subsequent table :
Student (roll-no, name, subject-name, subject-opted)
Subject(faculty-code, faculty-name, specialization)

(a) Create a form to accept the data from the user with improper validation
checks.
(b) Generate queries to do the subsequent :

Earning:   Approval pending.