^ C1873 Pages: 2

Reg No.: Name:
APJ ABDUL KALAM TECHNOLOGICAL UNIVERSITY
FIRST/THIRD SEMESTER MCA DEGREE EXAMINATION, JULY 2018
Course Code:RLMCA205
Course Name: DATABASE MANAGEMENT SYSTEMS
Max. Marks: 60 Duration: 3 Hours

PART A

Answer all questions, each carries 3 marks Marks
State the levels of abstraction ina DBMS. (3)
What is DBA? List out the tasks of DBA? (3)
Explain selection and projection operations with examples. (3)
Define triggers. What are different types of triggers? (3)
Define functional dependency with anexample. (3)
Explain serializable schedule with anexample. (3)
Define data mining versus data warehousing. (3)
What are ACID properties of transactions? (3)

ॐ ~ ॐ ~ +> ~ ‏نم زم‎

PART 8
Answer six questions, one full question from each module and carries 6 marks
Module I
9 Define data models and explain different types of data models? (6) OR
10 Draw an ER diagram for an airport database. Specify the key and participation (6) constraints
for each entity and relationship set.
Module II
11 Explain fundamental relational algebra operations with Examples. (6) OR
12 Explain Natural join operations and outer join operations. (6)
Module III
13 Explain set operations and Aggregate functions in SQL. (6) OR
14 Consider the following Company Schema (6)
Employee (Eid,Ename,address,Deptno,Pno)
Department (Deptno, Dname,Mngrid)
Project (pno,pname,plocation)
Works-on (Eid,Pno,,Hours)
Dependent (Eid,Deptno,Dname,Relationship)
i) Retrieve the name and address of the employee who works for
the administrator department. ii) Retrieve the names of employees
who have no dependents.
iii) Find the name of employees who work on all the projects controlled by
department 4.

Page 1 of 2