DISTANCE EDUCATION
P.G.D.C.A.(S) DEGREE EXAMINATION, MAY 2016.
First Semester
Lab II — RELATIONAL DATABASE MANAGEMENT
SYSTEMS
(2011 Calendar Year Onwards)
Time Three hours Maximum 100 marks
ONE question should be given to each candidate by lot system.
Break-up marks
Record Note Book 5
Algorithm/Flow chart 15
Program 35
Debugging and Execution 35
Result 10
Total 100
1. A salary pay-bill statement contains Name of the
employee, Basic pay, Allowances, Deductions, Gross pay,
Net pay.
Dearness Allowance 107% of Basic pay
Gross pay Basic pay DA
Deductions P.F Loan Amount LIC
Income tax is calculated on the basis of annual income
with the following conditions
Annual salary I.T
3 lakhs Nil
3 but 5 lakhs 10%
5 10 lakhs 20%
10 lakhs 30%
Total deduction Deduction I.T
Prepare salary report for 10 employees
List out employees' record whose I.T is between
8 and 10 lakhs.
Sub. Code
16
DE-9156
2
sp3
2. XYZ diagnostic centre maintains blood donors record
information in a file. The file contains the following
fields
Donor number, Donor name, Donor age, Address,
Pin code, Place of birth, Blood group.
Create a table of 'Blood-Donors' for the above particulars,
using SQL queries display the number, name and
address of the Donors for the following categories
Blood Donors having blood group
Blood Donors in the age group of 25-35
Female donors with blood group in the age
group 18-35.
3. A Railway reservation database contains the reservation
table and personal table. Reservation table contains the
following fields
Train number, Class, Passenger's name, Seat Berth
Number.
Personal table contains following fields
Passenger name, Sex, Age, Marital Status, Nationality
write PL/SQL statements to prepare the following
reports
List down the passengers' names with Berth Seat
number according to class and train number.
Display the male passengers in the age group of
25-35 for all trains.
List down the senior citizens with all fields.
Cut here
DE-9156
3
sp3
4. Create a table "Voters-EPIC" with the following fields for
"Srirangam" constituency.
Ward, Booth-id, Booth-name, Voter-id-no, Voter-name,
Voter-age, Sex and address.
Write PL/SQL statements for the following
Insert at least 10 records.
Count the number of senior citizens in each booth.
List down the total number of female voters in the
ward with all informations.
Count the number of male and female voters
between the age 35 and 50.
5. Create a student table, "Stud" with fields Register
Number, Name of the candidate Sex, Age, Marks for five
subjects, Total, Result and Grade.
Write PL/SQL queries for the following conditions
Display the students' record in "Register no" order.
Display the students' record who secured overall
percentage of 75 and above.
Remove the records who secured less than 50 marks
in any subject.
Write PL/SQL statements to list the students'
name, marks, result whose average is 80% and
above.