CS8492 DMS Syllabus
Anna University Regulation 2017 IT CS8492 DMS Syllabus for all 5 units are provided below. Download link for IT 4th SEM CS8492 DATABASE MANAGEMENT SYSTEMS Engineering Syllabus is listed down for students to make perfect utilization and score maximum marks with our study materials.
[wp_ad_DMSmp_2]
Anna University Regulation 2017 Information Technology Engineering(IT) 4th SEM CS8492 DMS-DATABASE MANAGEMENT SYSTEMS Engineering Syllabus
CS8492 DATABASE MANAGEMENT SYSTEMS
OBJECTIVES
To learn the fundamentals of data models and to represent a database system using ER
diagrams.
To study SQL and relational database design.
To understand the internal storage structures using different file and indexing
techniques which will help in physical DB design.
To understand the fundamental concepts of transaction processing- concurrency
control techniques and recovery procedures.
To have an introductory knowledge about the Storage and Query processing
Techniques
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
[wp_ad_DMSmp_1]
To Download Syllabus – Click here
If you require any other notes/study materials, you can comment in the below section.
Related Links
For CS8492 DMS Previous Year Question Papers – Click here
For CS8492 DMS Question Bank/2marks 16marks with answers – Click here
For CS8492 DMS Important Questions/Answer Key – Click here
For CS8492 DMS Lecture Handwritten Notes – Click here
Search Terms
CS8492 DMS Syllabus
Anna University 4th Sem IT DMS Syllabus
CS8492 DATABASE MANAGEMENT SYSTEMS Engineering Syllabus free download
Anna University IT DMS Syllabus Regulation 2017
CS8492 Syllabus, DMS Unit wise Syllabus – IT 4th Semester