Anna University Syllabus for IT

Can you please provide me the Syllabus of 3rd Sem to 8th Sem of BE IT for Anna University??

[Pathak]

Here I am providing you syllabus of 3rd Sem to 8th Sem of BE IT for Anna University.

UNIT I INTRODUCTION
Purpose of Database System -– Views of data – Data Models – Database
Languages –– Database System Architecture – Database users and Administrator –
Entity–Relationship model – E-R Diagrams -- Introduction to relational databases

UNIT II RELATIONAL MODEL
The relational Model – The catalog- Types– Keys - Relational Algebra – Domain
Relational Calculus – Tuple Relational Calculus - Fundamental operations –
Additional Operations- SQL fundamentals - Integrity – Triggers - Security – Advanced
SQL features –Embedded SQL– Dynamic SQL- Missing Information– Views –
Introduction to Distributed Databases and Client/Server Databases

UNIT III DATABASE DESIGN
Functional Dependencies – Non-loss Decomposition – Functional Dependencies –
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 IV TRANSACTIONS
Transaction Concepts - Transaction Recovery – ACID Properties – System Recovery
– Media Recovery – Two Phase Commit - Save Points – SQL Facilities for recovery –
Concurrency – Need for Concurrency – Locking Protocols – Two Phase Locking –
Intent Locking – Deadlock- Serializability – Recovery Isolation Levels – SQL Facilities
for Concurrency

Rest of the syllabus of 3rd to 8th Semester is attached in below file which is free for you.