Data Base Management Systems

By Dr.E. Shanmuga Priya & Dr. P. Velvizhy, Assistant Professor (SG) | College of Engineering Guindy, Anna University,Chennai

Learners enrolled: 7875

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.

Summary

Course Status :	Ongoing
Course Type :	Core
Duration :	12 weeks
Category :	Computer Science and Engineering
Credit Points :	4
Level :	Undergraduate/Postgraduate
Start Date :	22 Jan 2024
End Date :	30 Apr 2024
Enrollment Ends :	29 Feb 2024
Exam Date :	19 May 2024 IST
Shift :	Shift - I

Note: This exam date is subjected to change based on seat availability. You can check final exam date on your hall ticket.

Page Visits

Course layout

Week 1

Introduction to DBMS,

Filed based systems and its issues

Three level architecture

DML and DDL

Query processing and transaction management

Week 2

Relational data model

database design

Relational integrity

constraints

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

Views,

Integrity and Constraints,

Assertion,Triggers

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.E. Shanmuga Priya & Dr. P. Velvizhy, Assistant Professor (SG)

College of Engineering Guindy, Anna University,Chennai

Dr.E. Shanmuga Priya is currently an Assistant Professor in the department of Computer Science and Engineering , College of Engineering , Anna University , Chennai. Dr.E. ShanmugaPriya received her undergraduate degree (B.E – Computer Science and Engineering) from Madurai Kamaraj University and Post Graduate Degree (M.E – Computer Science and Engineering) from Anna University , Chennai as well as MBA degree from Mother Teresa Women’s University , Kodaikanal and her PhD in Information and Communication Engineering, Anna University - Chennai. Dr.E.ShanmugaPriya published a number of papers in preferred Journals and chapters in books, and participated in various national and international conferences and presented research based papers. Her research activities are currently twofold: while the first research activity is to explore the challenges in Big Data Security and Privacy;the second major research theme that she is currently exploring in the field of Health care domain.

P. Velvizhy has completed her Ph.D. degree in Information and Communication Engineering from Anna University. She is currently working as an Assistant Professor in the Department of Computer Science and Engineering, College of Engineering Guindy, Anna University, Chennai. She has around 14 years of teaching experience. She has around 20 publications in various International Journals and Conferences.

Her research area includes Machine Learning, Data Mining, Recommendation Systems, Databases, Object OrientedSoftware Systems and Image Processing.