AKTU Database Management System (DBMS) is a core subject for B.Tech CSE students, typically taught in Semester 5. Analysis of 6 years of AKTU DBMS PYQs (2018-2024) shows that SQL queries, ER diagram construction, normalization (1NF/2NF/3NF/BCNF), and transaction management are the most repeated topics. These topics collectively cover 70-75% of the total marks. RyzenStudy provides all AKTU DBMS question papers free for download.
AKTU DBMS — Subject Overview
| Detail | Information |
|---|---|
| Subject Name | Database Management System (DBMS) |
| Subject Code | KCS-502 / RCS-502 (varies by batch) |
| Semester | B.Tech CSE — 5th Semester |
| Total Marks | 100 (External 70 + Internal 30) |
| Credits | 3-4 Credits |
| Papers Available on RyzenStudy | 2018-19 to 2023-24 |
AKTU DBMS Syllabus — Unit-wise Topics
- Unit 1 — Introduction: Database concepts, DBMS vs File System, Data Models (ER, Relational, Hierarchical), Database Architecture (3-tier), Data Independence
- Unit 2 — Relational Model: Relational algebra, Tuple calculus, Domain calculus, SQL (DDL, DML, DCL, TCL), Views, Integrity constraints
- Unit 3 — Database Design: ER Model, ER to Relational mapping, Functional Dependencies, Normalization (1NF, 2NF, 3NF, BCNF, 4NF), Decomposition
- Unit 4 — Transaction Management: ACID properties, Concurrency control (2PL, Timestamp), Deadlock, Recovery techniques, Log-based recovery
- Unit 5 — Advanced Topics: Indexing (B-tree, B+ tree), Hashing, Query optimization, Distributed databases, NoSQL overview
Most Repeated AKTU DBMS Questions (2018-2024)
SQL Queries — Most Commonly Asked
SQL queries Section B aur C dono mein aate hain. Yeh queries practice karo:
- JOIN queries (INNER JOIN, LEFT JOIN, NATURAL JOIN) — har paper mein milte hain
- Aggregate functions (COUNT, SUM, AVG, MAX, MIN with GROUP BY and HAVING)
- Nested/Subqueries (correlated subqueries)
- CREATE TABLE with constraints (PRIMARY KEY, FOREIGN KEY, NOT NULL, UNIQUE, CHECK)
- UPDATE, DELETE with WHERE clause
- VIEWS — CREATE VIEW, advantages
ER Diagram Problems
ER diagrams Section C mein regularly aate hain. Practice scenario:
- Library Management System ER diagram (appeared 3/6 years)
- Hospital Management System ER diagram
- University/Student-Course-Teacher ER diagram
- Banking System ER diagram
ER to Relational schema conversion bhi Section B mein regularly aata hai.
Normalization Questions
AKTU DBMS mein normalization har paper mein hota hai:
- Given a relation with functional dependencies — find if it is in 3NF/BCNF
- Decompose a relation into 3NF/BCNF — lossless aur dependency preserving
- Find candidate keys aur minimal cover
- Definition questions: 1NF, 2NF, 3NF, BCNF differences
Transaction & ACID Properties
- ACID properties explain karo with examples — Section A/B mein guaranteed
- 2-Phase Locking (2PL) protocol explain karo
- Deadlock detection aur prevention
- Log-based recovery technique
- Serializability — conflict serializable ya view serializable test
Section A Short Questions — Most Likely DBMS
- Define ACID properties
- What is functional dependency?
- Difference between DDL and DML
- What is a view in SQL?
- Define BCNF
- What is a transaction?
- Difference between primary key and candidate key
- What is data independence?
- Define B+ tree indexing
- What is a deadlock in DBMS?
AKTU DBMS PYQ Free Download
RyzenStudy par B.Tech Semester 5 (CSE) ke sabhi PYQ papers free download karo — DBMS ke 2018 se 2024 tak ke 6 saalon ke papers available hain.
Frequently Asked Questions
AKTU DBMS mein kaun sa topic sabse zyada marks ka hai?
PYQ analysis ke anusar SQL + ER Diagram + Normalization mein milakr Section B aur C ke 50+ marks aate hain. Yeh teen topics solid karne se 60%+ marks guaranteed ho jaate hain.
AKTU DBMS practical mein kya aata hai?
AKTU DBMS practical mein typically SQL queries likhni hoti hain given scenarios ke liye, plus viva mein DBMS concepts ke questions. PYQ theory papers se viva preparation bhi cover ho jaati hai kyunki questions similar hote hain.