Database Management Systems syllabus

UNIT I INTRODUCTION TO DBMS 
File Systems Organization – Sequential, Pointer, Indexed, DirectPurpose of Database System– Database System Terminologies-Database characteristics- Data models – Types of data models – Components of DBMSRelational Algebra. LOGICAL DATABASE DESIGN :Relational DBMS – Codd’s RuleEntity-Relationship modelExtended ER NormalizationFunctional Dependencies, Anomaly- 1NF to 5NFDomain Key Normal FormDenormalization

UNIT II SQL & QUERY OPTIMIZATION 
SQL StandardsData typesDatabase ObjectsDDL-DML-DCL-TCLEmbedded SQL-Static Vs
Dynamic SQL – QUERY OPTIMIZATION: Query Processing and OptimizationHeuristics and Cost Estimates in Query Optimization.

UNIT III TRANSACTION PROCESSING AND CONCURRENCY CONTROL
Introduction-Properties of TransactionSerializabilityConcurrency Control Locking Mechanisms– Two Phase Commit ProtocolDead 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 FilesStatic HashingDynamic Hashing – Introduction to Distributed Databases- Client server technology– Multidimensional and Parallel databases- Spatial and multimedia databases– Mobile and web databases- Data WarehouseMining– Data marts.

UNIT V ADVANCED TOPICS 
DATABASE SECURITY: Data Classification-Threats and risksDatabase access ControlTypes of Privileges –Cryptography- Statistical DatabasesDistributed Databases-Architecture-Transaction ProcessingData Warehousing and Mining-Classification-Association rules-Clustering-Information Retrieval– Relevance ranking-Crawling and Indexing the WebObject Oriented DatabasesXML Databases.

MA6351 Transforms and Partial Differential Equations 
CS6301 Programming and Data Structure 2
CS6302 Database Management Systems
CS6303 Computer Architecture
CS6304 Analog and Digital Communication
GE6351 Environmental Science and Engineering

For further syllabus, notes, video materials and question papers visit kprblog.in

Mail your Feedback/Queries to [email protected]