Meerut Institute of Engineering and Technology, Meerut

Analysis of Topic-wise Questions appeared in AKTU End Sem Exams

Subject Code : KCS-501 Subject Name : DATABASE MANAGEMENT SYSTEM

1 Database system vs File System 1 What is the advantage of file processing system which were removed by the dbms?

View of Data /View Level (Data 2 What are the different types of data models and explain them.
2 Abstraction, Instance and schema, Data
Model) 3 What is Data Abstraction ? How the data abstraction is achieved in DBMS?

3 Overall Structure of DBMS 4 Draw overall structure of DBMS and explain its components in brief.

4 Extended ER model 5 Compare generalization, Specialization and aggregation with suitable examples.

UNIT - 2
Attempt any five.
1 Integrity Constraints 1 Define constraint and its types in DBMS.
2 Relational Algebra and Calculus 2 What is Relational Calculus and Domain Relational Calculus ?

"Consider the following schema for institute library:Student (RollNo, Name, Father_ Name, Branch)
Book (ISBN, Title, Author, Publisher)
Issue (RollNo, ISBN, Date-of-Issue)
Write the following queries in SQL and relational algebra:
I. List roll number and name of all students of the branch ‘CSE’.
3
3 SQL II. Find the name of student who has issued a book published by ‘ABC’
publisher.
III. List title of all books and their authors issued to a student ‘RAM’.
IV. List title of all books issued on or before December 1, 2020.
V. List all books published by publisher ‘ABC’."
4 What is Aggregate Function in SQL? Write SQL query for different Aggregate Function
4 Joins 5 Discuss Join and Types with suitable example.

5 PL/SQL 6 What is Trigger, Procedure and cursor? Explain in detail with example.

UNIT - 3
Short Notes of the Following-
1 Functional Dependency 1
i) MVD or JD ii) Normalization with advantages
2 Armstrong Axioms 2 What are the various anomalies associated with RDBMS.
Define functional dependency. What do you mean by loss-less decomposition? Explain with suitable
3 Lossless Join Decomposition 3
example how function dependencies can be used to show that decompositions are loss-less.
4 Explain INF, 2NF, 3NF and BCNF with suitable example.
4 Normalization Consider the universal relational schema R (A, B, C,D,E,F,GH.I,J) and a set of following functional
5 dependencies. F={F-AB->C, A->DE,B→F,F→GH,D→U}. Determine the keys for R? Decompose R into
2nd Normal Forms.
UNIT - 4 Attempt any five.
1 List ACID properties of transaction. Explain the usefulness of each. What is the importance of log?
1 Transaction system
2 What do you mean by serializability? Discuss the conflict and view serialzability with xample. Discuss the test
2 Deadlocks 3 Discuss the procedure of deadlock detection and recovery in transaction?
S: R1(X) R2(X) R2(Y) W2(Y) R1(Y) W1(X).Identify, whether given schedule is equivalent to serial
3 Schedules 4
schedule or not?
5 What are distributed Database? List advantage and Disadvantage of data replication and fragmentation
4 distributed Database
6 Explain Directory System in detail.
UNIT - 5
1 Concurrency Control 1 What is concurrency control? Why it is needed in database systems?
2 Explain the Phantom Phenomena. Discuss a time stamp Protocol that avoids the phantom phenomena.
2 Locking Technique 3 What is Two phase Locking (2PL)? Describe with the help of example
4 Discuss 2 phase commit (2PC) protocol and time stamp based protocol with uitable example. How the valida
What do you mean by time stamping protocol for concurrency controlling? Discuss multi version scheme of
3 Multiple Granuality 5
concurrency control.
Taught in :
Year and Sem
(Odd / Even)

2015-16(5th sem)

2021-22 (5th sem)

2020-21 (5th sem)

2018-19 (5th sem),2021-22

2018-19 (5th sem),2020-21

2018-19,2020-21 (5th sem)

2021-22 (5th sem)

2017-18(5th sem)
2016-17(5th sem)
2016-17(5th sem)
2017-18(5th sem)

2017-18(5th sem)

2021-22(5th sem)
2017-18(5th sem)
2021-22(5th sem)
2021-22(5th sem)
2019-20(5th sem)
2019-20(5th sem)

2019-20(5th sem)
2019-20(5th sem)
2017-18(5th sem)
2021-22(5th sem)
2021-22(5th sem)