Reg No.: TWEROMEA ~ LOS ame Debi

APJ ABDUL 10521010018, UNIVERSITY

Second Semester MCA (2 Years) Degree Examination July 2021

Course Code: 20MCA102

Course Name: ADVANCED DATABASE MANAGEMENT SYSTEMS

Max. Marks: 60

५९९ eX 55

PART A
Answer all questions, each carries 3 marks.

Differentiate logical data independence and physical data independenc:
With the help of an example, explain generalization and ലിഖ in
extended ER features.
Define multivalued dependency and the related normal form with an example.
Write down the inference rules for functional dependencies used in database
normalisation.
Discuss the ACID properties of a transaction.
How does it implement concurrency control using timestamp method?
Discuss any two RAID levels with diagram.
Prepare a note on dense index and sparse index with example.
Compare homogenous and heterogenous distributed databases.
Explain array and multiset types in in SQL.
PART B

Answer any one question from each module. Each question carries 6 marks.

Module I
Construct an Entity-Relationship Diagram for a database of research projects.

The database should contain the information about the following

Projects : name, manager, budget, duration (in years), funding agency
Employees : SSN, name, projects, salary;

Each project is funded by a single agency. Project names are unique within an

agency. An employee can be associated with several projects. Managers are

Page 1 of 2

Duration: 3 Hours

Marks
(3)
(3)

(3)

(6)