Data Base Management Systems

By Dr. J. Indumathi, Professor   |   Anna University, Chennai
Learners enrolled: 5478
This course aims at providing basic understanding of data, data bases, its storage using database structures, its accessing methods, transaction management and recovery procedures.  The objective of this course is to systematically teach the learner ,  Introduction to database, its architecture, procedural language formats and usage, relational data model in detail, query structures, query writing, usage of DML, DDL, TCS queries, query formatting, data base structure creation using normalization, query processing concurrent transaction processing, deadlock handling , storage structures using RAID, data security , distributed databases and recovery methods. 
Course Status : Ongoing
Course Type : Core
Duration : 12 weeks
Start Date : 04 Jul 2022
End Date : 20 Oct 2022
Exam Date :
Enrollment Ends : 15 Sep 2022
Category :
  • Computer Science and Engineering
Credit Points : 4
Level : Undergraduate/Postgraduate

Page Visits

Course layout

Week 1

Introduction to DBMS,
Filed based systems and its issues
Three level architecture
Query processing and transaction management

Week 2

Relational data model 
database design 
Relational integrity 
Referential integrity 
Relational algebra  
Operations in relational algebra

Week 3

Tuple and Domain Relational calculus
ER modelling,
Constraints and cardinality relationships
Extended ER model
Specialization and Generalization
ER and EER model of relational mappings

Week 4

Group by queries
Nested queries Join
Integrity and Constraints, 

Week 5

Database designs, 
Anomalies, Functional Dependency, 
normalization, closure of FD, 
Armstrong algorithms

Week 6

1NF, 2 NF, 3 NF, BCNF and Decomposition

Week 7

Transactions and Recovery, ACID properties, Roll back and Commit, Concurrency execution, Serialisation

Week 8

Precedence graphs, Recoverable Schedule, Concurrency control, Lock and Lock based protocol, 
Deadlock detection, Time stamping, Failures and Recovery, Distributed Recovery, Two Phase Commit

Week 9

Storage structure, file organisation, Recovery and atomicity,
Performance measures of discs, Database management, RAID levels

Week 10

Indices, B+ Tree, Hashing, Bitmap indices

Week 11

Query processing for different queries, sorting and different joins, Query optimizations

Week 12

Database Security, Data mining models and techniques, Distributed Databases, GIS

Books and references

1. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System Concepts”, Fourth Edition, Tata McGraw Hill, 2002. 
2. Ramez Elmasri, Shamkant B. Navathe, “Fundamentals of Database Systems”, FourthEdition ,addision weskey, 2002. 
3. Raghu Ramakrishnan, “Database Management Systems”, Third Edition, McGraw Hill, 2002. 
4. Peter Rob and Corlos Coronel, “Database Systems – Design, Implementation and Management, Fifth Edition, Thompson Learning, Course Technology, 2003. 

Instructor bio

Dr. J. Indumathi, Professor

Anna University, Chennai
She  has  a teaching  and  research  experience  for  more  than  three  decades;  her interdisciplinary, expertise is outstanding, spanning diverse subject areas including the latest cutting-edge technologies. She has a zeal for investigation, research and has innovated and improvised expansively projects which have made a mile stone in the perfection of life style of the human kind. Being a privacy researcher and activist, she has received many awards and accolades from the various organizations, varsities and institutions quantifying to more than 65 awards. She has published more than 200 scientific papers published in reputed publications, 4 granted patents and authored 7 books. Most of her journal publications are indexed in Scopus and Web of Science. She has  delivered  several  technical  invited  talks,  keynote/plenary  speeches  and  has chaired  several  sessions  in  conferences  worldwide. She  is  a  good  integrator, multitasker, and possessing exceptional leadership capability, with proven strength, more visible in the areas of technical expertise, professional expertise, and strategic perspective. She has created an atmosphere of continual improvement and have done everything possible to achieve the goals; get others to go yonder what they initially thought impossible; energize others to take on perplexing goals.

Course certificate

30% for in course Assessment & 70% of end-term Proctored Exam

MHRD logo Swayam logo


Goto google play store