Tuesday, January 31, 2023

Dr. A.P.J. Abdul Kalam University BE IV SEM (IT) Data Base Management System [IT-225] June 2021 Question Paper

Dr. A.P.J. Abdul Kalam University

Bachelor of Engineering

Fourth Semester Examination, June-2021

Data Base Management System [IT-225]

Branch: IT

Time: 3:00 Hrs Max Marks 70

Note : 1. Attempt any five questions out of Eight.

2. All question carry equal marks.

Q.1 (a) What do you mean by deadlock?

(b) What is serializability. Explain its types

Q.2 (a) What do you means by functions of DBA?

(b) Explain the aggregation.

Q.3 (a) What is DBMS? Explain basic operations of DBMS.

(b) Explain levels of Database with the help of suitable example.

Q.4 (a) Explain check constraints.

(b) Explain distributed database.

Q.5 (a) What is E-R model? Draw any E-R diagram of your choice.

(b) What is an Entity? Explain the different types of entities.

Q.6 (a) Explain the integrity constraints.

(b) What is a key? Explain primary key and candidate key.

Q.7 (a) Discuss the various disadvantages in the file system and explain how it

can be overcome by the database system.

(b) Explain the functional dependence with example.

Q.8 (a) Write a short note (Any two) -

i) Relational calculus

ii) Normalization

iii) SQL

Scanned Copies:

Share This
Previous Post
Next Post

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!


Pen down your valuable important comments below

Search Everything Here