#1
12th April 2015, 10:04 AM
| |||
| |||
Anna University Chennai DBMS Syllabus
Can any one please provide me the syllabus and notes of Database Management Systems offered at Anna University Chennai? As my exams are near and now want to start my preparation so I need this very urgently? If you provide me than it will be helpful for me
|
#2
14th August 2018, 03:31 PM
| |||
| |||
Re: Anna University Chennai DBMS Syllabus
Hi buddy here I am looking for Anna University CS6302 Database Management Systems paper syllabus so would you plz let me know from where I can do download it ??
|
#3
14th August 2018, 03:32 PM
| |||
| |||
Re: Anna University Chennai DBMS Syllabus
As you want here I am giving bellow Anna University CS6302 Database Management Systems paper syllabus on your demand Anna University CS6302 Database Management Systems paper syllabus on your demand: 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 |