CBSE Class 10/Overview
Curriculum 2026–27
Practice
All Revision Notes
Information TechnologyCh-14 15 min comprehensive revision
CBSE Class 10 IT (402) — Part B: Unit 3 (Database Management System)

Create & Edit Tables in LibreOffice Base

Creating databases in LibreOffice Base, Table Design View vs Table Wizard, Field data types (Numeric, Text, Date/Time, Binary, Boolean), Field properties (Length, Default, Format, AutoValue), and setting Primary Keys.

Quick Key Takeaways:
Table Creation in Base: Recommended method is Table Design View where field names, data types, and field properties are explicitly configured.
Base Data Types: Numeric (INTEGER, DECIMAL, TINYINT), Alphanumeric (VARCHAR, CHAR, LONGVARCHAR), Date/Time (DATE, TIME, TIMESTAMP), and Yes/No (BOOLEAN).
Jump to Concept:1. Base Data Types & Classification2. Creating Tables in Design View
1

Base Data Types & Classification

Data Types

Every field in a database must have an associated data type defining the type and size of values it can store.

• Numeric Types
TINYINT (0 to 255), SMALLINT, INTEGER (whole numbers), BIGINT, DECIMAL / NUMERIC (floating-point numbers with exact scale/precision e.g. currency).
• Alphanumeric / Text Types
CHAR(n) (fixed length text string, spaces padded), VARCHAR(n) (variable length text up to n characters, saves storage space), LONGVARCHAR / MEMO (large descriptive text blocks).
• Date / Time Types
DATE (stores year, month, day: YYYY-MM-DD), TIME (hours, minutes, seconds: HH:MM:SS), TIMESTAMP (both date and time combined).
• Other Types
BOOLEAN (stores TRUE/FALSE or 1/0), IMAGE / BINARY / BLOB (binary objects like photos or audio clips).
2

Creating Tables in Design View

Practical Steps

Step-by-step table design and field property declaration.

• Table Design Steps
1. In Base main window, click Tables in Database pane; 2. Click Create Table in Design View...; 3. In grid, enter Field Name, select Field Type, and add optional Description; 4. In lower pane, configure Field Properties (Length, Default Value, Format Example, Entry Required).
• Setting Primary Key
Right-click the grey row selector next to the field name → Select Primary Key (a small golden key icon appears). Set AutoValue = Yes if Base should generate sequential IDs automatically.
• Saving Table
Click Save icon or press Ctrl+S → Enter Table Name (e.g. tbl_Students) → Click OK.
Authentic Board Question (3 Marks)Topic: Create & Edit Tables in LibreOffice Base RDBMS Architecture & SQL Syntax
Explain the relational database concepts and write the precise SQL commands required for "Create & Edit Tables in LibreOffice Base".

Official CBSE Step-by-Step Marking Breakdown:

Step 1: Database Concept & Constraint: Define Primary Key, Foreign Key, Table, Record, Field, or Data Integrity constraint.
1 Mark
Step 2: Standard SQL Statement Syntax: Write grammatically valid SQL syntax (CREATE TABLE, SELECT ... WHERE, INSERT INTO, UPDATE).
1 Mark
Step 3: Execution Output & Semicolon Rule: Demonstrate query execution result and terminate statements with a semicolon (;).
1 Mark
Model Student Answer (Target: Full 3/3 Marks):
For full marks in CBSE IT (402) Database Management on "Create & Edit Tables in LibreOffice Base":

1. RDBMS Structural Rule: Define how tables store normalized records and why Primary Keys enforce entity integrity.
2. Valid SQL Query:
``sql SELECT ColumnName1, ColumnName2 FROM TableName WHERE Condition ORDER BY ColumnName ASC; ``
3. Query Execution Result: Explain how the filtering condition processes rows and returns the resultant recordset.
Examiner Mark Deduction Traps:
•Always end every SQL query with a semicolon (;). Missing semicolons cost marks.
•Write SQL keywords (SELECT, FROM, WHERE, ORDER BY, GROUP BY) in uppercase for clarity.

High-Frequency Conceptual Doubts & FAQs

Curated answers to the most common questions asked by Class 10 students.
This chapter establishes the foundational principles, definitions, and operational workflows required for Class 10 board mastery.

Next Learning Steps & Active Practice

You have completed the revision notes. Now apply, test, and evaluate your understanding.
Notes Completed