LibreOffice Base is the database management component of LibreOffice — and it's a significant part of the IT 402 syllabus. Database questions appear in both Section A (MCQ) and Section B (subjective) of the IT 402 board exam. Students who understand the concepts clearly — rather than just memorising terms — score consistently higher in this section.
What Is a Database? — Core Concepts
A database is an organised collection of related data stored electronically so it can be easily accessed, managed and updated.
A Database Management System (DBMS) is software that manages databases. LibreOffice Base is an example of a DBMS. Other examples include MySQL, Microsoft Access, and Oracle.
📚 Key Definition for Exam: DBMS = software that stores, retrieves, organises and manages data efficiently. LibreOffice Base is the DBMS used in IT 402.
Essential Database Terminology — All From CBSE Syllabus
| Term | Definition | Example |
|---|---|---|
| Table | The basic unit of a database — stores data in rows and columns | A "Students" table with columns for name, roll number, marks |
| Field | A column in a table — represents one type of data | In the Students table: "Name" is a field |
| Record | A row in a table — represents one complete entry | One student's complete data (name + roll no + marks) = one record |
| Primary Key | A field that uniquely identifies each record in a table | Roll Number is a primary key — no two students share the same roll number |
| Foreign Key | A field that links to the primary key of another table | Student's Department ID in a student table links to Department table |
| Query | A request to retrieve specific data from a database based on conditions | Find all students who scored above 75 marks |
| Form | A user-friendly interface for entering data into a table | A form with labelled text boxes for entering student details |
| Report | A formatted printout of data from the database | A printable list of all students with their grades |
Primary Key — The Most Examined Concept
The primary key is tested in almost every IT 402 board paper. Three key properties to remember:
- Unique: No two records can have the same primary key value
- Not Null: A primary key cannot be empty — every record must have a primary key value
- Immutable: A primary key value should not change once assigned
Common Exam Question: "Why is Roll Number suitable as a primary key for a Student table?" Answer: Because every student has a unique roll number, it cannot be NULL, and it does not change — all three properties of a primary key are satisfied.
Another Common Question: "Can Name be used as a primary key?" Answer: No — two students can have the same name, so Name is not unique and cannot serve as a primary key.
Types of Queries in LibreOffice Base
A query is used to extract specific data from a database based on conditions you specify. In LibreOffice Base, queries can be created using the Query Design view (visual) or SQL (text-based).
Examples of database queries in IT 402 context:
- Show all students whose marks are greater than 75
- Display names of students from a specific city
- Find all books published after 2020 in a library database
- Count how many employees earn above ₹50,000
In board exams, you may be asked to: (a) describe what a query does, (b) write conditions for a specific query, or (c) identify what data a given query would return. Focus on understanding what queries DO rather than memorising SQL syntax — IT 402 does not deeply test SQL code.
Creating a Table in LibreOffice Base — Step-by-Step
- Open LibreOffice Base → Create a new database or open existing one
- Click on Tables in the Database panel → Click "Create Table in Design View"
- For each column (field): enter the Field Name, select the Field Type (Text, Integer, Date, etc.) and set properties
- Right-click on the Roll Number row → Set as Primary Key (look for the key icon)
- Save the table with a name (e.g., "Students")
Field Types in LibreOffice Base
| Field Type | Used For | Example |
|---|---|---|
| Text (VARCHAR) | Names, addresses, text data | Student Name, City |
| Integer (INT) | Whole numbers | Age, Roll Number, Marks |
| Decimal/Numeric | Numbers with decimal points | Salary (₹25,500.50) |
| Date | Calendar dates | Date of Birth, Admission Date |
| Yes/No (BOOLEAN) | True/False values | Is the student a boarder? |
| Memo/CLOB | Long text | Student address, remarks |
Advantages of DBMS Over File Systems — Frequently Asked
This comparison appears regularly in IT 402 Section B. Key advantages of DBMS:
- No data redundancy: Data is stored once and linked across tables — no repetition
- Data consistency: Update data in one place, it reflects everywhere
- Easy querying: Specific data can be retrieved instantly using queries
- Security: Access can be restricted using passwords and user roles
- Data integrity: Rules (like primary key constraints) ensure data accuracy
📋 Most Likely Board Question: "A school uses a separate file for each class to store student records. Suggest a better approach and give two advantages." Answer: Use a DBMS like LibreOffice Base. Advantages: (1) No data redundancy — student data stored once, accessible by all teachers. (2) Easy querying — find all students above a certain marks threshold instantly. (3) Data consistency — updates to student records reflect everywhere simultaneously.
All database questions from the actual IT 402 2026 board exam are in the IT 402 answer key on SkillYog — review those questions to see exactly how the examiner expects database concepts to be answered.