Notes on Database and DBMS - Class 8
1. What is a Database?
• A database is a collection of related data that is stored and organized so that it can be
easily accessed, managed, and updated.
• Example: A school database may contain data about students, teachers, and classes.
2. Why Use a Database?
• To store large amounts of data efficiently.
• To easily retrieve, update, and delete data.
• To avoid duplication of data.
3. What is DBMS (Database Management System)?
• A DBMS is software that helps to create, manage, and use databases.
• It allows users to store data in a structured way and provides tools to manage the data.
4. Features of DBMS:
• Data storage and retrieval
• Data security and protection
• Data integrity and consistency
• Easy data management
5. Examples of DBMS:
• MySQL
• Oracle
• Microsoft Access
• MS Access
6. Difference between Database and DBMS:
Database DBMS
Collection of data Software to manage the database
Stores data Helps to organize and manage data
7. Advantages of DBMS:
• Reduces data redundancy
• Provides backup and recovery
• Allows multi-user access
• Improves data sharing