KTU 2024 Scheme · Semester 4 · Common to CS/CD/CA/CR/AD/AI/CB/CN/CC/CU/CI/CG

Database Management Systems (PCCST402) Syllabus

Official KTU 2024 Scheme syllabus for Database Management Systems, Semester 4, Common to CS/CD/CA/CR/AD/AI/CB/CN/CC/CU/CI/CG (Computer Science and Engineering).

This page compiles APJ Abdul Kalam Technological University's officially published 2024 Scheme syllabus for Computer Science and Engineering, Semester 4, sourced directly from KTU's official website (ktu.edu.in). Learnizo is an independent online tuition platform and is not affiliated with, endorsed by, or officially connected to APJKTU. The university may revise syllabus content after this page was last updated — always cross-check with the official KTU source for the current, authoritative version.

Course Code

PCCST402

Credits

Teaching Hours

3:1:0:0 (L:T:P:R)

CIE Marks

ESE Marks

Exam Duration

2 Hrs 30 Min

Prerequisites

PCCST303 (Data Structures and Algorithms)

Semester

Semester 4

Course Objective

To equip students with a comprehensive understanding of fundamental DBMS concepts as well as the principles and applications of NoSQL databases, and to enable students to design, implement, and manage both relational and NoSQL databases.

Module-wise Syllabus

Module 1

11 contact hours

Introduction to Databases: database system concepts and architecture — data models, schemas and instances, three-schema architecture and data independence, database languages and interfaces, centralized and client/server architectures for DBMSs. Conceptual Data Modelling and Database Design: data modelling using the ER model — entity types, entity sets, attributes and keys, relationship types, relationship sets, roles and structural constraints, weak entity types; refining the ER design for the COMPANY database.

Module 2

11 contact hours

The Relational Data Model and SQL: the relational data model and relational database constraints, relational algebra and relational calculus, Structured Query Language (SQL) — DDL, DML, assertions, triggers, views, relational database design using ER-to-relational mapping.

Module 3

11 contact hours

Database Design Theory & Normalization: functional dependencies (basic definition), normalization — first, second and third normal forms. Transaction Management: transaction processing — introduction, problems and failures in transaction, desirable properties of transaction, characterizing schedules based on recoverability and serializability; concurrency control with two-phase locking techniques; database recovery management — deferred update, immediate update, shadow paging.

Module 4

11 contact hours

Introduction to NoSQL Concepts: types of NoSQL databases, CAP theorem, BASE properties, use cases and limitations of NoSQL. NoSQL architectural patterns: key-value stores, graph stores, column family stores and document stores.

Course Outcomes

CO1Summarize and exemplify the fundamental nature and characteristics of database systems.
CO2Model and design solutions for efficiently representing data using the relational model or non-relational model.
CO3Discuss and compare the aspects of concurrency control and recovery in database systems.
CO4Construct advanced SQL queries to effectively retrieve, filter, and manipulate data from relational databases.
CO5Experiment with NoSQL databases in real world applications.

Assessment Pattern (CIE: 40 marks, ESE: 60 marks)

Continuous Internal Evaluation (CIE)

Attendance	5
Assignment / Microproject	15
Internal Examination 1 (Written)	10
Internal Examination 2 (Written)	10

End Semester Examination (ESE)

Total 60 marks, 2 Hrs 30 Min. See the official KTU syllabus document for the exact Part A / Part B question pattern for this course.

Textbooks & Reference Books

Textbooks

Fundamentals of Database Systems — Elmasri, Navathe (Pearson, 7th edition, 2014)
Making Sense of NoSQL: A Guide for Managers and the Rest of Us — Dan McCreary and Ann Kelly (Manning, —)

Reference Books

Database System Concepts — Abraham Silberschatz, Henry F. Korth, S. Sudarshan (McGraw Hill, 7th edition, 2011)
Beginning Database Design Solutions — Rod Stephens (Wiley, 2nd edition, 2023)
NoSQL Distilled — Pramod J. Sadalage, Martin Fowler (Addison-Wesley, 1st edition, 2012)
NoSQL Data Models: Trends and Challenges (Computer Engineering: Databases and Big Data) — Olivier Pivert (Ed.) (Wiley, 2018)

Frequently Asked Questions

How many credits is KTU Database Management Systems (PCCST402)?

4 credits, with 3:1:0:0 (L:T:P:R) teaching hours per week, under the KTU 2024 Scheme.

How many modules are in the PCCST402 syllabus?

4 modules, 44 total contact hours.

What is the CIE and ESE mark split for this course?

CIE (Continuous Internal Evaluation): 40 marks. ESE (End Semester Examination): 60 marks, 2 Hrs 30 Min. Total: 100 marks.

What are the recommended textbooks for PCCST402?

Fundamentals of Database Systems (Elmasri, Navathe); Making Sense of NoSQL: A Guide for Managers and the Rest of Us (Dan McCreary and Ann Kelly).

Is this syllabus specific to one branch, or common to others too?

This Semester 4 course is listed under Common to CS/CD/CA/CR/AD/AI/CB/CN/CC/CU/CI/CG at KTU under the 2024 Scheme — check the course header above for which branches it's common to.

Need help with KTU Database Management Systems?

Learnizo offers live, 1-on-1 online tuition for KTU CSE subjects — matched to your exact module and semester.

Explore BTech CSE Tuition