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) — extracted question text · 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. Check the original PDF for equations, diagrams and complete wording. Extracted: 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