60 C7415

Total Pages: 2
Reg No.: Name:

APJ ABDUL KALAM TECHNOLOGICAL UNIVERSITY
THIRD SEMESTER MCA DEGREE EXAMINATION, DECEMBER 2017

Course Code: ۸۸۸05
Course Name: DATABASE MANAGEMENT SYSTEMS
Max. Marks: 60 Duration: 3 Hours
PART A
Answer all questions, each carries3 marks. Marks
How is data abstraction possible in a data base system? (3)
What is the relationship between super key, candidate key and primary key? (3)
How can we test for empty relations using SQL? (3)
Explain the issues associated with using an insert statement with view (3)
Discuss insertion, deletion, and modification anomalies with examples (3)
What is multivalued dependency? When does it arise? (3)
Discuss the ACID properties of a Transaction (3)
What is a timestamp? How does system generate timestamp? (3)

نم وم ~ مہ +~ ‎ॐ ~ ॐ‏

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 (6) structure of a
data base graphically.
OR
10 a) Describe the role played by Data Base Administrator. (3) b) What do you mean by
Specialization? How is it classified? (3)

Module 11
11 a) Discuss entity integrity and referential integrity constraints? Why each is (3) considered
important?
b) Define the terms Domain, Tuple, Relation schema, Relation Data Base Schema.
(3) OR
12 Explain in detail about various set operations in Relational Algebra. Also (6)
explain the pre-requisite conditions for performing some of these operations.
Module III
13 Explain in detail about various constructs used in association with ‘where’ clause (6) in
nested sub queries.
OR
14 a) Differentiate between Left Outer Join, Right Outer Join and Full Outer Join with (3)
suitable examples.
b) Discuss the various constructs used for Procedures or Functions in SQL. (3)

Page 1 of 2