No. of Printed Pages: 1
IBCSL-034 -Set -41
BACHELOR OF COMPUTER APPLICATIONS
(Revised)

Term-End Examination

June, 2016

BCSL-034 -Set DATABASE MANAGEMENT SYSTEMS
LAB

Time: 1 hour Maximum Marks: 50
Note: There are 2 questions in this paper carrying 20 marks each.
Answer them both.
10 marks are for viva-voce.

1. Create the database with the schema given below:

EMPLOYEE EName, Skill, Pay)

POSITION (Posting_No, Skill)

DUTY_ALLOCATION (Posting_No, ENo, Day, Shift)

Note: (Shift has 3 shifts 8 hours each).

Select appropriate datatype for each of the fields. Input 10 meaningful records.

2. For the above database created in Q1, answer the following queries using SQL

List all the ENo, ENames whose Pay is more than Rs. 10,000/-.

List the ENos of all the employees who are in 3rd shift on 24th Apr, 2016.

List the Posting_Nos of all the skills.

List the ENo of "John".

List the EName of ENo "111".