R23
IT · 2-2
✓ VERIFIED VS. PUBLISHED SYLLABUS 2026-07-11
Database Management Systems
JNTUK R23 · IT · semester 2-2 · syllabus
This JNTUK R23 professional core course is listed for Information Technology (IT). It is listed in semester 2-2. It carries 3 credits. The published coverage runs across 5 units, from Introduction and Entity Relationship Model through Transactions and Indexing.
Verified vs. published syllabus
Checked 11 Jul 2026
SOURCE DOCKET
Published evidence
✓ Verified
Checked 11 Jul 2026
Record 5 published units
Verification scope Subject name, credits, unit-wise syllabus, and course outcomes are sourced directly from JNTUK's own official R23 course structure and syllabus document, not an autonomous college's adaptation.
5 units, from Introduction and Entity Relationship Model to Transactions and Indexing. Tick off units as you cover them — your progress stays on this device.
Unit-wise syllabus
0 / 5 COVERED
UNIT 01 — Introduction and Entity Relationship Model
Database system, characteristics (database vs file system), database users, advantages, applications · Data models; schema, instance and data independence; three-tier schema architecture · Database system structure, environment, centralized and client-server architecture · Entity Relationship model: entities, attributes, entity set, relationship, constraints, subclasses, superclass, inheritance, specialization, generalization, ER diagrams
UNIT 02 — Relational Model and Basic SQL
Introduction to relational model, concepts of domain, attribute, tuple, relation, importance of null values · Constraints (domain, key constraints, integrity constraints) and their importance · Relational algebra, relational calculus · Basic SQL: simple schema, data types, table definitions (create, alter), DML operations (insert, delete, update)
UNIT 03 — SQL
Basic SQL querying (select and project) using where clause, arithmetic and logical operations, SQL functions · Creating tables with relationships, implementation of key and integrity constraints · Nested queries, sub queries, grouping, aggregation, ordering · Different types of joins, views (updatable and non-updatable), relational set operations
UNIT 04 — Schema Refinement (Normalization)
Purpose of normalization or schema refinement, concept of functional dependency · Normal forms based on functional dependency, lossless join and dependency preserving decomposition · 1NF, 2NF and 3NF; concept of surrogate key · Boyce-Codd normal form (BCNF), MVD, fourth normal form (4NF), fifth normal form (5NF)
UNIT 05 — Transactions and Indexing
Transaction concept, transaction state, ACID properties, concurrent executions, serializability, recoverability · Implementation of isolation, testing for serializability; lock based, timestamp based and optimistic concurrency protocols · Deadlocks, failure classification, storage, recovery and atomicity, recovery algorithm · Introduction to indexing techniques: B+ trees, operations on B+ trees, hash based indexing