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.
Overview
Syllabus
Week 1
Introduction to DBMS,Filed based systems and its issuesThree level architectureDML and DDLQuery processing and transaction management
Week 2
Relational data modeldatabase designRelational integrityconstraintsReferential integrityRelational algebraOperations in relational algebra
Week 3
Tuple and Domain Relational calculusER modelling,Constraints and cardinality relationshipsExtended ER modelSpecialization and GeneralizationER and EER model of relational mappings
Week 4
Group by queriesNested queries JoinViews,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
Introduction to DBMS,Filed based systems and its issuesThree level architectureDML and DDLQuery processing and transaction management
Week 2
Relational data modeldatabase designRelational integrityconstraintsReferential integrityRelational algebraOperations in relational algebra
Week 3
Tuple and Domain Relational calculusER modelling,Constraints and cardinality relationshipsExtended ER modelSpecialization and GeneralizationER and EER model of relational mappings
Week 4
Group by queriesNested queries JoinViews,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
Taught by
J. Indumathi
