Exam Details

Subject lab ii — relational database management systems
Paper
Exam / Course p.g.d.c.a.(s)
Department
Organization Alagappa University Distance Education
Position
Exam Date May, 2017
City, State tamil nadu, karaikudi


Question Paper

DISTANCE EDUCATION
P.G.D.C.A. EXAMINATION, MAY 2017.
First Semester
Lab II — RELATIONAL DATABASE MANAGEMENT
SYSTEMS
(2011 Calendar Year)
Time Three hours Maximum 100 marks
One question should be given to each candidate by
LOT system.
1. A hospital maintains blood donors record information in a
file. The file contains the following fields
Donor number, name, age, address, pincode, place of
birth, blood group.
Write a program to print out the number, name and
address of the donors for the following categories:
Blood donors having group
Blood donors in the age group between 20 and 25.
Female donors with A group in the age between
18 to 25.
Sub. Code
16
DE-9502
2
ws
2. A salary statement contains name, basic pay, allowances,
total deduction, gross pay, net pay.
DA 64% of basic pay; gross pay basic pay DA;
deduction PF Loan IT
Write a program in SQL to prepare salary report for
10 employees.
3. Write a program in SQL for hospital billing system with
the following fields patient number, name, age,
attending doctor, patient type (IN/OUT).
Consulting charges, blood test charge, X-ray charge and
total fee.
Prepare reports with the following conditions
The patients undergone for blood test
The patients who taken X-rays
The patients who belong to IN patient category.
4. An airline reservation database contains the reservation
table and personal table.
Reservation table contains following fields:
Flight number, class, name, seat number
Personal table contains following fields:
Passenger name, sex, age, marital status nationality.
Write a program to prepare the following reports:
List the passenger's name 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 25
and 30 for all flights.
Cut here
Cut here
DE-9502
3
ws
5. An examination has been conducted to a class of 30
students and the following are given as inputs
reg no, name, marks for three subjects. Write a program
to do the following
Find the average score for each student
Declare the result as pass if the marks for each
subject is more than 40 and the average score is
more than 50. Otherwise fail.
6. A daily sales file contains records with the following
fields:
department number, date, item, sale price, quantity, cost
of each item.
Write a program to list all the input data and compute
total amount of sales and profit for each sale. Accumulate
and print profit for each sale. Accumulate and print total
sales and profit in a neat format.


Other Question Papers

Subjects

  • computer lab iv (unix and shell programming)
  • lab i — data structures using c
  • lab ii — relational database management systems
  • lab iii — graphics using c++