R23
CSE/IT · 3-2
✓ VERIFIED VS. PUBLISHED SYLLABUS 2026-07-12
Principles of Database Management Systems
JNTUK R23 · CSE/IT · semester 3-2 · syllabus
This JNTUK R23 open elective is listed for CSE and IT. It is listed in semester 3-2. It carries 3 credits. The published coverage runs across 5 units, from Introduction through Transaction Concept.
Verified vs. published syllabus
Checked 12 Jul 2026
This official syllabus is shared across CSE, IT. One neutral page keeps the syllabus and source evidence together while the table below preserves each exact branch/semester placement.
SOURCE DOCKET
Published evidence
✓ Verified
Checked 12 Jul 2026
Record 5 published units
Verification scope The course placement, credits and five units are published in JNTUK’s official CSE document linked here and match the official IT syllabus.
5 units, from Introduction to Transaction Concept. Tick off units as you cover them — your progress stays on this device.
Unit-wise syllabus
0 / 5 COVERED
UNIT 01 — Introduction
Database systems; characteristics (database vs file system); database users · Advantages of database systems; database applications · Brief introduction of different data models; concepts of schema, instance and data independence · Three-tier schema architecture for data independence · Database system structure and environment; centralized and client-server architecture for the database
UNIT 02 — Entity Relationship Model and Relational Model
Representation of entities, attributes, entity set, relationship, relationship set, constraints · Sub classes, super class, inheritance, specialization, generalization using ER diagrams · Introduction to relational model: concepts of domain, attribute, tuple, relation · Importance of null values; constraints (domain, key, integrity constraints) and their importance
UNIT 03 — Basic SQL
Simple database schema, data types, table definitions (create, alter); DML operations (insert, delete, update) · Basic SQL querying (select and project) using where clause, arithmetic and logical operations · SQL functions (date and time, numeric, string conversion) · Creating tables with relationships; implementation of key and integrity constraints; nested and sub queries · Grouping, aggregation, ordering; different types of joins; updatable/non-updatable views; 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, 3NF) · Concept of surrogate key · Boyce-Codd normal form (BCNF)
UNIT 05 — 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