DISTANCE EDUCATION
M.Sc. (Software Engineering) Years Integrated) DEGREE
EXAMINATION, MAY 2018.
RELATIONAL DATABASE MANAGEMENT SYSTEMS
LAB
Time Three hours Maximum 100 marks
Examiner should select and give ONE question to each
candidate by lot system.
1. A daily sales file contains records with the following
fields:
Dept no, data, item description, sales price for each
item, 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 total sales and profit.
Show the output report in a neat format.
Write a program to prepare a EB bill for a customer.
Assume your own database.
2. A newspaper vendor buys newspapers on wholesale
from a distributor for Rs. 4 and sale them in retail
for Rs. 4.50. At the end of the day the unsold papers
are retuned to distributor for Rs. 1 per paper. Write
a program to prepare a report for the newspaper
vendor in a neat format.
Sub. Code
27
DE-7060
2
Ws3
Write a program to process the Xth class results for
the following conditions:
Tamil, English, Maths, Science, Social 40; pass
otherwise fail
Assume your own database.
3. An examination has been conducted to a class of
10 students and the following are given as inputs.
Five test marks, reg no, name
Write a program to do the following:
Assign a letter grade to each student based on the
average score and list register number, average
score, grade. The minimum pass for each subject is
50. Assume your own grading system.
Write a program to evaluate the HRA, IT, GPAY
and NETPAY.
Base Table is PAY and the corresponding fields are:
empno, name, basic pay, DA, HRA, IT, GPAY and
NETPAY
Input from the table is empno, name, basic pay and
DA.
4. A company XYZ Ltd. states monthly salary to its
employee. It consists of Basic salary, allowance and
deduction.
DA 72% of Basic salary
HRA 10% of Basic salary
Deductions
PF 20% of basic DA
LIC payable by an employee
DE-7060
3
Ws3
Loan if any payable by an employee
Create a master table of 10 records with the
following fields:
Employee no., name, designation, basic salary,
HRA, DA, LIC premium number and Bank A/c no.
A transaction file contains:
Employee no., PF, LIC premium no., loan recovery.
Write a program to prepare a report in a neat
format.
The base table is having the column of Reg no.,
marks and rank. Enter Regno. And marks in the
base table upto 10 records. Write a program to
update the base table while allocating ramk.
5. Write a program to prepare a mark statement of a
student using student table and mark table.
Assume your own data.
Write a program to calculate the commission for the
given basic.
If basic 10,000 commission is 20%
If basic 5,000 and 10,000 commission is 10%
Otherwise commission is
Assume your own data.
————————