DBMS in Simple Steps

Visit Tutorial Page ( Report)

Database Management System or DBMS in short refers to the technology of storing and retrieving users’ data with utmost efficiency along with appropriate security measures. This tutorial explains different aspects of DBMS such as its architecture, data models, data schemas, data independence, E-R model, relation model, relational database design, functional dependencies, normalization, transaction management, concurrency control, recovery, reliability and storage and file structure and much more.

  • DBMS for Semester
    • DBMS For Semester - Home
    • DBMS - Introduction To Distributed Database
    • DBMS - Distributed Database System
    • DBMS - Advantages Of Distributed Database System
    • DBMS - Features Of Distributed Database System
    • DBMS - Option For Distributing Database
    • DBMS - Query Processing In Distributed Database
  • Database Design with E-R Model
    • DBMS - Entity And Entity Set
    • DBMS - Attribute And Domain
    • DBMS - Keys Super, Candidate, Primary, Alternate
    • DBMS - Keys Foreign, Partial, Secondary
    • DBMS - Keys Unique, Surrogate, Composite
    • DBMS - Mapping Cardinalities
    • DBMS - Relationship And Relationship Sets
    • DBMS - Entity Relationship Diagram
    • DBMS - Symbols In ER-Diagram
    • DBMS - Mapping Cardinalities In ER-Diagram
    • DBMS - ER-Diagram With Role-Indicators
    • DBMS - ER-Diagram With Ternary Relationship
    • DBMS - Weak Entity Set With Total Participation
    • DBMS - Specialization And Generalization
    • DBMS - ER-Diagram With Aggregation
    • DBMS - ER-Diagram With Existence Dependency
    • DBMS - Forming Schemas From ER-Diagram
    • DBMS - Case Study On Banking System
    • DBMS - Question Solve On ER-Diagram - 1
    • DBMS - Question Solve On ER-Diagram -2
    • DBMS - Question Solve On ER-Diagram - 3
    • DBMS - Question Solve On ER-Diagram - 4
  • Formal Relational Query Languages
    • DBMS - Introduction To Relational Calculus
    • DBMS - Tuple Relational Calculus
    • DBMS - Tuple Relational Calculus Query Example-1
    • DBMS - Tuple Relational Calculus Query Example-2
    • DBMS - Domain Relational Calculus Query Example-1
    • DBMS - Domain Relational Calculus Query Example-2
    • DBMS - Safety Of Expressions Of Domain And Tuple Relational Calculus
    • DBMS - Formal Definition Of Domain Relational Calculus
    • DBMS - Select Operation In Relational Algebra
    • DBMS - Project Operation In Relational Algebra
    • DBMS - Union Operation In Relational Algebra
    • DBMS - Set-Difference Operation In Relational Algebra
    • DBMS - Set Intersection Operation In Relational Algebra
    • DBMS - Cartesian Product Operation In Relational Algebra
    • DBMS - Rename Operation In Relational Algebra
    • DBMS - Join Operation In Relational Algebra
    • DBMS - Division Operation In Relational Algebra
    • DBMS - Assignment Operation In Relational Algebra
    • DBMS - Aggregate Function In Relational Algebra
    • DBMS - Deletion Operation On Database Using Relational Algebra
    • DBMS - Insert Operation On Database Using Relational Algebra
    • DBMS - Update Operation On Database Using Relational Algebra
    • DBMS - View Using Relational Algebra
    • DBMS - Question Solve On Relational Algebra -1
    • DBMS - Question Solve On Relational Algebra - 2
    • DBMS - Question Solve On Relational Algebra - 3
  • Functional Dependencies and Normalization
    • DBMS - Functional Dependencies (FDs)
    • DBMS - Introduction To Normalization Of Database
    • DBMS - Rules Of Functional Dependency (FD)
    • DBMS - First Normal Form (INF)
    • DBMS - Second Normal Form (2NF)
    • DBMS - Third Normal Form (3NF)
    • DBMS - Fourth Normal Form 4NF
    • DBMS - Fifth Normal Form (5NF)
    • DBMS - Domain Key Normal Form (DKNF) And Sixth Normal Form (6NF)
    • DBMS - Closure On Attribute Sets
    • DBMS - Canonical Cover Of FDs
    • DBMS - 3NF Algorithm
    • DBMS - 3NF Algorithm Problem Solve -1
    • DBMS - 3NF Algorithm Problem Solve-2
    • DBMS - Algorithm To Check Whether A Decomposition Is Lossless
    • DBMS - Problem-1 To Check Whether A Decomposition Is Lossless
    • DBMS - Problem-2 To Check Whether A Decomposition Is Lossless
    • DBMS - Question Solve On Normalization - 1
    • DBMS - Question Solve On Normalization -2
    • DBMS - Question Solve On Normalization - 3
    • DBMS - Question Solve On Normalization - 4
    • DBMS - Question Solve On Normalization - 5
    • DBMS - Question Solve On Functional Dependency
    • DBMS - Question Solve On Referential Integrity
  • Physical Data Organization
    • DBMS - Disk Management
    • DBMS - Pages And Blocks
    • DBMS - IO Time To Access A Page
    • DBMS - Heap Files
    • DBMS - Index And Index Structure
    • DBMS - Sorted Files
    • DBMS - Storage Structure
    • DBMS - Clustered Index
    • DBMS - Unclustered Structure
    • DBMS - Problem On Cost Of Range Search
    • DBMS - Sparse Vs. Dense Index
    • DBMS - Two Level Index
    • DBMS - Multi Level Index
    • DBMS - Index Sequential Access Method (ISAM)
    • DBMS - B-Tree: Definition And Properties
    • B-Tree: An Example
    • DBMS - B+ Tree
    • DBMS - Insertion And Deletion Of B+ Tree
    • DBMS - Hash Index
    • DBMS - Choosing A Hash Function
    • DBMS - Problems Of Hash Addresses
    • DBMS - Extendable Hashing
    • DBMS - Question Solve On B Tree
    • DBMS - Question Solve On B+ Tree - 1
    • DBMS - Question Solve On B+ Tree - 2
    • DBMS - Question Solve On B+ Tree - 3
  • Query Processing and Optimization
    • DBMS - Introduction To Query Processing
    • DBMS - Introduction To Query Processing - Example
    • DBMS - Structure Of A Query Processor
    • DBMS - Query Processing – Case Study
    • DBMS - Query Processing – Case Study – Strategy No-1
    • DBMS - Query Processing – Case Study – Strategy No-2
    • DBMS - Query Processing – Case Study – Strategy No-3
    • DBMS - Query Representation Using Operator Graph
    • DBMS - General Query Processing Strategies
    • DBMS - Dynamic Versus Static Query Optimization
  • Transaction Processing and Concurrency Control
    • DBMS - Definition Of Transaction
    • DBMS - State Transition Of A Transaction
    • DBMS - ACID Properties Of A Transaction
    • DBMS - Architecture Of A Database Transaction
    • DBMS - Serializability And Recoverability
    • DBMS - Testing Of Serializability
    • DBMS - Concurrency Control
    • DBMS - Concurrency Control – Lost Update Problem
    • DBMS - Concurrency Control – Uncommitted Dependency Problem
    • DBMS - Concurrency Control – Inconsistent Analysis Problem
    • DBMS - Locking Methods
    • DBMS - Two Phase Locking
    • DBMS - Preventing Lost Update Problem Using 2PL
    • DBMS - Preventing Uncommitted Dependency Problem Using 2PL
    • DBMS - Preventing Inconsistent Analysis Problem Using 2PL
    • DBMS - Cascading Rollback Problem Using 2PL
    • DBMS - Granularity Of Data Items
    • DBMS - Non-Repeatable (Or Fuzzy) Read
    • DBMS - Phantom Read And Phantom Tuple
    • DBMS - Latches
    • DBMS - Deadlock And Livelock
    • DBMS - Time Stamping Methods
    • DBMS - Thomas’s Write Rule
    • DBMS - Thomas’s Write Rule – Example
    • DBMS - Optimistic Techniques
  • Recovery and Reliability
    • DBMS - Reliable And Reliability
    • DBMS - Failure, Error And Fault
    • DBMS - Types Of Failure
    • DBMS - Audit Trails
    • DBMS - Recovery Schemes
    • DBMS - Recovery In A Centralized DBMS
    • DBMS - Logs
    • DBMS - Checkpoints
    • DBMS - Archival Database And Implementation Of Storage
    • DBMS - Do, Undo, Redo
    • DBMS - Reflecting Updates To The Database And Recovery
    • DBMS - Save Point
    • DBMS - Sagas
Write Your Review

Reviews