Q.1
14 Marks(c)
Compare database approach with traditional file systems to store application data.
Also asked in Winter 2025 Q2c, Winter 2024 Q1c, Winter 2023 Q1b
Gujarat Technological UniversitySummer 2025 examination
GTU 3130703 Database Management Systems (DBMS) Summer 2025 Question Paper & PDF
B.E. · Computer Engineering · Semester 3 · Subject code 3130703
- Total
- 70 marks
- To pass
- 23 marks (33%)
- Duration
- 2.5 Hours 2:30 PM – 5:00 PM
- Questions
- 5 with internal choice
No solutions on this paper yetNeed them for your exam? Ask once. Papers that students ask for are solved first, and we aim to add them within 24 hours.
Noted. This paper is in our queue now. Check back tomorrow.
We could not record that here. Email the paper name to hirenjsca@gmail.com and we will add it.
14 of 25 questions on this paper were also asked in other years. 1 more is a type of question GTU sets again with new data. Each is marked below with the years it appeared.See all 41 repeated 3130703 questions, most asked first
Q.2
14 Marks(b)
Explain Specialization, Generalization and Categorization in EER Modeling.
(c)
Explain Following Constraints supported by RDBMS:
1Primary Key
2Foreign Key / Referential Integrity Constraints
3Entity Integrity
4Domain Constraint
OR
(c)
Explain Relational Algebra Operations in detail.
Q.3
14 Marks(a)
Explain Recursive Relationship in ER Modeling with example.
(b)
Explain Cardinality Ratio and Participation constraint of ER Model.
(c)
What is the need to normalize data? Explain 1NF, 2NF & 3NF in detail.
Also asked in Winter 2025 Q3c
OR
(a)
Explain ACID Properties of transaction with appropriate example.
Also asked in Summer 2026 Q3a, Winter 2025 Q4b OR, Winter 2024 Q4b OR, Summer 2024 Q4b, Winter 2023 Q4a, Summer 2023 Q4c
(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?(c)
Explain Inference Rules for Functional Dependency.
Also asked in Summer 2026 Q2b, Winter 2024 Q3b OR, Summer 2024 Q2c
Q.4
14 Marks(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?
OR
(a)
Explain the use of Btrees.
(b)
Explain Cursor in PL/SQL with example.
Also asked in Summer 2026 Q5a OR, Summer 2024 Q5b, Winter 2023 Q5a OR
(c)
Explain Conflict Serializability with precedence graph in Transaction Processing.
Also asked in Winter 2025 Q4a OR
Q.5
14 Marks(a)
Draw a state diagram, and discuss the typical states that a transaction goes through during execution.
Also asked in Winter 2025 Q4b
(b)
Explain Two phase locking protocol for guaranteeing Serializability.
Also asked in Winter 2025 Q4c OR, Winter 2024 Q5a
(c)
Explain Deadlock handling in Transaction Processing.
OR
(a)
Explain the use of group by and having clause in SQL queries.
(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.
Also asked in Summer 2026 Q5c, Summer 2026 Q5c OR, Winter 2025 Q5c OR, Summer 2024 Q5c, Winter 2023 Q5c, Winter 2023 Q5c OR, Summer 2023 Q5c
More Database Management Systems papers
Questions repeat across sessions. Working through two or three papers shows you which topics GTU asks most.
Other Semester 3 subjects
BE Computer
Preparing with friends?
Send this paper to your class group. Every question has its own link.
About this paper
Official Gujarat Technological University (GTU) examination paper 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.