Database Management Systems (DMBS) (Copy)
Cheat Sheet: A Level Computer Science – DBMS Features & Tools
1. Features of a Database Management System (DBMS)
A DBMS is software that manages databases and provides tools to ensure data is accurate, secure, and efficiently accessible.
How DBMS Overcomes File-Based Limitations
| Feature | Explanation |
|---|---|
| Data Management | Centralised control of data storage, retrieval, and update operations |
| Data Dictionary | A metadata repository that stores structure, types, and constraints for all database elements |
| Data Modelling | Supports design through ER diagrams, entity and relationship definitions |
| Logical Schema | Describes the database structure in logical terms (e.g., tables, fields, keys) independent of physical storage |
| Data Integrity | Enforces rules (e.g., primary key uniqueness, referential integrity) to prevent invalid or inconsistent data |
| Data Security | Protects data using access rights, user authentication, and encryption |
| Backup and Recovery | Provides tools to automatically back up data and restore it in case of loss or corruption |
| Concurrency Control | Prevents data corruption when multiple users access the database simultaneously |
| Redundancy Reduction | Through normalization and centralized design, avoids duplicate data storage |
2. DBMS Security Tools
| Security Feature | Purpose |
|---|---|
| Access Rights | Grant/restrict access to data and operations (e.g., read-only, edit, delete) based on user roles |
| User Authentication | Verifies user identity using login credentials |
| Audit Trails | Tracks who accessed or modified which data and when |
| Encryption | Secures sensitive data during storage and transmission |
| Backups | Regular snapshots to recover data in case of failure or cyberattack |
3. Software Tools Within a DBMS
| Tool | Purpose |
|---|---|
| Developer Interface | Environment for designing, editing, and testing database structures and queries (e.g., SQL editor, schema designer) |
| Query Processor | Interprets and executes user queries (usually in SQL), optimizes performance by choosing efficient execution plans |
| Form Designer | Helps create graphical interfaces for data input (used in front-end apps) |
| Report Generator | Allows creation of structured, formatted outputs of database data |
| Transaction Manager | Ensures atomicity, consistency, isolation, and durability (ACID properties) in database operations |
| Integrity Checker | Automatically applies validation rules like data types, constraints, foreign key relationships |
| Import/Export Utility | Transfers data between the DBMS and other formats (CSV, Excel, XML, JSON) |
4. Summary of DBMS Advantages Over File-Based Systems
| Issue in File-Based Systems | DBMS Solution |
|---|---|
| Data inconsistency | Centralized control & normalization |
| Lack of integrity enforcement | Built-in integrity constraints |
| Poor scalability | Concurrent multi-user support |
| Weak security | Access control, encryption, auditing |
| Manual backup | Automated backup & recovery tools |
| Limited querying | Powerful query languages (SQL) |