Monday, January 17, 2022

Dr.A.P.J.Abdul Kalam University BE V SEM ALL BRANCH Data Base Management System [CS-503] Dec - 2020 Question Paper

Dr.A.P.J.Abdul Kalam University

Bachelor of Engineering

Fifth Semester Main Examination, Dec-2020

Data Base Management System [CS-503]

Branch-CS

Time: 3:00 Hrs Max Marks 70

Note : Attempt any five questions. All questions carry equal marks.

Q.1 (a) What is DBMS? Explain basic operation of DBMS? Explain levels of database with the help of

suitable example

(b) Briefly Explain the following:

(i) Functions of DBA (ii) Generalization, Aggregation and Specialization

Q.2 (a) Explain functional dependence with example. What is entity and attribute? Explain the entity

types.

(b) What are different types of relational query languages? Explain select, Project, Join, and division

operation with example

Q.3 (a) What is Key? What is the Primary key and super key, candidate key ?

(b) What are integrity constraints? Define the term primary key constraint and foreign key constraint.

How are these constraints expressed in SQL?

Q.4 (a) What is serializability? Explain its types? What are aggregate functions of SQL?

(b) What is Normalization? Explain second normal form with the help of an example.

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

Specify different entities, their attributes, cardinalities and degrees of the relationships in the E-R

model.

(b)What is serializability? Explain its types? What are aggregate functions of SQL?

Q.6 (a) Explain the advantages and disadvantages of distributed database?

(b) What do you mean by deadlock? How it can be removed?

Q.7 (a) What are the problems caused by data redundancies? Can data redundancy be completely

eliminated when a database approach is used.

(b) Explain the following feature of ORACLE:

(i) Sequence (ii) Triggers (iii) SQL loader

Q.8 (a) Discuss the various disadvantages in the file system and explain how it can be overcome by the

database system.

(b) Answer the following:

(i)What do you mean by check constraints

(ii)What is dangling tuple problem

Attachment & 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!