EC8392 Digital Electronics Lecture Notes Syllabus Book Previous 2 13 15 Marks Anna University Important Question Bank With Answers Regulation 2017 Study Materials Pdf Ppt

EC8392 Digital Electronics Lecture Notes Syllabus Book Previous  2 13 15 Marks  Anna University Important  Question Bank With Answers Regulation 2017 Study Materials Pdf Ppt

CS8492 DATABASE MANAGEMENT SYSTEMS 

UNIT I RELATIONAL DATABASES 

Purpose of Database System – Views of data – Data Models – Database System Architecture – Introduction to relational databases – Relational Model – Keys – Relational Algebra – SQL fundamentals – Advanced SQL features – Embedded SQL– Dynamic SQL   

UNIT II DATABASE DESIGN 

Entity-Relationship model – E-R Diagrams – Enhanced-ER Model – ER-to-Relational Mapping – Functional Dependencies – Non-loss Decomposition – 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 III TRANSACTIONS 

Transaction Concepts – ACID Properties – Schedules – Serializability – Concurrency Control – Need for Concurrency – Locking Protocols – Two Phase Locking – Deadlock – Transaction Recovery - Save Points – Isolation Levels – SQL Facilities for Concurrency and Recovery.

UNIT IV IMPLEMENTATION TECHNIQUES 

RAID – File Organization – Organization of Records in Files – Indexing and Hashing –Ordered Indices – B+ tree Index Files – B tree Index Files – Static Hashing – Dynamic Hashing – Query Processing Overview – Algorithms for SELECT and JOIN operations – Query optimization using

Heuristics and Cost Estimation.

UNIT V ADVANCED TOPICS 

Distributed Databases: Architecture, Data Storage, Transaction Processing – Object-based Databases: Object Database Concepts, Object-Relational features, ODMG Object Model, ODL, OQL - XML Databases: XML Hierarchical Model, DTD, XML Schema, XQuery – Information Retrieval: IR Concepts, Retrieval Models, Queries in IR systems.

TEXT BOOKS:

1. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System  Concepts”,Sixth Edition, Tata McGraw Hill, 2011.

2. Ramez Elmasri, Shamkant B. Navathe, “Fundamentals of Database Systems”, Sixth Edition, 

 Pearson Education, 2011.

REFERENCES:

1. C. J. Date, A.Kannan, S.Swamynathan, “An Introduction to Database Systems”, Eighth Edition,

 Pearson Education, 2006.

2. Raghu Ramakrishnan, ―Database Management Systems‖, Fourth Edition, McGraw-Hill  College Publications, 2015.

3. G.K.Gupta, "Database Management Systems”, Tata McGraw Hill, 2011.


EC8392 Digital Electronics Lecture Notes Syllabus Book Previous  2 13 15 Marks  Anna University Important  Question Bank With Answers Regulation 2017 Study Materials Pdf Ppt