DISTANCE EDUCATION
M.C.A./M.C.A. (Lateral) DEGREE EXAMINATION,
MAY 2017.
Third Semester
Lab V — RDBMS
(2005 to 2010 Calendar Year)
Time Three hours Maximum 100 marks
One Question Should be given to each student by LOT system.
1. An examination has been conducted to a class of 10
students and the following are given as inputs
Three test marks, regno, name.
Write a program to do the following
Assign a letter grade to each student based on the
average score and list the register number, average
score and grade. (Assume your own grade system)
Write a PL/SQL program to evaluate DA, HRA,
Income Tax, Grosspay and Netpay. Base Table PAY
contains Empno, name.
basic pay, DA, HRA, IT, GPAY, NPAY
Input from the base table is empho, name, basic
pay.
Sub. Code
36
DE-9536
Ws 20
2
2. Write a program for hospital billing system with the
following fields
Patient no., name, age, attending doctor, patient
type consulting charge, blood test charge
and total fee.
Prepare reports with the following conditions
The patients undergone blood test.
The patients who belongs to in patient
category.
Write a PL/SQL program to search the guide name
for the given student regno.
Student tables contains regno, title, name, guide
name.
3. A company XYZ Ltd., states monthly salary to its
employee. It consists of basic salary, allowance,
deduction.
DA 53% of basic salary
HRA 10% of basic salary
Deductions PF 10% of basic salary
LIC payable by an employee
Loan payable by an employee
Create a master table of 10 records with the fields
empno, name, designation, basic salary, HRA, DA,
bank a/c no, LIC premium no.
A transaction file contains
Empno, PF subscription, LIC, Loan write a program
to prepare a report in neat format.
Write a PL/SQL program to prepare a electricity
bill. (Assume your own data).
Cut here
DE-9536
Ws 20
3
4. A daily sales file contains records with the following
fields
Deptno, date, item description, sale price for each
item, quantity, cost of each item.
Write a program using oracle to list all the input
data and compute total amount of sales and profit
for each sale.
Write a PL/SQL program to prepare mark
statement of a student using student table and
mark table. Assume your own data.
5. A hospital maintains blood donors record
information in a file. The file contains
donor number, name, age, address, place of birth,
blood group AB,
Write a program to print out the number, name and
address of the donors for the following categories.
Blood donors having A blood group.
Female donors with AB group in the age
between 20 and 25.
Create a table containing phone number, name and
address. Write a PL/SQL program to search for
address using phone number.