#1
11th April 2016, 04:46 PM
| |||
| |||
Database Management System Syllabus Anna University
Hello buddy I am seeking the Cs6302Database Management System Syllabus through Anna University so can you please make available the Syllabus for me ??
|
#2
11th April 2016, 04:48 PM
| |||
| |||
Re: Database Management System Syllabus Anna University
Here is the 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 Contact address- Department of Media Sciences, College of Engineering Guindy, Anna University, Chennai 600 025. Phone : 91-44-2235 1579 Telefax: 044-22351578 |
|