Complete DBMS Quick Revision Notes
GATE · Rajasthan Computer Teacher · BCI · NIELIT · UGC NET · SSC · Technical Interviews
What is DBMS?
A Database Management System (DBMS) is software that allows users to create, store, retrieve, update, and manage data efficiently while ensuring security, consistency, and integrity.
Popular DBMS Software
- MySQL
- Oracle Database
- Microsoft SQL Server
- PostgreSQL
- SQLite
- IBM Db2
- MariaDB
Characteristics of DBMS
- Organized data storage
- Reduced data redundancy
- Improved consistency
- Multi-user access
- Security and authorization
- Backup and recovery
- Data independence
- Integrity enforcement
- Efficient query processing
Advantages of DBMS
- Eliminates duplicate data
- Improves data sharing
- Maintains data accuracy
- Supports concurrent users
- Centralized control
- Better security
- Faster data retrieval
- Backup and recovery support
- Easier maintenance
Disadvantages of DBMS
- High installation cost
- Complex administration
- Hardware requirements
- Performance overhead for small applications
- Requires skilled database administrators
File System vs DBMS
| File System | DBMS |
|---|---|
| Data redundancy is high | Redundancy is minimized |
| Security is limited | Strong security features |
| Backup is difficult | Built-in backup and recovery |
| No concurrency control | Supports concurrent users |
| Poor data consistency | High consistency |
Database Languages
DDL (Data Definition Language)
Defines database structure.
Commands: CREATE, ALTER, DROP, TRUNCATE, RENAME
DML (Data Manipulation Language)
Manipulates data.
Commands: INSERT, UPDATE, DELETE
DQL (Data Query Language)
Retrieves data.
Command: SELECT
DCL (Data Control Language)
Controls permissions.
Commands: GRANT, REVOKE
TCL (Transaction Control Language)
Controls transactions.
Commands: COMMIT, ROLLBACK, SAVEPOINT
Three Levels of Data Abstraction
Physical Level
Describes how data is physically stored on storage devices.
Logical Level
Describes what data is stored and the relationships among data.
View Level
Shows only the required portion of the database to users.
Data Independence
Physical Data Independence
Changes in storage structure do not affect the logical schema.
Logical Data Independence
Changes in the logical schema do not affect application programs.
Keys in DBMS
Super Key
A set of one or more attributes that uniquely identifies a tuple.
Candidate Key
A minimal super key.
Primary Key
The candidate key chosen to uniquely identify records.
- Properties: Unique, Cannot contain NULL values
Alternate Key
Candidate keys not selected as the primary key.
Composite Key
Consists of more than one attribute.
Foreign Key
References the primary key of another table and maintains referential integrity.
💡 Important: A Primary Key is unique and cannot be NULL. A Foreign Key references a Primary Key and maintains referential integrity.
Normalization
Purpose: Remove redundancy, improve consistency, reduce anomalies.
1NF
- Atomic values
- No repeating groups
2NF
- In 1NF
- No partial dependency
3NF
- In 2NF
- No transitive dependency
BCNF
Every determinant must be a candidate key.
4NF
Removes multi-valued dependencies.
5NF
Removes join dependencies.
Transactions & ACID Properties
A transaction is a sequence of database operations executed as a single logical unit.
ACID Properties
Atomicity
Either all operations occur or none.
Consistency
Maintains database validity.
Isolation
Transactions execute independently.
Durability
Committed changes remain permanent.
SQL Joins
- INNER JOIN – Returns matching rows from both tables
- LEFT OUTER JOIN – All rows from left, matching from right
- RIGHT OUTER JOIN – All rows from right, matching from left
- FULL OUTER JOIN – All rows from both tables
- SELF JOIN – Table joins with itself
- CROSS JOIN – Cartesian product
Frequently Asked Exam Facts
- Father of Relational Model: Dr. E. F. Codd
- SQL was originally developed at IBM.
- A Primary Key cannot contain NULL values.
- A Foreign Key references a Primary Key.
- BCNF is stronger than 3NF.
- B+ Trees are widely used for indexing.
- MongoDB is a document database.
- Redis is a key-value database.
- Cassandra is a column-family database.
- Neo4j is a graph database.
Last-Minute One-Line Revision
- 1. DBMS manages and organizes data efficiently.
- 2. RDBMS stores data in tables.
- 3. A Primary Key is unique and cannot be NULL.
- 4. A Candidate Key is a minimal Super Key.
- 5. Foreign Keys maintain referential integrity.
- 6. SQL is the standard language for relational databases.
- 7. DDL defines database objects.
- 8. DML modifies data.
- 9. DQL retrieves data.
- 10. DCL manages permissions.
- 11. TCL manages transactions.
- 12. ACID properties ensure reliable transactions.
- 13. 1NF removes repeating groups.
- 14. 2NF removes partial dependencies.
- 15. 3NF removes transitive dependencies.
- 16. BCNF requires every determinant to be a candidate key.
- 17. B+ Trees provide efficient indexing.
- 18. Hashing enables fast key lookups.
- 19. CAP theorem applies to distributed databases.
- 20. Data warehouses support business intelligence and analytics.
🎯 Conclusion
"DBMS is a scoring subject in GATE, Rajasthan Computer Teacher, BCI, NIELIT, and other competitive examinations. A strong understanding of database fundamentals, SQL, normalization, transactions, indexing, and NoSQL can significantly improve your exam performance. Revise these notes regularly, solve previous-year questions, and practice SQL queries to build both conceptual clarity and problem-solving speed."
परिणाम
बहुत अच्छा!
ऊपर 'पुनः प्रयास' बटन से दोबारा प्रयास करें