DISTANCE EDUCATION
M.Sc. Years Integrated) DEGREE EXAMINATION,
MAY 2016.
RELATIONAL DATABASE MANAGEMENT
SYSTEMS LAB
Time Three hours Maximum 100 marks
Examiner should select and give ONE question to each
candidate from lot system.
1. Create a table as 'host_blood_donors' with the
following details
(Donor number Number
Donor name Character
Donor age Number
Sex Character(5),
Donor address Character(15)
Blood group Character(3))
Perform the following
Enter at least five records
List the Donor number in Ascending Order
List the Blood groups — and using
comparison operator IN(
List the donors having as the second letter.
Sub. Code
27
DE-9213
Ws 8
2
Create a table 'New_paper_vendor' with the
following data
(Week Number(3),
Bought Number(4),
Sold Number(4)
Return Number(4),
Profit Number(7,2),
Loss Number(7,2)
Perform the following
Enter at least nine records (Insert data only
Week, Bought, Sold and Return columns only)
Update the Field Profit and Loss.
List the week where the profit is high.
Find in which week the sale of newspaper is
high.
2. Create a table Employee with the fields like empno,
empname, job, sal, designation and dept.
List the details of the employees whose name
starts with
List the employees who are getting salary
more than 2500 7500 (Using comparison
operator ANY)
List the details of the employees who are
earning more than 3000 and less than 8000.
Cut here
DE-9213
Ws 8
3
Create a table as student with the following details
(studno, sname, mark1, mark2, mark3, tot, avg,
grade)
INSERT only the necessary columns.
UPDATE the total, average and grade
columns.
Display the student details whose grade is
List the name of the student whose names
begin with
3. Write a PL/SQL program to add 10 booster marks
for all mark Student (studno, sname, mark1,
mark2, total, avg, result)
Write a PL/SQL to give grade for all students
Student(studno, sname, mark1, mark2, total, avg,
result, grade)
Condition: If avg less than 50 Grade
If avg 50 and <60 Grade
If avg 75 Grade
4. Create a table Employee with the fields like empno,
empname, doj, job, sal, designation and dept.
List the details of the employees who are
working in 'MUMBAI'.
List the details of the employees who are
earning more than all the 'MARKETING
EXECUTIVES'
List the details of employees who are joined
before 'Anand'.
Cut here
Cut here
DE-9213
Ws 8
4
Create a table 'Employee' with the following data:
Empno, Ename, Job, Deptno, Deptname, Basicpay,
DA, HRA, PF
Grosspay, Netpay.
Perform the following
Insert only the necessary column.
Compute yearly salary of any one employee.
Calculate the Net salary of all employees.
List the employees having as the second
letter.
5. Create a table as 'Sales_order' with the following
details
(Deptno Number(4),
Item desc_Character(15),
Sales_price Number(7,2),
Qty Number(3),
Cost_price Number(7,2),
Profit Number(8,2))
Perform the following
Insert data except profit column
List the department number in Descending
order.
List the item where the profit is high.
List the item where the quantity on hand is
more than 10.
Create a table for Hospital Billing System with the
following fields
(Patient no, patient name, age, doctor name, patient
type
List the details of the IN type patients.
List the details of the patients whose age
between 40 and 60.
List the maximum age of the patients by each
type category.