B.TechSemester 42024-25Basics Of Database Management SystemsBOE407

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

B.Tech · Semester 4 · Free PDF Download

This is the official AKTU Basics Of Database Management Systems Previous Year Question Paper for B.Tech Semester 4, 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 4

Session:2024-25

University:AKTU / UPTU

Rate this paper

Questions Asked in 2024-25

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

Section AAttempt all questions in brief. 02 x 7 = 14

a
List the benefits of database system over file system
b
Differentiate between generalization and specialization
c
What is the SELECT operation in relational algebra?
d
Differentiate between unary and binary relational operations
e
Write the characteristics of SQL
f
What is multi-valued dependency?
g
What is locking in concurrency control?

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

a
Explain the architecture of a database system and differentiate between the three levels of abstraction
b
Describe the components of an ER diagram. Draw an ER diagram for a university management system
c
Write and explain SQL queries to create a table, insert values, update records, and delete data
d
List the Armstrong’s Axioms for functional dependency. Consider a relation R(A, B, C, D) having two FD sets FD1 ={A ->B, B->C, A->C} and FD2 = {A - >B, B->C, A->D}. Check whether or not they are equivalent
e
What is deadlock? How can it be detected and resolved in database systems?

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

a
Define primary key, foreign key, candidate key, and super key with suitable examples
b
Define the terms schema and instance. Explain the different types of database schemas
a
Construct an E-R diagram for a hospital with a set of patients and set of medical doctors. Associate with each patient a log of the various tests and examination conducted. Also convert your E-R diagram into relations
b
Explain relational algebra with SELECT, PROJECT, JOIN, UNION, INTERSECTION, and DIFFERENCE operations
a
Describe aggregate functions in SQL with suitable examples. How are GROUP BY and HAVING used?
b
What are views in SQL? How are they created and used?
a
Consider a relation R (A, B, C) with a set of functional dependency F ={A>B, B- > C, A->BC, AB->C}. Find out all Candidate key of R and canonical cover of FDs
b
Consider the relation R(A, B,C,D,E) and FD’s Is the Decomposition R into R1(A, C, D),R2(B,C,D) and R3(E,F,D) lossless?
a
Discuss 2 phase commit (2PC) protocol and time stamp -based protocol with suitable example. How the validation-based protocols differ from 2PC?
b
What do you mean by Transaction? Draw state diagram of a transaction showing its states. Explain properties of transaction with suitable example

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.

Basics Of Database Management Systems — Other Year Papers

AKTU Basics Of Database Management Systems PYQs from other sessions

Basics Of Database Management Systems2023-24 Basics Of Database Management Systems2024-25 Basics Of Database Management Systems2023-24 Basics Of Database Management Systems2025-26

More B.Tech Semester 4 (2024-25) Papers

Other subjects from same semester and session

Analog Circuits2024-25 Applied Thermodynamics2024-25 Polymer Science And Technology2024-25 Analog Electronics Circuits2024-25 Universal Human Values Professional Ethics2024-25 Python Programming2024-25 Theory Of Automata And Formal Languages2024-25 Digital Electronics2024-25

View all B.Tech Semester 4 2024-25 papers →

Syllabus & More PYQs

Paper solve karne se pehle unit-wise syllabus dekh lo

AKTU 2nd Year PYQs — All Branches