Gujarat Technological UniversityWinter 2024 examination

GTU 3130703 Database Management Systems (DBMS) Winter 2024 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.

11 of 25 questions on this paper were also asked in other years. 3 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 following terms.
i)Database Management System
ii)Instance
iii)Logical Data independence
(b)
4 marks

List and explain categories of database users. Describe roles and responsibilities of database administrator.

(c)
7 marksAsked in 4 of 7 papers

Compare the advantages of using a Database Management System (DBMS) over a file processing system. system

Also asked in Winter 2025 Q2c, Summer 2025 Q1c, Winter 2023 Q1b

Q.2

14 Marks
(a)
3 marksAsked in 3 of 7 papers
Explain generalization and specialization with neat diagram

Also asked in Winter 2025 Q3b, Winter 2023 Q2c

(b)
4 marks
Explain following attributes. a. Single Valued b. Multivalued c.

Derived attribute d. Composite attribute

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

Draw an E-R diagram of following scenario. Make necessary assumptions and clearly note down the assumptions. Municipal Corporation/any Bus reservation system should be digitize.

Also asked in Summer 2026 Q2c, Summer 2026 Q2c OR, Winter 2025 Q3c OR

(c)
7 marksAsked in 2 of 7 papers

Explain the concepts of strong entity and weak entity using real world example.

Also asked in Winter 2023 Q2c OR

Q.3

14 Marks
(a)
3 marks
Explain the terms.
i)Super Key
ii)Foreign Key
iii)Unique Key
(b)
4 marks
Explain trivial functional dependencies with suitable example.
(c)
7 marks
Consider a relation R(A, B, C, D, E) with the following three functional
dependencies.
AB → C ; BC → D ; C → E;
Find out the number of superkeys in the relation R.
(a)
3 marksAsked in 2 of 7 papers
Explain insertion and deleting anomalies with respect to normalization.

Also asked in Summer 2023 Q3a OR

(b)
4 marksAsked in 4 of 7 papers
Explain Armstrong’s axioms in detail.

Also asked in Summer 2026 Q2b, Summer 2025 Q3c OR, Summer 2024 Q2c

(c)
7 marksSame type asked in 3 of 7 papers
Given a relation R( P, Q, R, S, T) and Functional Dependency set FD
= { PQ → R, S → T }, determine whether the given R is in 2NF? If
not convert it into 2 NF.

Also asked in Summer 2026 Q3c, Winter 2023 Q3c OR

Q.4

14 Marks
(a)
3 marks
Illustrate various storage strategies.
(b)
4 marks

Explain authorization and authentication with respect to database security.

(c)
7 marks

Which kind of queries are solved using division operator? Explain in detail.

(a)
3 marksAsked in 2 of 7 papers
Differentiate dynamic hashing and static hashing

Also asked in Summer 2026 Q4a OR

(b)
4 marksAsked in 7 of 7 papers
Explain ACID properties of transaction.

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

(c)
7 marksAsked in 6 of 7 papers
Describe query processing with neat diagram.

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

Q.5

14 Marks
(a)
3 marksAsked in 3 of 7 papers
Explain working of two phase locking protocol.

Also asked in Winter 2025 Q4c OR, Summer 2025 Q5b

(b)
4 marks

Explain GRANT, REVOKE and SAVEPOINT commands with suitable example.

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

Assume table CUSTOMER (Cust_Id,Customer_name, Age,Address,Salary). Write a PL/SQL function which givens total number of customers having salary more than one lac per month.

Also asked in Winter 2025 Q5b

(a)
3 marksAsked in 2 of 7 papers

Differentiate between conflict and view serializability with respect to transaction.

Also asked in Summer 2023 Q4c OR

(b)
4 marksAsked in 2 of 7 papers
Categorize joins in the SQL. Explain each with suitable example.

Also asked in Summer 2023 Q2c OR

(c)
7 marks

Write a PL/SQL trigger where employee of “GTU Private Ltd.” company cannot update database on 23-Dec-2024 due to maintenance.

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
Summer 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 2024, 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