B.TechSemester 32023-24Basics Of Database Management SystemsBOE307

Basics Of Database Management Systems (BOE307) - AKTU Question Paper 2023-24

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 2023-24. 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:2023-24

University:AKTU / UPTU

Rate this paper

Questions Asked in 2023-24

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

Section AAttempt all q u e s t i o n s i n b r i e f . 2 x 7 = 14

a
Define the terms "data model schema" and "data model instance". 2 1
b
Describe the notation use d in an ER diagram. 2 1
c
Define the Relational Data Model. 2 2
d
What are integrity constraints in the Relational Data Model? 2 2
e
What is SQL (Structured Query Language). 2 3
f
Define functional dependencies. 2 4
g
Define a transaction in the cont ext of database management. 2 5

Section BAttempt any three o f t h e f o l l o w i n g : 7 x 3 = 21

a
Describe the processes of generalization, aggregation, and r eduction in an ER diagram, highlighting th eir purpose and impact on databas e design
b
Describe the different types of constraints in the Relationa l Data Model, including key constraints and domain constraints, and provide examples of each
c
Provide examples of SQL INSERT, DELETE, and UPDATE statements. Explain how each statement is used to modify data i n a database table
d
Explain the concept of lossl ess join decomposition in the co ntext of normalization. What conditions must be satisfied for a decomposition to be lossless join?
e
Explain the concept of two-phase locking (2PL) techniques fo r concurrency control. How does 2PL ensure serializability of transactions, and what are its advanta ges and limitations?

Section CAttempt any one p a r t o f t h e f o l l o w i n g : 7 x 1 = 7

a
Describe the overall structure of a database system, includi ng the various levels of data abstraction and the interaction between them
b
Describe the process of reducing an ER diagram to relational t a b l e s , including the steps involved an d potential challenges in the transformation process
a
Explain the unary relational operations in Relational Algebr a, focusing on the SELECT and PROJECT operations. Provide examples to illustrate their usa
b
What are binary relational operations in Relational Algebra? Describe the CROSS and JOIN operations, highlighting their differences and use cases
a
Explain the different types of SQL joins (e.g., INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN) and provide examples of each
b
What is a view in SQL, and how is it used to simplify databa se management? Provide examples of creating and using views in SQL
a
Explain the concept of a minimal cover for a set of function al dependencies. How is a minimal cover derived, and why is it important in the normalization process?
b
Describe multi-valued depende ncies (MVDs) and their role in database normalization. What is the fourth normal form (4NF), and how do es it address MVDs?
a
What is serializability of tr ansaction scheduling, and why is it important in database concurrency control? How can you determine if a transaction schedule is serializable?
b
Provide examples of transaction schedules and analyze whethe r they are conflict serializable and/or view serializable. Identify any co nflicts or dependencies between transactions and determine if the schedule s are serializable

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 use d in an ER diagram. 2 1