DISTANCE EDUCATION
M.C.A./M.C.A. (Lateral) DEGREE EXAMINATION,
MAY 2018.
Third Semester
LAB V — RDBMS
(2005 to 2010 Calendar Year)
Time Three hours Maximum 100 marks
ONE question is to be given by the Examiner to each
candidate by LOT system.
Break-up marks
Record 5
Algorithm 15
Program 35
Debugging and Execution 35
Result 10
Total 100
1. Write a program in ORACLE for hospital billing
system with the following fields:
Patient number, name, age, doctor name, patient
type, consulting charge, test charges and total fee.
Prepare reports for the following conditions
The patients who belong to In-patient
category.
The patients undergone for test.
List of patients is the age between 20 to 28.
Sub. Code
36
DE-7035
2
wk12
A daily sales file contains records with the following
fields
Department number, 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. Print total sales and profit. Show the
output report in the following format
Department number
Item description
Sales price
Cost
Profit
2. Write an SQL program for the Canteen
maintenance, with two tables namely MENU and
BILL.
The MENU table contains the following fields:
ITEM, UNIT-RATE.
The following items are available in the Canteen:
TEA, COFFEE AND COOL-DRINKS
The BILL table contains the following fields:
EMP NO, EMP NAME, DATE OF ISSUE, ITEM1,
NUMBER OF TOKENS ISSUED FOR ITEM1,
RATE1, ITEM2, NUMBER OF TOKENS ISSUED
FOR ITEM2, RATE2, ITEM3, NUMBER OF
TOKENS ISSUED FOR ITEM3, RATE3, TOTAL
AMOUNT.
Write a PLSQL program to prepare a mark
statement of a student using STUDENT Table and
MARK Table.
Cut here
DE-7035
3
wk12
3. An airline reservation database contains the
reservation table and personal table. Assume your
own database.
Write a program to prepare the following reports.
Total number of male passengers in a
particular flight.
List out the female passages in the age
between 18 to 25 for all flights.
A salary statement contains Name, basic pay,
allowances, deductions, Gross pay and Net pay.
Write a program in SQL to prepare salary report for
5 employees. Assume your own data base.
4. A hospital maintains blood doners information in a
file. Assume your own database. Write a program
using oracle to print out the number, name and
address of the doners having AB blood group and in
the age group of 16 to 25.
Write a SQL program to prepare a bill for hotel with
two tables namely MENU and BILL. Assume your
own database.