Gujarat Technological UniversitySummer 2026 examination
GTU 3130703 DATABASE MANAGEMENT SYSTEM (DBMS) Summer 2026 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.
15 of 25 questions on this paper were also asked in other years. 6 more are types 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(a)
Consider following relations and write queries in the form of relational algebra. Student(std_id, std_name, semester, dept_id) Department(dept_id,dept_name,no_of_faculties)
1)Find the names of departments that have more than 12 faculties.
2)Find the names of students who are in the 3rd semester.
3)Select all students with std_id = 203.
Also asked in Summer 2024 Q1c, Winter 2023 Q3b, Winter 2023 Q3b OR
(c)
Draw E-R diagram for canteen management system showing at least four entity types and their relationships with necessary assumptions.
Also asked in Winter 2025 Q3c OR, Winter 2024 Q2c
OR
(c)
Draw E-R diagram for an online shopping system showing at least four entity types and their relationships with necessary assumptions.
Also asked in Winter 2025 Q3c OR, Winter 2024 Q2c
Q.3
14 Marks(a)
Explain ACID properties of transaction.
Also asked in Winter 2025 Q4b OR, Summer 2025 Q3a OR, Winter 2024 Q4b OR, Summer 2024 Q4b, Winter 2023 Q4a, Summer 2023 Q4c
(b)
Differentiate lossy decomposition and lossless decomposition.
(c)
Consider the relation R(ABCD) with dependencies F ={AB->C, BC-> D}. Does theabove relation appear in 3NF? If not, normalize it in 3NF.Also asked in Winter 2024 Q3c OR, Winter 2023 Q3c OR
OR
(b)
Let R = (A, B, C, D, E, F) be a relation schema with the following dependencies {C→ F, E → A, EC → D, A → B} What is the Candidate key of the relation R?Also asked in Winter 2023 Q3a OR
(c)
What is normalization? Explain 2NF, 3NF and BCNF with suitable examples.
Also asked in Winter 2023 Q3c
Q.4
14 Marks(a)
Differentiate Sparse and Dense dense index in DBMS.
Also asked in Winter 2025 Q3b OR, Winter 2023 Q5b
(b)
What is the limitation of index-sequential file? Explain with example how B+ tree overcomes it.
(c)
What do you mean by Serializable Schedule? Explain View Serializability with example.
Also asked in Summer 2024 Q4c, Winter 2023 Q4c OR
OR
(c)
Discuss various steps of query processing with diagram.
Also asked in Winter 2025 Q4c, Winter 2024 Q4c OR, Summer 2024 Q3c OR, Winter 2023 Q4c, Summer 2023 Q3c OR
Q.5
14 Marks(b)
What is the difference between Join and Sub query? Explain with example.
(c)
Consider the following relations and write SQL queries for given statements. Assume suitable constraints. Passengers(passenger_id, name, age, gender) Trains(train_id, train_name, source, destination) Bookings(booking_id, passenger_id, train_id, booking_date, fare)
1)Write a query to display all passengers with their booked train names.
2)Write a query to count total number of bookings per train.
3)Write a query to find the average fare of all bookings.
4)Write a query to rename the column name in Passengers table to full_name.
Also asked in Winter 2025 Q5c OR, Summer 2025 Q5c OR, Summer 2024 Q5c, Winter 2023 Q5c, Winter 2023 Q5c OR, Summer 2023 Q5c
OR
(a)
Explain Cursors in PL/SQL with example.
Also asked in Summer 2025 Q4b OR, Summer 2024 Q5b, Winter 2023 Q5a OR
(b)
Describe Data Definition Language and Data Manipulation Language.
(c)
Consider the following relations and write SQL queries for given statements. Assume suitable constraints. Guests(guest_id, name, contact, email) Rooms(room_id, room_number, room_type, price) Reservations(reservation_id, guest_id, room_id, check_in, check_out, total_amount)
1)Display guest names with their booked room numbers.
2)Update the price of room with room_id = 102 to 3500.
3)Find guests who have made more than 2 reservations.
4)Find guests who have not made any reservations.
Also asked in Winter 2025 Q5c OR, Summer 2025 Q5c OR, Summer 2024 Q5c, Winter 2023 Q5c, Winter 2023 Q5c OR, Summer 2023 Q5c
More DATABASE MANAGEMENT SYSTEM 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 SYSTEM (DBMS) (Summer 2026, 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.