Categories
Important question Notes question bank Question Paper R-2021 Syllabus

CS3492 Database Management Systems [PDF]

CS3492 Database Management Systems Study Materials

Anna University – CS3492 Database Management Systems Regulation 2021 Syllabus , Notes , Important Questions, Question Paper with Answers Previous Year Question Paper.

UNIT I RELATIONAL DATABASES CS3492 Database Management Systems Syllabus
Purpose of Database System – Views of data – Data Models – Database System Architecture –
Introduction to relational databases – Relational Model – Keys – Relational Algebra – SQL fundamentals
– Advanced SQL features – Embedded SQL– Dynamic SQL

UNIT II DATABASE DESIGN CS3492 Database Management Systems Notes
Entity-Relationship model – E-R Diagrams – Enhanced-ER Model – ER-to-Relational Mapping – Functional Dependencies – Non-loss Decomposition – First, Second, Third Normal Forms, Dependency Preservation – Boyce/Codd Normal Form – Multi-valued Dependencies and Fourth Normal Form – Join
Dependencies and Fifth Normal Form

UNIT III TRANSACTIONS CS3492 Database Management Systems Important Questions
Transaction Concepts – ACID Properties – Schedules – Serializability – Transaction support in SQL –
Need for Concurrency – Concurrency control –Two Phase Locking- Timestamp – Multiversion –
Validation and Snapshot isolation– Multiple Granularity locking – Deadlock Handling – Recovery
Concepts – Recovery based on deferred and immediate update – Shadow paging – ARIES Algorithm

UNIT IV IMPLEMENTATION TECHNIQUES CS3492 Database Management Systems Question Bank
RAID – File Organization – Organization of Records in Files – Data dictionary Storage – Column
Oriented Storage– Indexing and Hashing –Ordered Indices – B+ tree Index Files – B tree Index Files –
Static Hashing – Dynamic Hashing – Query Processing Overview – Algorithms for Selection, Sorting
and join operations – Query optimization using Heuristics – Cost Estimation.

UNIT V ADVANCED TOPICS CS3492 Database Management Systems Question Paper
Distributed Databases: Architecture, Data Storage, Transaction Processing, Query processing and
optimization – NOSQL Databases: Introduction – CAP Theorem – Document Based systems – Key
value Stores – Column Based Systems – Graph Databases. Database Security: Security issues –
Access control based on privileges – Role Based access control – SQL Injection – Statistical Database
security – Flow control – Encryption and Public Key infrastructures – Challenges

Syllabus Click Here
Notes Click Here
Important Questions Click Here
Previous Year Question Paper Click Here
Question Bank Click Here

TEXT BOOKS: CS3492 Database Management Systems Notes

1. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System Concepts”, Seventh
Edition, McGraw Hill, 2020.
2. Ramez Elmasri, Shamkant B. Navathe, “Fundamentals of Database Systems”, Seventh Edition,
Pearson Education, 2017

REFERENCES: CS3492 Database Management Systems Important Questions

1. C.J.Date, A.Kannan, S.Swamynathan, “An Introduction to Database Systems”, Eighth Edition,
Pearson Education, 2006.

Related Links

Anna University Syllabus Regulation 2021

Anna University Regulation 2021 Study Materials

Anna University Results

CGPA Calculator For Anna University

Download Padeepz App for Android

 

Leave a Reply

Your email address will not be published. Required fields are marked *