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

RDBMS Concepts & Principles (LibreOffice Base)

Data vs Information, Database definition, DBMS vs RDBMS advantages, Relational data models, Tables (Relations), Fields (Attributes), Records (Tuples), and Key attributes (Primary, Candidate, Alternate, Foreign, Composite).

Quick Key Takeaways:
RDBMS Relational Terminology: Table = Relation, Row = Record / Tuple, Column = Field / Attribute, Number of rows = Cardinality, Number of columns = Degree.
Database Keys: Primary Key uniquely identifies each record and cannot be NULL; Foreign Key is a field in one table that references the Primary Key of another table to establish relationships.
Jump to Concept:1. DBMS vs RDBMS & Core Advantages2. Relational Data Model Terminology3. Classification of Database Keys
1

DBMS vs RDBMS & Core Advantages

Database Theory

A DBMS is software that allows storing, modifying, and extracting information from a database efficiently and securely.

• Data vs Information
Data: Raw, unorganized facts and figures (e.g. '95, Rahul, IT'). Information: Processed, meaningful, structured data (e.g. 'Rahul scored 95 marks in IT').
• Advantages of DBMS/RDBMS
1. Reduces Data Redundancy (eliminates duplicate copies); 2. Prevents Data Inconsistency; 3. Facilitates Data Sharing; 4. Enforces Data Integrity Standards; 5. Provides Robust Data Security (access permissions & passwords); 6. Backup and Recovery.
2

Relational Data Model Terminology

Exam Terminology

E.F. Codd's Relational Model structures data into two-dimensional tables.

• Table / Relation
A two-dimensional grid of rows and columns storing data about a specific entity (e.g. Student, Employee).
• Field / Attribute
A single piece of information representing a column in a table (e.g. RollNo, StudentName, Marks).
• Record / Tuple
A single horizontal row representing a complete set of attributes for one entity instance.
• Degree vs Cardinality
Degree: Total number of columns/attributes in a table. Cardinality: Total number of rows/records in a table.
3

Classification of Database Keys

CBSE High Yield

Keys uniquely identify tuples and establish relational integrity across tables.

• Primary Key
A unique attribute (or set of attributes) chosen to identify each record in a table uniquely. Properties: Must be unique, cannot contain NULL values, only ONE primary key per table.
• Candidate Key
All fields (attributes) in a table that are eligible to become the Primary Key (e.g., AdmissionNo, AadhaarNo).
• Alternate Key
A Candidate Key that was NOT chosen as the Primary Key.
• Foreign Key
A field in a child table that references the Primary Key of a parent table, linking both tables and enforcing referential integrity.
• Composite Primary Key
A primary key consisting of two or more attributes combined together to guarantee uniqueness.
Authentic Board Question (3 Marks)Topic: RDBMS Concepts & Principles (LibreOffice Base) RDBMS Architecture & SQL Syntax
Explain the relational database concepts and write the precise SQL commands required for "RDBMS Concepts & Principles (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 "RDBMS Concepts & Principles (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