Gujarat Technological UniversityWinter 2023 examination

GTU 3130703 Database Management Systems (DBMS) Winter 2023 Question Paper & PDF

B.E. · Computer Engineering · Semester 3 · Subject code 3130703
Download official PDFView PDF here
Share with your class
Total
70 marks
To pass
23 marks (33%)
Duration
2.5 Hours 10:30 AM – 1: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.

16 of 25 questions on this paper were also asked in other years. 5 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.1

14 Marks
(a)
3 marks
Define Superkey, Candidate Key and Primary Key.
(b)
4 marksAsked in 4 of 7 papers

Enlist advantages of Database Management Systems over traditional File System

Also asked in Winter 2025 Q2c, Summer 2025 Q1c, Winter 2024 Q1c

(c)
7 marks
Explain DBMS architecture with a neat sketch.

Q.2

14 Marks
(a)
3 marks
Differentiate terms relation and relation schema with suitable example.
(b)
4 marksAsked in 2 of 7 papers

List various integrity constraints in reltional model. Explain referential integrity constraint with suitable example.

Also asked in Summer 2024 Q2b

(c)
7 marksAsked in 3 of 7 papers

Briefly explain generalization and specialization in E-R diagram with suitable example.

Also asked in Winter 2025 Q3b, Winter 2024 Q2a

(c)
7 marksAsked in 2 of 7 papers
Differentiate Weak Entity and Strong Entity with suitable example.

Also draw a sample E-R diagram which depicts weak entity.

Also asked in Winter 2024 Q2c OR

Q.3

14 Marks
(a)
3 marksAsked in 2 of 7 papers
What is functional dependency? Explain armstrong’s axioms.

Also asked in Winter 2025 Q3a OR

(b)
4 marksSame type asked in 3 of 7 papers

Consider following relations and write queries in the form of relational algebra. Students(std_id, std_name, semester, dept_id) Departments(dept_id, dept_name, no_of_faculties)

1)List names of students studying in “Computer” department.
2)Display all information of the student whose name is “Pratik”

Also asked in Summer 2026 Q2a, Summer 2024 Q1c

(c)
7 marksAsked in 2 of 7 papers

What is normalization? Explain 2NF, 3NF and BCNF with suitable examples.

Also asked in Summer 2026 Q3c OR

(a)
3 marksAsked in 2 of 7 papers
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 Summer 2026 Q3b OR

(b)
4 marksSame type asked in 3 of 7 papers

Consider following relations and write queries in the form of relational algebra. Accounts(acc_no, acc_name, balance, bank_id) Bank(bank_id, bank_name, city)

1)List all Acount Numbers in “HDFC” bank.
2)List all bank names in “Ahmedabad” city.

Also asked in Summer 2026 Q2a, Summer 2024 Q1c

(c)
7 marksSame type asked in 3 of 7 papers
Consider the relation Employees(empId, empName, carName,
parkingSlot) with dependencies F ={empId→ carName, empId→
empName, carName→ parkingSlot}.
Does the above table appear in 3NF? If not, normalize it in 3NF.

Also asked in Summer 2026 Q3c, Winter 2024 Q3c OR

Q.4

14 Marks
(a)
3 marksAsked in 7 of 7 papers
List and explain ACID properties with respect to Database transaction.

Also asked in Summer 2026 Q3a, Winter 2025 Q4b OR, Summer 2025 Q3a OR, Winter 2024 Q4b OR, Summer 2024 Q4b, Summer 2023 Q4c

(b)
4 marksAsked in 2 of 7 papers
Write a short note on Intrusion Detection in DBMS.

Also asked in Summer 2026 Q4b OR

(c)
7 marksAsked in 6 of 7 papers
Discuss various steps of query processing with diagram.

Also asked in Summer 2026 Q4c OR, Winter 2025 Q4c, Winter 2024 Q4c OR, Summer 2024 Q3c OR, Summer 2023 Q3c OR

(a)
3 marksAsked in 3 of 7 papers
List and explain different types of locks in transactions.

Also asked in Winter 2025 Q4a, Summer 2024 Q4c OR

(b)
4 marksAsked in 2 of 7 papers
Write a short note on SQL injection.

Also asked in Summer 2025 Q4b

(c)
7 marksAsked in 3 of 7 papers

What do you mean by Serializable Schedule? Explain View Serializability with example.

Also asked in Summer 2026 Q4c, Summer 2024 Q4c

Q.5

14 Marks
(a)
3 marksAsked in 3 of 7 papers

What is a trigger? List various types of triggers and explain any one with example.

Also asked in Summer 2026 Q5a, Summer 2025 Q5b OR

(b)
4 marksAsked in 3 of 7 papers
Differentiate Sparse and Dense dense index in DBMS with example.

Also asked in Summer 2026 Q4a, Winter 2025 Q3b OR

(c)
7 marksSame type asked in 6 of 7 papers

Consider the following tables and answer the queries in SQL. Books (isbn_no, title, publisher_id, year) Authors (author_id, author_name, country, city) Publishers (publisher_id, publisher_name, city) WrittenBy (isbn_no, author_id)

1)List all the books published after 1998.
2)Update the city of author to “Baroda” whose author id is 10.
3)List all the book titles written by author “korth”
4)Add column “price” in the table Books.
5)Display number of Publishers from the city “Ahmedabad”.
6)List all the books published by “McGaw Hill”
7)Display all publishers in the ascending order of their name.

Also asked in Summer 2026 Q5c, Summer 2026 Q5c OR, Winter 2025 Q5c OR, Summer 2025 Q5c OR, Summer 2024 Q5c, Summer 2023 Q5c

(a)
3 marksAsked in 4 of 7 papers

What is a cursor? Differentiate implicit and explicit cursor with example.

Also asked in Summer 2026 Q5a OR, Summer 2025 Q4b OR, Summer 2024 Q5b

(b)
4 marks
Differentiate open and closed hashing in DBMS.
(c)
7 marksSame type asked in 6 of 7 papers

Consider the following tables and answer the queries in SQL. Products(prod_id, prod_name, category, price) Customers(cust_id, cust_name, country, city) Orders(order_id, cust_id, prod_id, order_date, quantity)

1)List all the products having price less than 2000.
2)Update price of a product to 3000 whose product id is 43.
3)Display names of customer who have placed atleast one order.
4)Display customer id and total number of orders placed by them.
5)List all Customers in the descending order of their city.
6)Display names of customers who have ordered “Television” (Product Name)
7)Remove column “category” from the Products table.

Also asked in Summer 2026 Q5c, Summer 2026 Q5c OR, Winter 2025 Q5c OR, Summer 2025 Q5c OR, Summer 2024 Q5c, 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.

Summer 202670 marks · 5 questions
Winter 202570 marks · 5 questions
Summer 202570 marks · 5 questions
Winter 202470 marks · 5 questions

Other Semester 3 subjects

BE Computer

130001
Mathematics-III
3130004
Effective Technical Communication
3130006
Probability and Statistics
3130702
Data Structures

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) (Winter 2023, 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 official PDF All Database Management Systems Papers (7) →Report a typo or correction
ViewDownload PDF