Introduction to DBMS – Study Notes
Database Management System (DBMS) is software for storing and managing data efficiently.
1. Characteristics of DBMS:
- Data abstraction
- Data independence
- Efficient data access
- Data integrity and security
- Concurrent access and crash recovery
2. Types of DBMS:
- Hierarchical DBMS
- Network DBMS
- Relational DBMS (RDBMS)
- Object-oriented DBMS
3. Data Models:
- Conceptual (ER model)
- Logical (Relational model)
- Physical model
4. Keys in DBMS:
- Primary Key, Candidate Key, Foreign Key, Composite Key
5. Normalization:
- Process of organizing data to reduce redundancy
- Normal Forms: 1NF, 2NF, 3NF, BCNF
6. SQL Basics:
- DDL: CREATE, ALTER, DROP
- DML: INSERT, UPDATE, DELETE
- DQL: SELECT
- DCL: GRANT, REVOKE
- TCL: COMMIT, ROLLBACK
7. Transactions:
- ACID properties (Atomicity, Consistency, Isolation, Durability)
8. Indexing & Joins:
- Indexes improve query performance
- INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
9. ER Diagrams and Relationships
10. Advantages of DBMS over File System
Introduction to DBMS – Study Notes
Database Management System (DBMS) is software for storing and managing data efficiently.
1. Characteristics of DBMS:
- Data abstraction
- Data independence
- Efficient data access
- Data integrity and security
- Concurrent access and crash recovery
2. Types of DBMS:
- Hierarchical DBMS
- Network DBMS
- Relational DBMS (RDBMS)
- Object-oriented DBMS
3. Data Models:
- Conceptual (ER model)
- Logical (Relational model)
- Physical model
4. Keys in DBMS:
- Primary Key, Candidate Key, Foreign Key, Composite Key
5. Normalization:
- Process of organizing data to reduce redundancy
- Normal Forms: 1NF, 2NF, 3NF, BCNF
6. SQL Basics:
- DDL: CREATE, ALTER, DROP
- DML: INSERT, UPDATE, DELETE
- DQL: SELECT
- DCL: GRANT, REVOKE
- TCL: COMMIT, ROLLBACK
7. Transactions:
- ACID properties (Atomicity, Consistency, Isolation, Durability)
8. Indexing & Joins:
- Indexes improve query performance
- INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
9. ER Diagrams and Relationships
10. Advantages of DBMS over File System
