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) — extracted question text · 70 marks · 3 Hours
Section AAttempt all questions in brief. 2 x 07 = 14
- aDescribe the notation used in an ER diagram
- bList any four disadvantages of file system approach over datab ase approach
- cDifferentiate between physical and logical data independence
- dWhat is the difference between DROP and DELETE command?
- eDefine the term ACID properties?
- fWhat is deadlock? What are necessary conditions for it?
- gDistinguish between Share d and Exclusive Locks?
Section BAttempt any three of the following: 07 x 3 = 21
- aDescribe the three-schema architecture. Why do we need mappi ngs between schema levels? How do different schema definition languages support this architecture?
- bWhat are the different types of Data Models in DBMS? Explain them
- cExplain 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
- dExplain view serializable and cascadeless schedule with suit able example of each
- eExplain 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
- aCompare Generalization, Specialization and aggregation with suitable examples
- bDescribe the processes of generalization, aggregation, and r eduction in an ER diagram, highlighting thei r purpose and impact on databas e design
- aExplain the unary relational operations in Relational Algebr a, focusing on the SELECT and PROJECT opera tions. Provide examples to illustrate their usage
- bDiscuss Join and Types (natur al join, inner join, outer join) with suitable example and SQL syntax
- aWhat is a view in SQL, and how is it used to simplify database management? Provide examples of creating and using views in SQL
- bDefine functional dependency? Also discuss lossless and loss y decomposition in detail
- aWhat do you mean by Transaction? Explain transaction propert y with detail and suitable example. Also, Explain the different states i n a transaction
- bDescribe multi-valued dependencies (MVDs) and their role in database normalization. What is the fourth normal form (4NF), and how do es it address MVDs?
- aProvide 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
- bDiscuss 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. 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
More B.Tech Semester 3 (2024-25) Papers
Other subjects from same semester and session
Energy Science Engineering2024-25Food Science And Nutrition2024-25Data Structure2024-25Cyber Security2024-25Basics Data Structure Algorithms2024-25Universal Human Values And Professional Ethics2024-25Automation And Robotics2024-25Sensor Instrumentation2024-25
View all B.Tech Semester 3 2024-25 papers →Syllabus & More PYQs
Paper solve karne se pehle unit-wise syllabus dekh lo