C C7415
Page 1 of 2
Total Pages: 2
Reg
APJ ABDUL KALAM TECHNOLOGICAL UNIVERSITY
THIRD SEMESTER MCA DEGREE EXAMINATION, DECEMBER 2017
Course Code: RLMCA205
Course Name: DATABASE MANAGEMENT SYSTEMS
Max. Marks: 60 Duration: 3 Hours
PART A
Answer all questions, each carries3 marks. Marks
1 How is data abstraction possible in a data base system?
2 What is the relationship between super key, candidate key and primary key
3 How can we test for empty relations using SQL?
4 Explain the issues associated with using an insert statement with view
5 Discuss insertion, deletion, and modification anomalies with examples
6 What is multivalued dependency? When does it arise?
7 Discuss the ACID properties of a Transaction
8 What is a timestamp? How does system generate timestamp?
PART B
Answer six questions,one full question from each module and carries6 marks.
Module I
9 Explain in detail the role of E-R diagram in expressing the overall logical
structure of a data base graphically.

OR
10 Describe the role played by Data Base Administrator.
What do you mean by Specialization? How is it classified?
Module II
11 Discuss entity integrity and referential integrity constraints? Why each is
considered important?

Define the terms Domain, Tuple, Relation schema, Relation Data Base Schema.
OR
12 Explain in detail about various set operations in Relational Algebra. Also
explain the pre-requisite conditions for performing some of these operations.

Module III
13 Explain in detail about various constructs used in association with clause
in nested sub queries.

OR
14 Differentiate between Left Outer Join, Right Outer Join and Full Outer Join with
suitable examples.

Discuss the various constructs used for Procedures or Functions in SQL.


Module 1V
15 What is a functional dependency? What are the possible sources of the
information that defines the functional dependencies that hold among the
attributes of a relation schema?

Differentiate between Boyce- Codd Normal Form and 3NF.
OR
16 Define first, second, and third normal forms when only primary keys
areconsidered. How do the general definitions of 2NF and 3NF, which
considerall keys of a relation, differ from those that consider only primary keys?

Module V
17 Discuss the need of concurrency control with informal examples.
Compare between Binary locks and Read/Write locks.
OR
18 Discuss the Problems of dead lock and starvation and the different approaches to
deal with the problem.

Module VI
19 Explain in detail about frequent pattern tree algorithm.
OR
20 Discuss in detail the data modelling used for data ware house.