B.TechSemester 32024-25Basics Of Database Management SystemsBOE307

Basics Of Database Management Systems (BOE307) - AKTU Question Paper 2024-25

B.Tech · Semester 3 · Free PDF Download

This is the official AKTU Basics Of Database Management Systems Previous Year Question Paper for B.Tech Semester 3, academic session 2024-25. Published by Dr. A.P.J. Abdul Kalam Technical University (AKTU/UPTU), Lucknow. Free PDF download — no login required.

Course:B.Tech

Semester:Semester 3

Session:2024-25

University:AKTU / UPTU

Rate this paper

Questions Asked in 2024-25

Basics Of Database Management Systems (BOE307) — complete question paper · 70 marks · 3 Hours

Section AAttempt all questions in brief. 2 x 07 = 14

a
Describe the notation used in an ER diagram
b
List any four disadvantages of file system approach over datab ase approach
c
Differentiate between physical and logical data independence
d
What is the difference between DROP and DELETE command?
e
Define the term ACID properties?
f
What is deadlock? What are necessary conditions for it?
g
Distinguish between Share d and Exclusive Locks?

Section BAttempt any three of the following: 07 x 3 = 21

a
Describe the three-schema architecture. Why do we need mappi ngs between schema levels? How do different schema definition languages support this architecture?
b
What are the different types of Data Models in DBMS? Explain them
c
Explain Normalization. Describ e 1 N F , 2 N F , 3 N F a n d B C N F w i t h suitable example
d
Explain view serializable and cascadeless schedule with suit able example of each
e
Explain the following protocol for concurrency control: (1) Lock Based Protocol. (2) Time stamp based protocol

Section CAttempt any one part of the following: 07 x 1 = 07

a
Compare Generalization, Specialization and aggregation with suitable examples
b
Describe the processes of generalization, aggregation, and r eduction in an ER diagram, highlighting thei r purpose and impact on databas e design
a
Explain the unary relational operations in Relational Algebr a, focusing on the SELECT and PROJECT opera tions. Provide examples to illustrate their usage
b
Discuss Join and Types (natur al join, inner join, outer join) with suitable example and SQL syntax
a
What is a view in SQL, and how is it used to simplify database management? Provide examples of creating and using views in SQL
b
Define functional dependency? Also discuss lossless and loss y decomposition in detail
a
What do you mean by Transaction? Explain transaction propert y with detail and suitable example. Also, Explain the different states i n a transaction
b
Describe multi-valued dependencies (MVDs) and their role in database normalization. What is the fourth normal form (4NF), and how do es it address MVDs?
a
Provide examples of transacti on schedules and analyze whether they are conflict serializable and/or view serializable. Identify any co nflicts or dependencies between t ransactions and determine if the schedule s are serializable
b
Discuss the timestamp ordering protocol for concurrency cont rol. How does strict timestamp ordering differ from basic timestamp orde ring?

Question text is extracted from the official AKTU question paper PDF above. Hindi translations are omitted — every question is printed in English in the original paper. Last verified: 2026-08-23.

Repeated Questions — BOE307

Questions that appeared in more than one session, found by comparing 2 years of Basics Of Database Management Systems papers (2023-24, 2024-25)

Describe the notation used in an ER diagram