Anna University DBMS Notes

Sir I have lost my Database Management Systems (DBMS) Notes of Anna University and My exams are on my head . Would you please provide me the DBMS Notes online ?Can you provide me a pdf so I will download it and it would be safe in my system so I will read these notes when I want ??

Hi buddy here I am looking for Anna University DBMS (Database Management Systems) Notes /syllabus so would you plz let me know from where I can do download it ??

[pooja]

As you want here I am giving below Anna University DBMS (Database Management Systems) Notes /syllabus on your demand :

Anna University DBMS (Database Management Systems) Notes /syllabus
CS6302 DATABASE MANAGEMENT SYSTEMS SYLLABUS REGULATION

UNIT I INTRODUCTION TO DBMS
File Systems Organization - Sequential, Pointer, Indexed, Direct - Purpose of Database System- Database System Terminologies-Database characteristics- Data models Types of data models Components of DBMS- Relational Algebra. LOGICAL DATABASE DESIGN: Relational DBMS - Codd's Rule - Entity-Relationship model - Extended ER Normalization Functional Dependencies, Anomaly- 1NF to 5NF- Domain Key Normal Form Denormalization.

UNIT II SQL & QUERY OPTIMIZATION
SQL Standards - Data types - Database Objects- DDL-DML-DCL-TCL-Embedded SQL-Static Vs Dynamic SQL - QUERY OPTIMIZATION: Query Processing and Optimization - Heuristics and Cost Estimates in Query Optimization.

UNIT III TRANSACTION PROCESSING AND CONCURRENCY CONTROL
Introduction-Properties of Transaction- Serializability- Concurrency Control Locking Mechanisms- Two Phase Commit Protocol-Dead lock.

UNIT IV TRENDS IN DATABASE TECHNOLOGY
Overview of Physical Storage Media Magnetic Disks RAID Tertiary storage File Organization Organization of Records in Files Indexing and Hashing Ordered Indices B+ tree Index Files B tree Index Files Static Hashing Dynamic Hashing - Introduction to Distributed Databases- Client server technology- Multidimensional and Parallel databases- Spatial and multimedia databases- Mobile and web databases- Data Warehouse-Mining- Data marts.

UNIT V ADVANCED TOPICS
DATABASE SECURITY: Data Classification-Threats and risks Database access Control Types of Privileges Cryptography- Statistical Databases.- Distributed Databases-Architecture-Transaction Processing-Data Warehousing and Mining-Classification-Association rules-Clustering-Information Retrieval- Relevance ranking-Crawling and Indexing the Web- Object Oriented Databases-XML Databases