Tuesday, February 7, 2023

Dr. A.P.J. Abdul Kalam University MCA II Sem (3 Year) Data Base Management System [MCA202] June 2021 Question Paper

Dr. A.P.J. Abdul Kalam University

Master of Computer Application

Second Semester Main Examination, June-2021

Data Base Management System [MCA202]

Time: 3:00 Hrs Max Marks 70

Note: (i) All questions carry equal marks

(ii) Answer should be precise and to the point only.

(iii) Assume suitable data if necessary and state them clearly

Q.1 (a) What is DBMS? Explain basic operation of DBMS? What are the

advantages of DBMS?

(b) DRAW E-R diagram for library management system and convert into set

of schema?

Q.2 (a) What is Normalization? Explain second normal form with the help of an

example.

(b) Draw an ER diagram for a small marketing company database. Assume

suitable data.

Q.3 (a) Define the concept of aggregation. Give several examples of where this

concept is useful.

(b) Explain deadlock prevention schemes?

Q.4 (a) What are the problems caused by data redundancies? Can data

redundancy be completely eliminated when a database approach is used?

(b) Explain the advantages and disadvantages of distributed database

Q.5 Define following: (i) Aggregation (ii)Check constraints (iii)dangling tuple

problem locks.

Scanned Copies:

Shiva

B.E Civil Engineer Graduated from Government College of Engineering Tirunelveli in the year 2016. She has developed this website for the welfare of students community not only for students under Anna University Chennai, but for all universities located in India. That's why her website is named as www.IndianUniversityQuestionPapers.com . If you don't find any study materials that you are looking for, you may intimate her through contact page of this website to know her so that it will be useful for providing them as early as possible. You can also share your own study materials and it can be published in this website after verification and reviewing. Thank you!