Question 1
(a)
Explain candidate key, primary key and foreign key.
3 Marks
(b)
Explain different types of database users.
4 Marks
(c)
Explain database system 3-tier architecture with diagram in detail.
7 Marks
Gujarat Technological UniversitySummer 2026 Examination
GTU 3130703 DATABASE MANAGEMENT SYSTEM (DBMS) Summer 2026 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)
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.
3 Marks
(b)
Explain Armstrong’s axioms.
4 Marks
(c)
Draw E-R diagram for canteen management system showing at least four entity types and their relationships with necessary assumptions.
7 Marks
OR OPTION
(c)
Draw E-R diagram for an online shopping system showing at least four entity types and their relationships with necessary assumptions.
7 Marks
Question 3
(a)
Explain ACID properties of transaction.
3 Marks
(b)
Differentiate lossy decomposition and lossless decomposition.
4 Marks
(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.7 Marks
OR OPTION
(a)
Explain Two phase commit protocol.
3 Marks
(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?4 Marks
(c)
What is normalization? Explain 2NF, 3NF and BCNF with suitable examples.
7 Marks
Question 4
(a)
Differentiate Sparse and Dense dense index in DBMS.
3 Marks
(b)
What is the limitation of index-sequential file? Explain with example how B+ tree overcomes it.
4 Marks
(c)
What do you mean by Serializable Schedule? Explain View Serializability with example.
7 Marks
OR OPTION
(a)
Differentiate dynamic hashing and static hashing.
3 Marks
(b)
Write a short note on Intrusion Detection in DBMS.
4 Marks
(c)
Discuss various steps of query processing with diagram.
7 Marks
Question 5
(a)
Explain Triggers in PL/SQL with example.
3 Marks
(b)
What is the difference between Join and Sub query? Explain with example.
4 Marks
(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.
7 Marks
OR OPTION
(a)
Explain Cursors in PL/SQL with example.
3 Marks
(b)
Describe Data Definition Language and Data Manipulation Language.
4 Marks
(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.
7 Marks
College Exam Groups
Studying for DATABASE MANAGEMENT SYSTEM?
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 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.