DATABASE MANAGEMENT SYSTEM (DBMS) - FULL SHORT NOTES
Author: Rudraksha Khandagale
Course: BCA (Pune University)
Language: English
----------------------------------
1. Introduction to DBMS
- DBMS is a software used to store, manage, and retrieve data in databases.
- Examples: MySQL, Oracle, SQL Server, MongoDB
2. Types of DBMS
- Hierarchical DBMS
- Network DBMS
- Relational DBMS (RDBMS)
- Object-Oriented DBMS
3. Advantages of DBMS
- Data redundancy control
- Data consistency and security
- Backup and recovery
- Multi-user access
4. Data Models in DBMS
- Hierarchical Model
- Network Model
- Relational Model
- Entity-Relationship Model
5. Keys in DBMS
- Primary Key: Uniquely identifies each record (no null/duplicate)
- Candidate Key: All possible primary keys
- Foreign Key: Refers to Primary Key in another table
Author: Rudraksha Khandagale
Course: BCA (Pune University)
Language: English
----------------------------------
1. Introduction to DBMS
- DBMS is a software used to store, manage, and retrieve data in databases.
- Examples: MySQL, Oracle, SQL Server, MongoDB
2. Types of DBMS
- Hierarchical DBMS
- Network DBMS
- Relational DBMS (RDBMS)
- Object-Oriented DBMS
3. Advantages of DBMS
- Data redundancy control
- Data consistency and security
- Backup and recovery
- Multi-user access
4. Data Models in DBMS
- Hierarchical Model
- Network Model
- Relational Model
- Entity-Relationship Model
5. Keys in DBMS
- Primary Key: Uniquely identifies each record (no null/duplicate)
- Candidate Key: All possible primary keys
- Foreign Key: Refers to Primary Key in another table
