Database Management Systems
100 live DBMS simulations - architecture, ER modeling, normalization, constraints, views, transactions and concurrency control.
100 simulators found.
What is a Database?
What is a Database? - live DBMS simulation (Database System Concepts & Architecture).
File System vs DBMS
File System vs DBMS - live DBMS simulation (Database System Concepts & Architecture).
DBMS Components
DBMS Components - live DBMS simulation (Database System Concepts & Architecture).
Data Model — Meaning
Data Model — Meaning - live DBMS simulation (Database System Concepts & Architecture).
Hierarchical Model
Hierarchical Model - live DBMS simulation (Database System Concepts & Architecture).
Network Model
Network Model - live DBMS simulation (Database System Concepts & Architecture).
Relational Model
Relational Model - live DBMS simulation (Database System Concepts & Architecture).
Object-Oriented Model
Object-Oriented Model - live DBMS simulation (Database System Concepts & Architecture).
Schema vs Instance
Schema vs Instance - live DBMS simulation (Database System Concepts & Architecture).
Database Schema Types
Database Schema Types - live DBMS simulation (Database System Concepts & Architecture).
Three-Schema Architecture
Three-Schema Architecture - live DBMS simulation (Database System Concepts & Architecture).
External Level — User Views
External Level — User Views - live DBMS simulation (Database System Concepts & Architecture).
Conceptual Level
Conceptual Level - live DBMS simulation (Database System Concepts & Architecture).
Internal Level
Internal Level - live DBMS simulation (Database System Concepts & Architecture).
Data Independence
Data Independence - live DBMS simulation (Database System Concepts & Architecture).
Logical Data Independence
Logical Data Independence - live DBMS simulation (Database System Concepts & Architecture).
Physical Data Independence
Physical Data Independence - live DBMS simulation (Database System Concepts & Architecture).
Database Languages — DDL, DML, DCL, TCL
Database Languages — DDL, DML, DCL, TCL - live DBMS simulation (Database System Concepts & Architecture).
DBMS Interfaces
DBMS Interfaces - live DBMS simulation (Database System Concepts & Architecture).
Centralized vs Client-Server DBMS
Centralized vs Client-Server DBMS - live DBMS simulation (Database System Concepts & Architecture).
Data Modeling — Introduction
Data Modeling — Introduction - live DBMS simulation (Data Modeling).
Entity — Meaning
Entity — Meaning - live DBMS simulation (Data Modeling).
Attribute — Meaning
Attribute — Meaning - live DBMS simulation (Data Modeling).
Entity Set
Entity Set - live DBMS simulation (Data Modeling).
Relationship — Meaning
Relationship — Meaning - live DBMS simulation (Data Modeling).
Relationship Set
Relationship Set - live DBMS simulation (Data Modeling).
ER Diagram Symbols
ER Diagram Symbols - live DBMS simulation (Data Modeling).
Strong Entity
Strong Entity - live DBMS simulation (Data Modeling).
Weak Entity
Weak Entity - live DBMS simulation (Data Modeling).
Key Attribute in ER
Key Attribute in ER - live DBMS simulation (Data Modeling).
Composite Attribute
Composite Attribute - live DBMS simulation (Data Modeling).
Multivalued Attribute
Multivalued Attribute - live DBMS simulation (Data Modeling).
Derived Attribute
Derived Attribute - live DBMS simulation (Data Modeling).
One-to-One Relationship
One-to-One Relationship - live DBMS simulation (Data Modeling).
One-to-Many Relationship
One-to-Many Relationship - live DBMS simulation (Data Modeling).
Many-to-Many Relationship
Many-to-Many Relationship - live DBMS simulation (Data Modeling).
Participation Constraint
Participation Constraint - live DBMS simulation (Data Modeling).
Cardinality Ratios — 1:1, 1:N, M:N
Cardinality Ratios — 1:1, 1:N, M:N - live DBMS simulation (Data Modeling).
ER to Relational Mapping
ER to Relational Mapping - live DBMS simulation (Data Modeling).
Relational Model Basics
Relational Model Basics - live DBMS simulation (Data Modeling).
Relational Database Schema
Relational Database Schema - live DBMS simulation (Data Modeling).
Relational Algebra — Selection σ
Relational Algebra — Selection σ - live DBMS simulation (Data Modeling).
Relational Algebra — Projection π
Relational Algebra — Projection π - live DBMS simulation (Data Modeling).
Relational Algebra — Join ⋈
Relational Algebra — Join ⋈ - live DBMS simulation (Data Modeling).
Codd's Rules
Codd's Rules - live DBMS simulation (Data Modeling).
Normalization — Meaning
Normalization — Meaning - live DBMS simulation (Normalization).
Redundancy Problem
Redundancy Problem - live DBMS simulation (Normalization).
Insertion Anomaly
Insertion Anomaly - live DBMS simulation (Normalization).
Deletion Anomaly
Deletion Anomaly - live DBMS simulation (Normalization).
Update Anomaly
Update Anomaly - live DBMS simulation (Normalization).
Functional Dependency
Functional Dependency - live DBMS simulation (Normalization).
Full Functional Dependency
Full Functional Dependency - live DBMS simulation (Normalization).
Partial Dependency
Partial Dependency - live DBMS simulation (Normalization).
Transitive Dependency
Transitive Dependency - live DBMS simulation (Normalization).
Finding Candidate Keys
Finding Candidate Keys - live DBMS simulation (Normalization).
Super Key vs Candidate Key
Super Key vs Candidate Key - live DBMS simulation (Normalization).
Prime and Non-Prime Attributes
Prime and Non-Prime Attributes - live DBMS simulation (Normalization).
First Normal Form (1NF)
First Normal Form (1NF) - live DBMS simulation (Normalization).
Second Normal Form (2NF)
Second Normal Form (2NF) - live DBMS simulation (Normalization).
Third Normal Form (3NF)
Third Normal Form (3NF) - live DBMS simulation (Normalization).
BCNF — Boyce-Codd Normal Form
BCNF — Boyce-Codd Normal Form - live DBMS simulation (Normalization).
Decomposition
Decomposition - live DBMS simulation (Normalization).
Lossless Join Decomposition
Lossless Join Decomposition - live DBMS simulation (Normalization).
Dependency Preservation
Dependency Preservation - live DBMS simulation (Normalization).
Query Processing Steps
Query Processing Steps - live DBMS simulation (Normalization).
Query Optimization
Query Optimization - live DBMS simulation (Normalization).
Transaction Processing — Intro
Transaction Processing — Intro - live DBMS simulation (Normalization).
Concurrency Control — Intro
Concurrency Control — Intro - live DBMS simulation (Normalization).
Database Recovery — Intro
Database Recovery — Intro - live DBMS simulation (Normalization).
Object & Object-Relational Databases
Object & Object-Relational Databases - live DBMS simulation (Normalization).
Constraint — Meaning
Constraint — Meaning - live DBMS simulation (Constraints & Views).
Domain Constraint
Domain Constraint - live DBMS simulation (Constraints & Views).
Key Constraint
Key Constraint - live DBMS simulation (Constraints & Views).
Entity Integrity
Entity Integrity - live DBMS simulation (Constraints & Views).
Referential Integrity
Referential Integrity - live DBMS simulation (Constraints & Views).
NOT NULL Constraint
NOT NULL Constraint - live DBMS simulation (Constraints & Views).
UNIQUE Constraint
UNIQUE Constraint - live DBMS simulation (Constraints & Views).
CHECK Constraint
CHECK Constraint - live DBMS simulation (Constraints & Views).
DEFAULT Constraint
DEFAULT Constraint - live DBMS simulation (Constraints & Views).
Foreign Key Constraint
Foreign Key Constraint - live DBMS simulation (Constraints & Views).
Cascading Delete
Cascading Delete - live DBMS simulation (Constraints & Views).
View — Meaning
View — Meaning - live DBMS simulation (Constraints & Views).
Creating Views
Creating Views - live DBMS simulation (Constraints & Views).
Updating Views
Updating Views - live DBMS simulation (Constraints & Views).
Table vs View — Comparison
Table vs View — Comparison - live DBMS simulation (Constraints & Views).
Transaction — Meaning
Transaction — Meaning - live DBMS simulation (Transactions & Concurrency Control).
ACID Properties
ACID Properties - live DBMS simulation (Transactions & Concurrency Control).
Atomicity
Atomicity - live DBMS simulation (Transactions & Concurrency Control).
Consistency
Consistency - live DBMS simulation (Transactions & Concurrency Control).
Isolation
Isolation - live DBMS simulation (Transactions & Concurrency Control).
Durability
Durability - live DBMS simulation (Transactions & Concurrency Control).
Transaction States
Transaction States - live DBMS simulation (Transactions & Concurrency Control).
Schedule — Meaning
Schedule — Meaning - live DBMS simulation (Transactions & Concurrency Control).
Serial Schedule
Serial Schedule - live DBMS simulation (Transactions & Concurrency Control).
Concurrent Schedule
Concurrent Schedule - live DBMS simulation (Transactions & Concurrency Control).
Conflict Serializability
Conflict Serializability - live DBMS simulation (Transactions & Concurrency Control).
Lock-Based Protocol
Lock-Based Protocol - live DBMS simulation (Transactions & Concurrency Control).
Two-Phase Locking (2PL)
Two-Phase Locking (2PL) - live DBMS simulation (Transactions & Concurrency Control).
Deadlock in DBMS
Deadlock in DBMS - live DBMS simulation (Transactions & Concurrency Control).
Timestamp, Optimistic & Recovery
Timestamp, Optimistic & Recovery - live DBMS simulation (Transactions & Concurrency Control).