Question 1
(a)
Explain Logical & Physical data independence supported by DBMS
3 Marks
(b)
Explain different types of users of DBMS.
4 Marks
(c)
Compare database approach with traditional file systems to store application data.
7 Marks
Gujarat Technological UniversitySummer 2025 Examination
GTU 3130703 Database Management Systems (DBMS) Summer 2025 Paper Solution & PDF
B.E. · Computer Engineering · Semester 3 · Subject Code: 3130703
Total Marks70 MarksExternal theory exam
Passing Marks23 Marks33% minimum cutoff
Exam Duration2.5 Hours2:30 PM – 5:00 PM
Paper Structure5 QuestionsWith internal OR choices
Question 2
(a)
Explain Three Layer Schema Architecture of DBMS.
3 Marks
(b)
Explain Specialization, Generalization and Categorization in EER Modeling.
4 Marks
(c)
Explain Following Constraints supported by RDBMS:
1Primary Key
2Foreign Key / Referential Integrity Constraints
3Entity Integrity
4Domain Constraint
7 Marks
OR OPTION
(c)
Explain Relational Algebra Operations in detail.
7 Marks
Question 3
(a)
Explain Recursive Relationship in ER Modeling with example.
3 Marks
(b)
Explain Cardinality Ratio and Participation constraint of ER Model.
4 Marks
(c)
What is the need to normalize data? Explain 1NF, 2NF & 3NF in detail.
7 Marks
OR OPTION
(a)
Explain ACID Properties of transaction with appropriate example.
3 Marks
(b)
Consider a relation R(A,B,C,D,E) with following dependencies:
AB-→C, CD-→E, DE-→B .Is ABD a candidate key of this relation?4 Marks
(c)
Explain Inference Rules for Functional Dependency.
7 Marks
Question 4
(a)
What is the use of system log? What are the typical kinds of records in a system log? What are transaction commit points, and why are they important?
3 Marks
(b)
Explain SQL Injection in brief.
4 Marks
(c)
Explain Query Optimization with example.
7 Marks
OR OPTION
(a)
Explain the use of Btrees.
3 Marks
(b)
Explain Cursor in PL/SQL with example.
4 Marks
(c)
Explain Conflict Serializability with precedence graph in Transaction Processing.
7 Marks
Question 5
(a)
Draw a state diagram, and discuss the typical states that a transaction goes through during execution.
3 Marks
(b)
Explain Two phase locking protocol for guaranteeing Serializability.
4 Marks
(c)
Explain Deadlock handling in Transaction Processing.
7 Marks
OR OPTION
(a)
Explain the use of group by and having clause in SQL queries.
3 Marks
(b)
Explain Triggers in PL/SQL with example.
4 Marks
(c)
Consider Following 3 Tables and Write SQL Queries.
1Books ( BookID, BookTitle, Price, Author, Publisher )
2Students (StudID, StudName, DOB, Gender, Branch, Sem)
3Issue_Books ( StudID, BookID, Issue_Date) Query1: List all Books whose price in range of 300 to 500 Rs. Query2: Display all Publisher Name & Total count of Books of that publisher. Query3: Display list of all books which are not issued to any students. Query4. Display the name students who are issued books in current month. Query5: Display all Books assigned to student with name “mahesh”. Query6: Display total no of books in library Query7: Display the list of girl students who have taken book from library.
7 Marks
College Exam Groups
Studying for Database Management Systems?
Circulate this solved paper with KaTeX formulas and 1-click AI step solvers to your batchmates on WhatsApp or Telegram.
About this Examination Paper & Attribution
Official Gujarat Technological University (GTU) examination paper and step-by-step solutions for Database Management Systems (DBMS) (Summer 2025, B.E. · Computer Engineering, Sem 3). Features complete 70-mark regular & remedial examination pattern, official marking distribution across all 5 questions, and direct 1-click official PDF download.
Transcribed for student exam preparation from Gujarat Technological University official examination archives. Questions, syllabus guidelines, and curriculum marking schemes remain the intellectual property of Gujarat Technological University.