UnFoldPrep
Browse Archive
Gujarat Technological UniversityWinter 2025 Examination

GTU 3130703 Database Management Systems (DBMS) Winter 2025 Paper Solution & PDF

B.E. · Computer Engineering · Semester 3 · Subject Code: 3130703
Download Official GTU PDF
Share:
Total Marks70 MarksExternal theory exam
Passing Marks23 Marks33% minimum cutoff
Exam Duration2.5 Hours10:30 AM – 1:00 PM
Paper Structure5 QuestionsWith internal OR choices
Jump toQ1Q2Q3Q4Q5

Question 1

14 MarksMedium
(a)

Define following terms.

1Schema
2Instance
3Physical Data Independence
3 Marks
(b)
Explain three level architecture of DBMS.
4 Marks
(c)

What is integrity constraint? Explain primary key, reference key and check constraint with SQL syntax.

7 Marks

Question 2

14 MarksMedium
(a)

What is Data Definition Language? List DDL statements and explain anyone with an example.

3 Marks
(b)
Describe
1)Union and
2)Cartesian Product operations in relational algebra.
4 Marks
(c)

Explain the advantages of Database Management Systems over file processing system.

7 Marks
OR OPTION
(c)

List the type of Database Users. Explain their characteristics in brief. How they interact with DBMS?

7 Marks

Question 3

14 MarksMedium
(a)
List and explain mapping cardinalities of E-R diagram with example.
3 Marks
(b)
Briefly explain Generalization and Specialization in E-R diagram.
4 Marks
(c)

What is Normalization? Explain 1NF, 2NF and 3NF with suitable example.

7 Marks
OR OPTION
(a)
What is Functional Dependency? Explain armstrong’s axioms.
3 Marks
(b)
Differentiate Sparse and Dense index in DBMS with example.
4 Marks
(c)

Draw E-R diagram for a University Management System with the necessary assumption.

7 Marks

Question 4

14 MarksMedium
(a)
List and explain different types of locks in transactions.
3 Marks
(b)
Draw and explain transaction state diagram.
4 Marks
(c)
Discuss various steps of query processing with diagram.
7 Marks
OR OPTION
(a)
Discuss conflict serializability in transactions.
3 Marks
(b)
List and describe ACID property of transactions.
4 Marks
(c)
Explain the two-phase locking protocol in detail.
7 Marks

Question 5

14 MarksMedium
(a)

What is log-based recovery? List and explain various fields use in log records for log-based recovery.

3 Marks
(b)

Write a PL/SQL function which takes 3 integer numbers as parameters and return an average of same.

4 Marks
(c)
What is a deadlock? How to detect deadlock? Explain with example.
7 Marks
OR OPTION
(a)

Define following terms.

1Cascading Rollback
2Candidate Key
3View
3 Marks
(b)
Describe Grant and Revoke commands with suitable example.
4 Marks
(c)
Write SQL queries for the following:
1Create table Employee, Department and Location with following schema and appropriate data types and constraints.
aEmployee (employee_id, name, email, hire_date, salary, department_id, location_id)
bDepartment (department_id, department_name)
cLocation (location_id, street_address, postal_code, country)
2Add new column ‘city’ in the location table.
3Find all the details of employees whose name starts with or ends with ‘s’.
4Update the postal_code to '220212' where the country is 'India' and location_id is between 2 to 7.
5Delete all the records of Location table.
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.

Related papers

About this Examination Paper & Attribution

Official Gujarat Technological University (GTU) examination paper and step-by-step solutions for Database Management Systems (DBMS) (Winter 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.

Download PDF