DISTANCE EDUCATION
M.C.A./M.C.A. (Lateral) DEGREE EXAMINATION,
DECEMBER 2017.
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
100
1. Write a PLSQL program to prepare a mark statement of
a student using
STUDENT TABLE AND MARK TABLE Assume
your own data.
Write an SQL program to do the following
Assign a letter grade to each grade based on the
average score and list
Sub. Code
36
DE-9834
2
sp4
Register number, Average Score, Grade. The
minimum pass for each subject is 50.
The Grading System
Average Score Grade
90-100 A
75-89 B
60-74 C
50-59 D
0-49 F
2. A hospital maintains blood donors' record
information in a file. The file contains the following
fields: Donor number, Donor name, Donor age,
Donor address, Place of birth, Blood group.
Write a program using Oracle to print out the
number, name and address of the donors for the
following categories:
Blood donors having A blood group
Blood donors in the age group between 18 to
25
Male donors with Blood group in the age
between 18 to 25.
Cut here
DE-9834
3
sp4
An airline reservation database contains the
reservation table and personal table.
Reservation Table contains following fields:
Flight number, class, passenger name, seat
number
Personal table contains following fields:
Passenger name, sex. Age, Nationality
Write a program in ORACLE to prepare the
following reports:
List the passengers names with seat number
according to class and flight number.
Total number of married female passengers in
a particular flight.
List out the male passengers in the age
between 20 to 28 for all flights
3. A news paper vendor buys newspapers on wholesale
from a distributor for Rs. 4 and sell them in retail
for Rs. 4.50. At the end of the day the unsold papers
are returned to the distributor for Rs. 1 rebate per
paper. Write a program using Oracle to prepare a
report for the newspaper vendor in a neat format.
Write a program in SQL to prepare salary report for
5 employees. Assume your own database.
Cut here
DE-9834
4
sp4
4. Write a program in SQL for hospital billing system
with the following fields.
Patient number, name, age, date of birth, attending
doctor, patient type, consulting charge, blood test
charge, x-ray charge and total fee.
Prepare reports with the following conditions
The patients undergone blood test.
The patients who belong to in-patient
category.
Write a SQL program to prepare a bill for canteen
with two tables namely MENU and BILL. Assume
your own database.