Absolutely. For Class 10 Information Technology (402), Unit 3 is Database Management System (DBMS). Here is a student-friendly revision note.
Database:
A database is an organized collection of related data that can be easily stored, accessed, managed, and updated.
Example:
A school database may contain:
- Student name
- Roll number
- Class
- Section
- Marks
- Contact details
DBMS:
DBMS (Database Management System) is software used to create, store, organize, manage, and retrieve data from a database.
Examples of DBMS
- LibreOffice Base
- MySQL
- Microsoft Access
- Oracle
- PostgreSQL
Main functions of DBMS
- Creating databases
- Storing data
- Adding new data
- Editing data
- Deleting data
- Searching and retrieving data
- Sorting and filtering data
- Generating reports
Database Objects:
A database can contain several important objects.
A. Table
A table stores data in rows and columns.
Example:
| Roll No. | Name | Class | Marks |
|---|---|---|---|
| 101 | Rahul | 10 | 85 |
| 102 | Priya | 10 | 91 |
| 103 | Aman | 10 | 78 |
B. Field
A field is a column in a table.
Example:
- Roll No.
- Name
- Class
- Marks
C. Record
A record is a complete row containing information about one item/person.
Example:
101 | Rahul | 10 | 85
Easy way to remember:
Table → contains Fields + Records
Data Types:
A data type determines what kind of information can be stored in a field.
Common data types include:
| Data Type | Used for |
|---|---|
| Text | Names, addresses |
| Number | Age, marks, quantity |
| Date/Time | Date and time |
| Currency | Money values |
| Yes/No | True/False information |
| Decimal | Values containing decimal numbers |
Primary Key:
A Primary Key is a field that uniquely identifies each record in a table.
Example:
| Student ID | Name |
|---|---|
| 101 | Rahul |
| 102 | Priya |
| 103 | Aman |
Here, Student ID can be the Primary Key.
Characteristics
- Must be unique
- Cannot contain duplicate values
- Normally cannot be empty/null
- Helps identify records quickly
⭐ Board Tip:
Primary Key = Unique identification of a record
Foreign Key:
A Foreign Key is a field in one table that refers to the Primary Key of another table.
It helps establish a relationship between tables.
Example:
Student Table
| Student_ID | Name |
|---|---|
| 101 | Rahul |
| 102 | Priya |
Marks Table
| Student_ID | Marks |
|---|---|
| 101 | 85 |
| 102 | 91 |
Here, Student_ID connects the two tables.
Relationships in a Database:
Relationships show how tables are connected.
Types of relationships:
1. One-to-One (1:1)
One record in Table A is related to one record in Table B.
2. One-to-Many (1:M)
One record in Table A can be related to many records in Table B.
3. Many-to-Many (M:M)
Many records in one table can be related to many records in another table.
Query:
A Query is used to retrieve specific information from one or more tables.
Example:
If a Student table contains 100 students, a query can display:
Students who scored more than 80 marks.
Queries can be used to:
- Search data
- Filter data
- Sort data
- Retrieve selected information
⭐ Remember:
Query = Ask the database for specific information
Form:
A Form provides a user-friendly interface for entering and viewing data.
Instead of entering data directly into a table, users can use a form.
Advantages
- Easy data entry
- User-friendly
- Reduces data-entry mistakes
- Makes records easier to view
Report:
A Report presents database information in a well-organized format.
Reports are useful for:
- Printing information
- Presenting data
- Creating summaries
- Preparing official documents
Example:
A school can create a Student Marks Report from its database.
LibreOffice Base:
LibreOffice Base is a database management application included in LibreOffice.
It can be used to create and manage databases.
Main components of Base
- Tables
- Queries
- Forms
- Reports
Easy memory trick:
T-Q-F-R
Table → Query → Form → Report
Advantages of DBMS:
- Reduces data duplication
- Makes data easy to access
- Provides better data organization
- Improves data security
- Allows easy modification
- Makes searching faster
- Supports relationships between tables
- Helps generate reports
⭐ Important Terms for Exam
| Term | Meaning |
|---|---|
| Database | Organized collection of data |
| DBMS | Software for managing databases |
| Table | Stores data in rows and columns |
| Field | A column in a table |
| Record | A row in a table |
| Primary Key | Uniquely identifies a record |
| Foreign Key | Connects related tables |
| Query | Retrieves specific information |
| Form | Used for easy data entry/viewing |
| Report | Presents data in an organized format |
📝 Quick Revision
Database → Collection of related data
DBMS → Manages databases
Table → Stores data
Field → Column
Record → Row
Primary Key → Unique identifier
Foreign Key → Connects tables
Query → Retrieves information
Form → Data entry interface
Report → Presents/prints information