UnFoldPrep
Browse Archive
Gujarat Technological UniversityWinter 2024 Examination

GTU 3130703 Database Management Systems (DBMS) Winter 2024 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.
i)Database Management System
ii)Instance
iii)Logical Data independence
3 Marks
(b)

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

4 Marks
(c)

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

7 Marks

Question 2

14 MarksMedium
(a)
Explain generalization and specialization with neat diagram
3 Marks
(b)
Explain following attributes. a. Single Valued b. Multivalued c.

Derived attribute d. Composite attribute

4 Marks
(c)

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.

7 Marks
OR OPTION
(c)

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

7 Marks

Question 3

14 MarksMedium
(a)
Explain the terms.
i)Super Key
ii)Foreign Key
iii)Unique Key
3 Marks
(b)
Explain trivial functional dependencies with suitable example.
4 Marks
(c)
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.
7 Marks
OR OPTION
(a)
Explain insertion and deleting anomalies with respect to normalization.
3 Marks
(b)
Explain Armstrong’s axioms in detail.
4 Marks
(c)
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.
7 Marks

Question 4

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

Explain authorization and authentication with respect to database security.

4 Marks
(c)

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

7 Marks
OR OPTION
(a)
Differentiate dynamic hashing and static hashing
3 Marks
(b)
Explain ACID properties of transaction.
4 Marks
(c)
Describe query processing with neat diagram.
7 Marks

Question 5

14 MarksMedium
(a)
Explain working of two phase locking protocol.
3 Marks
(b)

Explain GRANT, REVOKE and SAVEPOINT commands with suitable example.

4 Marks
(c)

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.

7 Marks
OR OPTION
(a)

Differentiate between conflict and view serializability with respect to transaction.

3 Marks
(b)
Categorize joins in the SQL. Explain each with suitable example.
4 Marks
(c)

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

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 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 PDF