Database Management Systems detailed syllabus for Information Technology (IT) for 2021 regulation curriculum has been taken from the Anna University official website and presented for the IT 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 Information Technology 4th Sem scheme and its subjects, do visit IT 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 Information Technology, 2021 regulation curriculum do visit IT 4th Sem subject syllabuses for 2021 regulation.
For all Information Technology results, visit Anna University IT all semester results direct link.