Database management system
Introduction to Database Management System
Relational Model
Storage and File organization
QBE
SQL
Concurrency Control
Recovery System
Distributed Databases
Parallel Databases
- Overview of Database Management Systems
- Database Systems versus File Systems
- History of Database Systems
- View of Data
- Extending Database Capabilities
- Types of Databases and Database Applications
- Advantages of Database Systems
- Functions of a DBMS
- Role of the Database Administrator
- Database Users
- Data Models
- Components of Database Management system
- Transaction
- Database Management System Languages
- The two tier architecture
- Three-layer architecture
- Entity-Relationship Model
- Database design and ER Diagrams
- Entity Types, Attributes and Keys
- Relationships and Relationship sets
- Types of Entity
- Constraints
- Keys
- Entity-Relationship Diagram
- Hierarchical Data Model
- Network Data Model
- Design Issues
- Extended E-R Features
- Alternative E-R Notations
- The Unified Modeling Language
- Relational Model Terminology
- Mathematical Definition of Relation
- Database Relations
- Structure of Relational Databases
- Database Schema
- Keys
- Schema Diagram
- The Relational Algebra
- Composition of Relational Operations
- The Union Operation
- The Set Difference Operation
- The Rename Operation
- Formal Definition of the Relational Algebra
- Additional Operations
- Extended Relational-Algebra Operations
- Outer Join
- Null Values
- Modification of the Database
- Views
- Query-by-Example
- Queries on One Relation
- Queries on Several Relations
- The Condition Box
- The Result Relation
- Ordering of the Display of Tuples
- Aggregate Operations
- Normalization
- Functional Dependency
- The Process of Normalization
- First Normal Form (1NF)
- Boyce.Codd Normal Form (BCNF)
- Fourth Normal Form (4NF)
- Fifth Normal Form (5NF)
- Algorithm for Functional Dependencies
- Objectives of SQL
- History of SQL
- Importance of SQL
- SQL Statement
- Use of DISTINCT
- Search Condition
- Pattern Matching
- NULL Search Condition
- SELECT Statement
- SELECT Statement - Grouping
- Subqueries
- Join
- Integrity Enhancement Feature
- Data Definition
- View
- Transactions
- Data-Definition Language
- Schema Definition in SQL
- Dynamic SQL
- Lock-Based Protocols
- Granting of Locks
- Two-Phase Locking Protocol
- Implementation of Locking
- Graph-Based Protocols
- Timestamp-Based Protocols
- Validation-Based Protocols
- Deadlock Handling
- Timeout-Based Schemes for Deadlock Prevention
- Deadlock Detection
- Recovery from Deadlock
- Need for Concurrency Control
- Schedule
- Timestamping
- Optimistic Techniques
- Granularity of Data Items
- Database Recovery
- Checkpoint
- Recovery Techniques
- Failure Classification
- Storage Types
- Data Access
- Log-Based Recovery
- Deferred Database Modification
- Immediate Database Modification
- Checkpoints
- Shadow Paging
- Recovery with Concurrent Transactions
- Buffer Management
- Failure with Loss of Nonvolatile Storage
- ARIES
- Data Structures
- Recovery Algorithm of ARIES
- key features of ARIES
- Remote Backup Systems