Database Management Systems detailed syllabus for Computer Science & Engineering (CSE) for 2021 regulation curriculum has been taken from the Anna University official website and presented for the CSE students. For course code, course name, number of credits for a course and other scheme related information, do visit full semester subjects post given below.
For Computer Science & Engineering 4th Sem scheme and its subjects, do visit CSE 4th Sem 2021 regulation scheme. The detailed syllabus of database management systems is as follows.
Course Objectives:
Download the iStudy App for all syllabus and other updates.
Unit I
RELATIONAL DATABASES 10 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
Download the iStudy App for all syllabus and other updates.
Unit III
TRANSACTIONS 9 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
Download the iStudy App for all syllabus and other updates.
Unit V
ADVANCED TOPICS 9 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 -69 Access control based on privileges – Role Based access control – SQL Injection – Statistical Database security – Flow control – Encryption and Public Key infrastructures – Challenges
Course Outcomes:
Download the iStudy App for all syllabus and other updates.
Text Books:
- Abraham Silberschatz, Henry F. Korth, S. Sudharshan, Database System Concepts, Seventh Edition, McGraw Hill, 2020.
- Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, Seventh Edition, Pearson Education, 2017
Reference Books:
- C.J.Date, A.Kannan, S.Swamynathan, An Introduction to Database Systems, Eighth Edition, Pearson Education, 2006.
For detailed syllabus of all other subjects of Computer Science & Engineering, 2021 regulation curriculum do visit CSE 4th Sem subject syllabuses for 2021 regulation.
For all Computer Science & Engineering results, visit Anna University CSE all semester results direct link.