BCSL-034/S1
BACHELOR OF COMPUTER APPLICATIONS (Revised)
(BCA)
Term-End Practical Examination
December, 2018 SET - 1
DATABASE MANAGEMENT SYSTEMS LAB
Time : 1 Hour Maximum Marks : 50
Note :
(i) There are two compulsory questions in this paper.
(ii) Each question carries 20 marks.
(iii) Rest 10 marks are for viva-voce. 1. Create the following tables with the fields given below : 20
TEACHER (T_ID, Department, Year of Exp, Name)
SUBJECT PAPER (Sub_Paper_ID, T_ID, Title_of Paper, Programme,
Semester)
Select appropriate primary keys. Input at least 5 meaningful records in
the tables. Select appropriate data types for all the fields.2. For the tables designed in Question No. 1 above, answer the following queries using SQL : 4 each
(a) Display Name and Year-Of-Exp of all the teachers of "Computer
Science" department.
(b) Display name of teacher and department of all the teachers who have more than 5 years of experience.
(c) List the file of Subject Paper which are handled by T_ID = 1010.
(d) List the name of Programme and Semester of paper titled "C Programming".
(e) List name of all the teachers of "Physics" department. BCSL-034/S2
BACHELOR OF COMPUTER APPLICATIONS (Revised)
(BCA)
Term-End Practical Examination
December, 2018 SET - 2
DATABASE MANAGEMENT SYSTEMS LAB
Time : 1 Hour Maximum Marks : 50
Note :
(i) There are two compulsory questions in this paper.
(ii) Each question carries 20 marks.
(iii) Rest 10 marks are for viva-voce. 1. Create the following tables with the fields given below : 20
STUDENT (Student ID, Name, Programme, Teacher ID)
TEACHER (Teacher ID, Department, Name, City, Specialization)
Select appropriate primary keys. Input at least 5 meaningful records in
the tables. Select appropriate data types for all the fields.2. For the tables designed in Question No. 1 above, answer the following queries using SQL : 4 each
(a) Display name and specialization of all the teachers in city "Delhi".
(b) Display name, Student ID and Programme in which they are registered, of all the students.
(c) Display name of teacher of Teacher_ID = 123 and name of all the students who are associated with TeacherID = 123.
(d) Display name, specialization and city of all the teachers who are associated with "Physics" department.
(e) Display total number of students registered in "MCA" programme.BCSL-034/S3
BACHELOR OF COMPUTER APPLICATIONS (Revised)
(BCA)
Term-End Practical Examination
December, 2018 SET - 3
DATABASE MANAGEMENT SYSTEMS LAB
Time : 1 Hour Maximum Marks : 50
Note :
(i) There are two compulsory questions in this paper.
(ii) Each question carries 20 marks.
(iii) Rest 10 marks are for viva-voce. 1. Create the following tables with the fields given below : 20
PRODUCT (Product_ID, Supplier ID, Proudct_Nanie, Category, Price,
QuantityAvailable)
SUPPLIER (Supplier ID, Name, Area, City)
Select appropriate primary keys. Input at least 5 meaningful records in
the tables. Select appropriate data types for all the fields.2. For the tables designed in Question No. 1 above, answer the following queries using SQL : 4 each
(a) List price and product name of all the products whoseQuantity-
available is more than 100.
(b) Display product name and category of all the product whose price is more than Rs. 1,000
(c) Display product name and product ID of the products which are supplied by SupplieriD = 10111.
(d) Display name and area of all the suppliers of city "Mumbai".
(e) Display the number of products which are of price more than Rs. 1,500 and QuantityAvailable is more than 5.BCSL-034/S4
BACHELOR OF COMPUTER APPLICATIONS (Revised)
(BCA)
Term-End Practical Examination
December, 2018 SET - 4
DATABASE MANAGEMENT SYSTEMS LAB
Time : 1 Hour Maximum Marks : 50
Note :
(i) There are two compulsory questions in this paper.
(ii) Each question carries 20 marks.
(iii) Rest 10 marks are for viva-voce. 1. Create the following tables with the fields given below : 20
EMPLOYEE (LID, Name, Age, Address, Salary, Dep_ID)
DEPARTMENT (Dep_ID, Name, City)
Select appropriate primary keys. Input at least 5 meaningful records in the tables. Select appropriate data types for all the fields.2. For the tables designed in Question No. 1 above, answer the following queries using SQL : 4 each
(a) Display name and Dep_ID of all the departments in city "Delhi".
(b) Display name and age of the employees working in Dep_ID = 1001 and their salary is more than 10,000/- p.m.
(c) Find total number of employees whose salary is less than 7 50,000/- p.m.
(d) Display name and salary of all the employees whose age is more than 50 years.
(e) Display name and E_ID of all the employees who work in Dep_ID = 11011.