Class 10 | CBSE IT (Code 402) | Part B – Unit 3 | Session 2026–27
Introduction
Database Management System (DBMS) is software that allows you to create, manage, and manipulate databases efficiently. In Part B – Unit 3, you will learn to use LibreOffice Base, a free and open-source database tool, to create databases, tables, forms, queries, and reports.
These skills are essential for organizing large amounts of data, retrieving specific information quickly, and generating professional reports for school projects, future studies, and careers.
💡 Note: LibreOffice Base is completely free to download and use on Windows, macOS, and Linux. Download from: www.libreoffice.org
1. Introduction to Database Management System
1.1 Data and Information
Data:
Raw, unorganized facts and figures.
Examples: Numbers, text, images, sounds.
Example: 25, "Amit", "Pune", 95
Information:
Processed, organized, and meaningful data.
Provides context and understanding.
Example: "Amit is 25 years old, lives in Pune, and scored 95 marks."
📊 Key Difference: Data becomes information when it is processed and given meaning.
1.2 Database
Database:
A structured collection of related data stored electronically.
Organized for easy access, management, and updating.
Examples: School student database, library book database, hospital patient database, bank account database.
Characteristics of a Good Database:
Organized: Data is structured logically (tables, fields, records).
Accessible: Easy to retrieve and update data.
Secure: Protected from unauthorized access.
Consistent: Data is accurate and free from errors.
Scalable: Can handle growing amounts of data.
1.3 Database Management System (DBMS)
DBMS:
Software that allows users to create, define, manipulate, and manage databases.
Acts as an interface between users and the database.
Examples: LibreOffice Base, MS Access, MySQL, Oracle, PostgreSQL, SQLite.
Functions of DBMS:
Data Definition – Create database structure (tables, fields, relationships).
Data Manipulation – Insert, update, delete, and retrieve data.
Data Security – Control access and protect data.
Data Integrity – Ensure accuracy and consistency.
Data Backup and Recovery – Protect against data loss.
Multi-user Access – Allow multiple users to work simultaneously.
1.4 Advantages of Database
Advantage
Description
Data Sharing
Multiple users can access and share data simultaneously.
Data Integrity
Ensures accuracy and consistency through validation rules.
Data Security
Controls access through passwords and user permissions.
Reduced Data Redundancy
Minimizes duplicate data, saving storage space.
Data Consistency
Changes in one place reflect everywhere (no conflicting data).
Efficient Data Access
Quick retrieval using queries and indexes.
Data Backup and Recovery
Built-in tools to backup and restore data.
Scalability
Can handle large volumes of data as organization grows.
Better Decision Making
Generate reports for analysis and planning.
1.5 Data Models
Data Model:
A conceptual representation of how data is structured and related.
Defines how data is stored, accessed, and manipulated.
Types of Data Models:
1. Hierarchical Data Model
Data is organized in a tree-like structure (parent-child relationship).
Each parent can have multiple children, but each child has only one parent.
Retrieve specific data from one or more tables based on criteria.
Can perform calculations, sorting, filtering, and joining tables.
Example: "Show all students with marks > 80."
3. Forms
User-friendly interface for entering, viewing, and editing data.
Easier than working directly with tables.
Example: Data entry form for adding new students.
4. Reports
Formatted output of data for printing or sharing.
Summarize and present data professionally.
Example: Student mark sheet report, Sales summary report.
📊 Relationship: Tables store data → Queries retrieve data → Forms input data → Reports present data.
2. Getting Started with LibreOffice Base
2.1 What is LibreOffice Base?
LibreOffice Base is the database component of the LibreOffice suite. It is a free, open-source DBMS that allows you to create and manage databases, tables, forms, queries, and reports.
Key Features:
Free and Open-Source – No cost, no license fees.
Cross-Platform – Works on Windows, macOS, Linux.
File Compatibility – Saves as .odb (Base), can link to external databases (MySQL, PostgreSQL, Access, etc.).
Wizards – Guided tools for creating tables, forms, queries, and reports.
SQL Support – Write and execute SQL queries directly.
Relationships – Define relationships between tables (one-to-many, many-to-many).
Forms and Reports – Create professional data entry forms and reports.
2.2 LibreOffice Base Interface
When you open LibreOffice Base, you see:
Database Pane (Left) – Navigation panel with icons for:
Tables – View and manage tables.
Queries – Create and run queries.
Forms – Design and use forms.
Reports – Generate reports.
Tasks Pane (Right) – Quick actions:
Create Table in Design View – Manually define table structure.
Use Wizard to Create Table – Guided table creation.
Open Existing Database – Open saved databases.
Menu Bar – File, Edit, View, Insert, Tools, Window, Help.
📌 Note: Relationships are an advanced topic; focus on creating single tables for Class 10 exams.
4. Working with Forms
4.1 What is a Form?
A Form is a user-friendly interface for entering, viewing, and editing data in tables. Forms make data entry easier and more intuitive than working directly with tables.
Advantages of Forms:
User-Friendly – Clear labels, organized layout.
Data Validation – Restrict input to valid values.
Navigation – Easy to move between records.
Professional Look – Customizable design with logos, colors, fonts.
Reduced Errors – Dropdowns, checkboxes, and input masks prevent mistakes.
4.2 Creating a Form Using Wizard
Step-by-Step Procedure:
Step 1: Select Forms
In the Database Pane, click Forms.
Step 2: Use Wizard
In the Tasks Pane, click Use Wizard to Create Form.
Step 3: Select Fields
Tables or queries: Choose the table for which you're creating the form (e.g., "Student").
Available fields: List of all fields in the table.
Fields in the form: Fields to include in the form.
Use > or >> buttons to move fields.
Click Next.
Step 4: Set Up Subform (Optional)
Add subform: Check if you want a form within a form (e.g., Student form with embedded Marks form).
🎨 Tip: Keep forms clean and organized. Use consistent fonts, colors, and spacing.
5. Working with Queries
5.1 What is a Query?
A Query is a request for specific data from one or more tables based on criteria. Queries allow you to filter, sort, calculate, and join data without modifying the original tables.
Uses of Queries:
Retrieve specific records (e.g., "Students with marks > 80").
Sort data (e.g., "List students alphabetically").
Perform calculations (e.g., "Calculate average marks per class").
Join multiple tables (e.g., "Show student names with their class teacher").
Update or delete records in bulk.
5.2 Creating a Query Using Wizard
Step-by-Step Procedure:
Step 1: Select Queries
In the Database Pane, click Queries.
Step 2: Use Wizard
In the Tasks Pane, click Use Wizard to Create Query.
Step 3: Select Fields
Tables: Choose the table (e.g., "Student").
Available fields: List of fields in the table.
Fields in the query: Fields to include in query results.
Use > or >> buttons to move fields.
Click Next.
Step 4: Set Sorting Order
Choose up to 4 fields to sort by.
Select Ascending or Descending for each.
Example: Sort by Name (Ascending), then by Marks (Descending).
Click Next.
Step 5: Set Search Conditions (Filter)
Choose a field to filter (e.g., Marks).
Choose a condition:
is greater than
is less than
is equal to
contains
starts with
ends with
Enter value (e.g., 80).
Add multiple conditions with AND (all must be true) or OR (at least one true).
Example: Marks > 80 AND Class = 'X'.
Click Next.
Step 6: Replace Field Name (Optional)
Rename fields in query results (e.g., "Roll_No" → "Roll Number").
Click Next.
Step 7: Name the Query
Enter query name (e.g., "Top_Students").
Open query for editing: Check to view results immediately.
Click Finish.
Step 8: View Query Results
Query results display in a table-like view.
Only records matching your criteria are shown.
5.3 Creating a Query in Design View (SQL)
Step-by-Step Procedure:
Step 1: Select Queries
In the Database Pane, click Queries.
Step 2: Create Query in Design View
In the Tasks Pane, click Create Query in Design View.
Step 3: Add Tables
A dialog shows all tables in the database.
Select the table(s) you want to query.
Click Add → Close.
Step 4: Select Fields
In the lower grid, select fields from the dropdown:
Field: Choose field name (e.g., Roll_No, Name, Marks).
Table: Auto-filled with table name.
Visible: Check to show in results.
Sort: Choose Ascending or Descending.
Criteria: Enter filter conditions.
Example: Show students with marks > 80, sorted by Name
Field
Table
Visible
Sort
Criteria
Roll_No
Student
Yes
-
-
Name
Student
Yes
Ascending
-
Marks
Student
Yes
-
>80
Class
Student
Yes
-
-
Step 5: Run Query
Click the Run Query icon (red exclamation mark) or press F5.
Results display in a new window.
Step 6: Save Query
Click Save (Ctrl+S).
Enter query name (e.g., "Top_Students").
Click OK.
5.4 SQL Queries (Advanced)
LibreOffice Base supports SQL (Structured Query Language) for writing custom queries.
Basic SQL Commands:
SELECT – Retrieve Data
sqlSELECT*FROM Student;
Retrieves all fields and all records from Student table.
sqlSELECT Name, Marks FROM Student WHERE Marks >80;
Retrieves Name and Marks for students with marks > 80.
sqlSELECT Name, Class, Marks FROM Student ORDERBY Name ASC;
sqlSELECT Student.Name, Class.Class_Name
FROM Student
INNERJOIN Class ON Student.Class_ID = Class.Class_ID;
Joins Student and Class tables on Class_ID.
📌 Exam Tip: For Class 10, focus on SELECT with WHERE, ORDER BY, and simple aggregate functions (COUNT, AVG, SUM, MAX, MIN).
5.5 Query Criteria Examples
Criteria
Example
Meaning
Exact Match
= 'X'
Class is exactly 'X'
Greater Than
> 80
Marks greater than 80
Less Than
< 50
Marks less than 50
Between
BETWEEN 60 AND 80
Marks between 60 and 80 (inclusive)
Contains
LIKE '*Kumar*'
Name contains "Kumar"
Starts With
LIKE 'A*'
Name starts with "A"
Ends With
LIKE '*sh'
Name ends with "sh"
Not Equal
<> 'X'
Class is not 'X'
Is Null
IS NULL
Field is empty
Is Not Null
IS NOT NULL
Field is not empty
📊 Tip: Use single quotes for text values ('X', 'Amit') and no quotes for numbers (80, 101).
6. Working with Reports
6.1 What is a Report?
A Report is a formatted, professional output of data from tables or queries, designed for printing or sharing. Reports summarize and present data in a readable, attractive format.
Uses of Reports:
Generate mark sheets, certificates, invoices, summaries.
Present data to management, teachers, or clients.
Archive records in printed format.
Share data in PDF or printed form.
6.2 Creating a Report Using Wizard
Step-by-Step Procedure:
Step 1: Select Reports
In the Database Pane, click Reports.
Step 2: Use Wizard
In the Tasks Pane, click Use Wizard to Create Report.
Step 3: Select Fields
Tables or queries: Choose the table or query (e.g., "Student" or "Top_Students" query).
Available fields: List of fields.
Fields in the report: Fields to include in the report.
Use > or >> buttons to move fields.
Click Next.
Step 4: Add Grouping (Optional)
Group records by a field (e.g., group by Class).
Select field → Click >.
Multiple grouping levels possible (e.g., Class → Section).
Click Next.
Step 5: Set Sorting Order
Choose up to 4 fields to sort by.
Select Ascending or Descending.
Example: Sort by Name (Ascending).
Click Next.
Step 6: Choose Layout
Select report layout:
Portrait or Landscape.
Columnar, Tabular, Justified.
Number of columns (for multi-column reports).
Click Next.
Step 7: Set Background and Colors
Choose background color or image.
Select color scheme for text and borders.
Click Next.
Step 8: Name the Report
Enter report name (e.g., "Student_Mark_Report").
Open report for editing: Check to customize further.
Click Finish.
Step 9: View Report
Report opens in a new window.
Data is formatted professionally.
Use navigation buttons to browse pages.
6.3 Customizing Reports (Design View)
To Edit Report Design:
Right-click the report name → Edit.
Report opens in Design View.
Common Customizations:
Add Labels/Titles:
Click the Label tool.
Click on the report and type text (e.g., "Pioneer International School – Student Mark Sheet").
Add Images/Logo:
Click the Image tool.
Click on the report → Browse and select logo file.
Resize and position.
Change Fonts and Colors:
Right-click a field or label → Control Properties.
In the Properties dialog:
Font tab: Change font, size, style.
Colors tab: Change background, text color.
Border tab: Add or remove borders.
Add Page Numbers:
Insert → Field → Page Number.
Position in header or footer.
Add Date and Time:
Insert → Field → Date or Time.
Choose format (e.g., DD/MM/YYYY).
Add Lines and Shapes:
Use Line or Shape tools to add borders, separators, or decorative elements.
Adjust Field Positions:
Click and drag fields to reposition.
Resize fields by dragging edges.
Set Page Margins and Size:
Format → Page.
Set margins, paper size (A4, Letter), orientation.
Structured Query Language for writing custom queries.
SELECT
Retrieve data from tables.
WHERE
Filter records based on conditions.
ORDER BY
Sort results (ASC/DESC).
Aggregate Functions
COUNT, SUM, AVG, MAX, MIN.
GROUP BY
Group results by a field.
Practice Questions
Q1. Define data and information. Give one example of each. Q2. What is a database? List any four advantages of using a database. Q3. Define DBMS and RDBMS. Give two examples of each. Q4. Explain the three types of data models with examples. Q5. Define the following terms: Table, Field, Record, Primary Key, Foreign Key. Q6. What are the four main objects of an RDBMS? Explain each briefly. Q7. What is LibreOffice Base? List any four key features. Q8. Describe the steps to create a new database in LibreOffice Base. Q9. What are data types? Explain any five data types used in LibreOffice Base. Q10. Describe the steps to create a table using the Table Wizard. Q11. How do you create a table in Design View? Explain with an example. Q12. What is a primary key? Why is it important? Q13. Define a form. List any four advantages of using forms. Q14. Describe the steps to create a form using the Form Wizard. Q15. How do you customize a form in Design View? Q16. What is a query? Explain any four uses of queries. Q17. Describe the steps to create a query using the Query Wizard. Q18. Write the SQL query to: a) Retrieve all records from Student table. b) Show names and marks of students with marks > 80. c) Count the total number of students. d) Calculate average marks. e) List students sorted by name (ascending). Q19. What is a report? Why are reports useful? Q20. Describe the steps to create a report using the Report Wizard. Q21. How do you export a report as PDF? Q22. Explain the difference between a table, a query, a form, and a report. Q23. What is the purpose of the WHERE clause in SQL? Give two examples. Q24. Explain the GROUP BY clause with an example. Q25. Create a database schema for a Library Management System with at least three tables. Define fields, data types, and primary keys for each table.
Practical Exercises
Exercise 1: Student Database
Create a database named "School_DB.odb".
Create a table "Student" with fields: Roll_No (INTEGER, Auto Value, PK), Name (VARCHAR 50), Class (VARCHAR 10), Section (VARCHAR 5), DOB (DATE), Marks (DECIMAL 5,2), IsActive (BOOLEAN).
Enter at least 10 student records.
Create a form "Student_Entry_Form" with all fields, dropdown for Class, checkbox for IsActive.
Create a query "Top_Students" to show students with Marks > 80, sorted by Marks (Descending).
Create a report "Student_Mark_Report" grouped by Class, sorted by Name.
Exercise 2: Library Database
Create a database named "Library_DB.odb".
Create three tables: Books, Members, Transactions (as described in Case Study 2).
Enter sample data (at least 5 books, 5 members, 5 transactions).
Create a form "Book_Entry_Form" with dropdown for Category.
Create a query "Available_Books" to show books where IsAvailable = 'Yes'.
Create a report "Library_Summary_Report" grouped by Category.
Exercise 3: Staff Database with SQL Queries
Create a database named "Staff_DB.odb".
Create a table "Staff" with fields: Staff_ID, Name, Designation, Department, DOJ, Salary, Phone, Email, IsActive.
Enter at least 10 staff records.
Write SQL queries to: a) Count total staff in each department. b) Find average salary by department. c) List staff who joined before 2020. d) Show staff with salary > 50000.
Create a report "Staff_Directory_Report" grouped by Department.
Exercise 4: Advanced Queries and Reports
Using the Student database from Exercise 1:
Create a query to calculate class-wise average marks.
Create a query to find the student with the highest marks.
Design a professional mark sheet report for students:
School name and logo at the top.
Student details (Roll_No, Name, Class, Section).
Marks obtained and grade (use a calculated field or query).
Signature lines for teacher and principal.
Page numbers and date.
Export the report as PDF.
Teacher's Note
Part B – Unit 3 is heavily practical—ensure students practice in the computer lab.
Focus on creating tables, forms, queries, and reports as they are frequently asked in exams.
Encourage students to create real-world databases (student management, library, staff, inventory) for better understanding.
Demonstrate SQL queries live in class—students find writing queries engaging.
Remind students to save their work frequently and organize database files properly.
Emphasize that LibreOffice Base is free and open-source—a valuable tool for students who may not have access to paid software.
Provide sample datasets for students to practice creating databases, forms, queries, and reports.
Assign group projects where students collaborate on designing a complete database system for a hypothetical school, library, or shop.
Final Thoughts
Mastering LibreOffice Base transforms you from a basic computer user to a database manager who can organize, analyze, and present data professionally—without spending a rupee on software. Whether you're managing student records, library books, staff details, or inventory, these skills will save you time and impress your teachers, colleagues, and future employers.
Practice regularly, experiment with queries and forms, and don't hesitate to explore Base's features on your own.
End of Part B – Unit 3 Notes: Database Management System using LibreOffice Base CBSE Class 10 IT (Code 402) | Aligned with 2026–27 Syllabus
About the Author: These notes are created by Ravindra Khillare, a Computer Science Teacher at Pioneer International School, Pune. With a focus on CBSE IT 402 curriculum, these resources aim to support students, teachers, and educators in mastering essential database management skills using free and open-source tools.
Feel free to share, adapt, and use these notes for classroom teaching, blog posts, or student handouts. For queries or suggestions, connect via your school's IT department or educational networks.
Comments
Post a Comment