X

Data Base Management Systems

By Dr. K. Arul Deepa, Assistant Professor, Dr.K.Arul Deepa & Dr.P.Velvizhy, Asst. Professor Dept. of IST, Anna University, CEG, Chennai   |   Anna University, Chennai, Anna University
Learners enrolled: 4151
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 : Upcoming
Course Type : Core
Duration : 12 weeks
Start Date : 23 Jan 2023
End Date : 30 Apr 2023
Exam Date : 15 May 2023 IST
Enrollment Ends : 28 Feb 2023
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
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. K. Arul Deepa, Assistant Professor

Anna University, Chennai
Dr. K. Arul Deepa, Assistant Professor of Department of Information Science and Technology, College of Engineering Guindy, Anna University,Chennai.She has around 16 years of teaching experience and some periods of industry experience. Her research area includes Natural Language Processing, Machine Learning, Data Mining, Computer Forensics and particularly she shows special interest in Tamil Computing. She is also interested in translating Technical subjects to Tamil language. She has participated in Administrative activities and shows her enthusiastic participation's in research activities in guiding scholars and publishing articles in many reputed journals consistently.


Course Coordinator - I

Dr. K. Arul Deepa, Assistant Professor of Department of Information Science and Technology, College of Engineering Guindy, Anna University,Chennai.She has around 16 years of teaching experience and some periods of industry experience. Her research area includes Natural Language Processing, Machine Learning, Data Mining, Computer Forensics and particularly she shows special interest in Tamil Computing. She is also interested in translating Technical subjects to Tamil language. She has participated in Administrative activities and shows her enthusiastic participation's in research activities in guiding scholars and publishing articles in many reputed journals consistently.

Course Coordinator - II

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 Data Mining, Recommendation Systems, Object Oriented Software Systems and Image Processing. She is involved in translating technical subjects from English language to Tamil language. She also participates in Administrative activities and shows her enthusiastic participation's in research activities in guiding scholars.


Course certificate

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


MHRD logo Swayam logo

DOWNLOAD APP

Goto google play store

FOLLOW US