KTU Database Management Systems Notes 2019 Scheme S4 CSE

KTU Database Management Systems Notes 2019 Scheme S4 CSE

Database Management Systems (DBMS) CST204 of KTU provides a clear understanding of the basic principles of Database Management System (DPMS). Topics covered in this course include basic DPMS concepts, organizational relationship (ER) models, relational database theory, related algebra, Structured Query Language (SQL), physical data structures, normalization and transaction processing concepts. Of course, the alternative data management model provides an overview of NoSQL. 

This course helps companies manage data effectively by identifying appropriate structures for maintaining data assets and developing applications that use database technologies. You can learn KTU topics through our excellent research material including notes, presentations and final question papers, easily available on our website (www.keralanotes.com).

Board KTU
Scheme 2019 New Scheme
Year Second Year
Semester S4  Computer Science
Subject CST204 | Database Management Systems Notes 
Credit 4 Credit
Category KTU S4 Computer Science 

KTU S4 CSE Database Management Systems | CST204 | Notes (2019 Scheme)

Are you in need of study materials for Database Management Systems CST204? For the final DBMS, there will be two parts; Part A and Part B. Part A contains 10 questions with 2 questions from each module, having 3 marks for each question. Students should answer all questions. Part B contains 2 questions from each module of which a student should answer anyone. Each question can have a maximum of 2 sub-divisions and carries 14 marks.

Module 1

Module 1 - Syllabus

Introduction & Entity-Relationship (ER) Model

Concept & Overview of Database Management Systems (DBMS) - Characteristics of the Database system, Database Users, structured, semi-structured and unstructured data. Data Models and Schema - Three Schema architecture. Database Languages, Database architectures and classification. 

ER model - Basic concepts, entity set & attributes, notations, Relationships and constraints, cardinality, participation, notations, weak entities, relationships of degree 3.

Module 1 - Notes

Module 1 Database Management Systems | CST204 PPT Notes


Module 1 Database Management Systems | CST204 PDF Short Notes


Module 2

Module 2 - Syllabus

Relational Model

Structure of Relational Databases - Integrity Constraints, Synthesizing ER diagram to relational schema 

Introduction to Relational Algebra - select, project, cartesian product operations, join - Equi-join, natural join. query examples, introduction to Structured Query Language (SQL), Data Definition Language (DDL), Table definitions and operations – CREATE, DROP, ALTER, INSERT, DELETE, UPDATE.

Module 2 - Notes

Module 2 Database Management Systems| CST204 PPT Notes


Module 2 Database Management Systems| CST204 PDF Short Notes


Module 3

Module 3 - Syllabus

SQL DML (Data Manipulation Language), Physical Data Organization

SQL DML (Data Manipulation Language) - SQL queries on single and multiple tables, Nested queries (correlated and non-correlated), Aggregation and grouping, Views, assertions, Triggers, SQL data types. 

Physical Data Organization - Review of terms: physical and logical records, blocking factor, pinned and unpinned organization. Heap files, Indexing, Singe level indices, numerical examples, Multi-level-indices, numerical examples, B-Trees & B+-Trees (structure only, algorithms not required), Extendible Hashing, Indexing on multiple keys – grid files.

Module 3 - Notes

Module 3 Database Management Systems| CST204 PDF Notes


Module 3 Database Management Systems| CST204 PPT Notes


Module 3 Database Management Systems| CST204 PDFShort Notes


Module 4

Module 4 - Syllabus


Different anomalies in designing a database, The idea of normalization, Functional dependency, Armstrong’s Axioms (proofs not required), Closures and their computation, Equivalence of Functional Dependencies (FD), Minimal Cover (proofs not required). First Normal Form (1NF), Second Normal Form (2NF), Third Normal Form (3NF), Boyce Codd Normal Form (BCNF), Lossless join and dependency preserving decomposition, Algorithms for checking Lossless Join (LJ) and Dependency Preserving (DP) properties.

Module 4 - Notes

Module 4 Database Management Systems| CST204 PPT Notes


Module 4 Database Management Systems| CST204 PDF Short Notes


Module 5

Module 5 - Syllabus

Transactions, Concurrency and Recovery, Recent Topics

Transaction Processing Concepts - overview of concurrency control, Transaction Model, Significance of concurrency Control & Recovery, Transaction States, System Log, Desirable Properties of transactions. 

Serial schedules, Concurrent and Serializable Schedules, Conflict equivalence and conflict serializability, Recoverable and cascade-less schedules, Locking, Two-phase locking and its variations. Log-based recovery, Deferred database modification, check-pointing. Introduction to NoSQL Databases, Main characteristics of Key-value DB (examples from: Redis), Document DB (examples from: MongoDB) 

Main characteristics of Column - Family DB (examples from Cassandra) and Graph DB (examples from ArangoDB)

Module 5 - Notes

Module 5 Database Management Systems | CST204 PPT Notes


Module 5 Database Management Systems | CST204 PDF Short Notes


Feel free to comment and share this if you found it useful. Give your valuable suggestions in the comment session or contact us for any details regarding the KTU Second Year S4 Computer Science (CSE) 2019 Scheme Study Materials, Syllabus, Previous Year Solved Question Papers, and Other Materials. 

KTU S4 CSE Related Links

Other Related Links

We hope the given KTU S4 Computer Science (CSE) Latest 2019 Scheme Syllabus, Notes, Study Materials, Previous Year Questions and Other Materials will help you.

If you have any queries regarding the KTU S4 Computer Science (CSE) Study Materials, drop a comment below and we will get back to you at the earliest.

Keralanotes.com      Keralanotes.com      Keralanotes.com      Keralanotes.com      Keralanotes.com      

#buttons=(Accept !) #days=(30)

Our website uses cookies to enhance your experience. know more
Accept !
To Top

KTU B.Tech Crash Course, Join Now !