MC7103 DATABASE MANAGEMENT SYSTEMS NOTES ANNA UNIVERSITY

MC7103 DATABASE MANAGEMENT SYSTEMS NOTES FOR ANNA UNIVERSITY

DATABASE MANAGEMENT SYSTEMS MC7103 NOTES FOR ANNA UNIVERSITY

UNIT I INTRODUCTION


File systems versus Database systems
Data Models
DBMS Architecture
Data Independence
Data Modeling using Entity
Relationship Model
Enhanced E-R Modeling

UNIT II RELATIONAL MODEL AND QUERY EVALUATION


Relational Model Concepts
Relational Algebra
SQL
Basic Queries
Complex SQL Queries
Views
Constraints
Relational Calculus
Tuple Relational Calculus
Domain Relational Calculus
overview of commercial RDBMSs
Database Design
Functional Dependencies
Normal Forms
1NF-2NF-3NF-BCNF
4NF-5NF
Algorithms for Executing Query Operations
Cost Estimation

UNIT III TRANSACTION PROCESSING


Transaction Processing
Properties of Transactions
Serializability
Transaction support in SQL
Locking Techniques
Time Stamp ordering
Validation Techniques
Granularity of Data Items
Recovery concepts
Shadow paging
Log Based Recovery
Database Security Issues
Access control
Statistical Database Security

UNIT IV FILES AND INDEXING


File operations
Hashing Techniques
Indexing
Single level and Multi-level Indexes
B+ tree
Static Hashing
Indexes on Multiple Keys

UNIT V SPECIAL PURPOSE DATABASES


OODBMS
Object-Based Databases
OO Data Model
OO Languages
Persistence
Object Relational Databases
XML
Structure of XML
Temporal Databases
Mobile Databases
Spatial Databases
Case Study for Design and Manage the Database for any Project

Download DBMS Notes