Hall Ticket Number:
Subject Code: 20CS4PC10 R20
TEEGALA KRISHNA REDDY ENGINEERING COLLEGE
(UGC- AUTONOMOUS)
[Link] II Year II Semester Supplementary Examinations, April – 2025
DATABASE MANAGEMENT SYSTEMS
(Common to CSE, IT, AIML, CSG)
Date: 07.05.2025 SESSION: FN
Time: 03 Hours Max. Marks: 75
Note: i) Student should verify the subject name, subject code, regulation and semester on the question paper. Any discrepancy, inform to the Invigilator immediately.
ii) Enter your Hall Ticket Number on this question paper in the space provided immediately after receiving the question paper from the Invigilator.
iii) This question paper contains two parts A and B.
iv) Part A is compulsory which carries 25 marks. Answer all questions in Part A.
v) Part B consists of 5 Units. Answer any one full question from each unit. Each question carries 10 marks and may have a, b as sub questions.
BT
[Link] Questions Marks Unit CO
Level
s
PART- A
2.5 I 2 1
Q.1. (a) What is multi value attribute and explain with example.
2.5 I 1 1
(b) Define entity and entity set with an example.
2.5 II 2 2
(c) What are integrity constraints? Give two examples.
2.5 II 2 2
(d) Describe the purpose of views in a relational database.
2.5 III 2 3
(e) Write an SQL query to find employees with salary greater than 50,000.
2.5 III 2 3
(f) What is a trigger in SQL? Give a brief use case.
2.5 IV 2 4
(g) What are the ACID properties in transaction management?
2.5 IV 1 4
(h) Define serializability and its importance in DBMS.
2.5 V 2 5
(i) Differentiate between primary and secondary indexes.
2.5 V 2 5
(j) What is a B+ Tree and why is it used in databases?
PART- B
5 I 3 1
Q.2. (a) Explain the advantages of using a DBMS over traditional file systems with
suitable examples.
5 I 3 1
(b) Describe the structure of a DBMS and its main components.
OR
10 I 6 1
Q.3. Create an ER diagram for a university database that manages students,
courses, and enrollments. Include attributes and relationships.
5 II 3 2
Q.4. (a) Define the relational model. Explain the types of integrity constraints used in
relational databases.
5 II 3 2
(b) Discuss how relational algebra operations can be combined to perform
complex queries.
OR
5 II 3 2
Q.5. (a) Explain the concept of domain relational calculus with examples. How does
it differ from tuple relational calculus?
5 II 3 2
(b) Describe the process of logical database design and its significance.
5 III 5 3
Q.6. (a) Write SQL queries using UNION, INTERSECT, and EXCEPT to perform
operations on employee and department tables.
5 III 3 3
(b) Define complex integrity constraints in SQL and demonstrate how they are
enforced.
OR
Hall Ticket Number:
Subject Code: 20CS4PC10 R20
5 III 2 3
Q.7. (a) Differentiate between 3NF and BCNF. Illustrate with an example.
5 III 3 3
(b) Explain the fifth normal form with suitable examples.
5 IV 3 4
Q.8. (a) Describe the different states of a transaction with the help of a state diagram.
5 IV 3 4
(b) Explain the concept of serializability. How can conflict serializability be
tested?
OR
5 IV 2 4
Q.9. (a) Compare and contrast lock-based protocols and timestamp-based protocols.
5 IV 3 4
(b) Describe multiple granularity locking. How does it improve concurrency
control?
5 V 3 5
Q.10. (a) Explain the concept of primary and secondary indexes. When would you use
each?
5 V 5 5
(b) Discuss hash-based indexing. How does it handle collisions?
OR
5 V 3 5
Q.11. (a) Explain clustering indexes. How do they improve data retrieval?
5 V 6 5
(b) How does the structure of an index influence database performance? Discuss
tuning techniques.
*****