2021 2022 Student Forum > Management Forum > Main Forum

 
  #2  
26th March 2013, 08:58 AM
Super Moderator
 
Join Date: May 2012
Re: Anna University Syllabus for IT

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.
Attached Files
File Type: pdf Anna University BE IT Syllabus.pdf (456.6 KB, 55 views)


Tags
syllabus

Quick Reply
Your Username: Click here to log in

Message:
Options

Thread Tools Search this Thread



All times are GMT +5. The time now is 06:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
SEO by vBSEO 3.6.0 PL2

1 2 3