ProSyllabus Journal CBSE Class 11 Annual Assessment Complete Summary and Solutions for Introduction to Structured Query Language (SQL) – NCERT Class XI Informatics Practices, Chapter 8 – Explanation, Questions, Answers Detailed summary and explanation of Chapter 8 'Introduction to Structured Query Language (SQL)' from the NCERT Informatics Practices textbook for Class XI, covering SQL basics including data types, commands (DDL, DML, DCL), creating and modifying tables, querying data using SELECT statements, filtering data with WHERE clause, sorting results, inserting, updating, deleting records, and practice exercises with NCERT questions and answers.
Updated 11 months ago NCERT · Class XI · Informatics Practices · Chapter 8 · SQL · Database Querying · Summary · Questions · Answers · Explanation
#SQL #Structured Query Language #Informatics Practices #NCERT #Class 11 #Data Definition Language #Data Manipulation Language #Queries #Database #Summary #Explanation #Questions #Answers #Chapter 8
Marks booster + cheatsheet: key concepts in 2 lines each, common traps 25 marks: Unit II, Ch 4–8 23 marks: Unit I, Ch 1–3 Common traps, corrected Conic table and standard values Graphs plotted from the book's own tables Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details
Introduction to Structured Query Language (SQL) - Class 11 Informatics Practices Chapter 8 Ultimate Study Guide 2025
Full Chapter Summary & Detailed Notes
Key Definitions & Terms
Text Book Questions & Answers
Key Concepts
Historical Perspectives
Solved Examples
Interactive Quiz (10 Q)
Quick Revision Notes & Mnemonics
Key Terms & Processes
Processes Step-by-Step
Full Chapter Summary & Detailed Notes - SQL Class 11 NCERT
Overview & Key Concepts
Chapter Goal : Learn SQL for MySQL RDBMS - create, populate, query databases. Exam Focus: DDL (CREATE/ALTER), data types (CHAR/VARCHAR/INT/DATE), constraints (PRIMARY/FOREIGN/UNIQUE); 2025 Updates: Modern MySQL features like JSON support. Fun Fact: E.F. Codd quote on relational model. Core Idea: SQL separates logical/physical DB aspects. Real-World: StudentAttendance DB example.Wider Scope : From RDBMS intro to table manipulation; sources: Tables (8.1 Data Types, 8.2 Constraints), figures (8.1 MySQL Shell), activities (LibreOffice vs MySQL), think/reflect (fixed-length strings).Expanded Content : Include SQL rules (case-insensitive, semicolon), multiline entry; point-wise for recall; add 2025 relevance like SQL in cloud DBs.
Introduction to RDBMS and SQL
RDBMS : Systems like MySQL, SQL Server for relations linking/querying data.SQL : Popular query language - easy English words, case-insensitive; for structure definition, data manipulation/retrieval.Benefits : Specify what, not how; beyond querying (DDL/DML/DQL).Example : StudentAttendance DB (from Ch7).Expanded : Evidence: MySQL install from dev.mysql.com; rules: End with ;, multiline with -> prompt.
Conceptual Diagram: MySQL Shell (Fig 8.1)
mysql> prompt ready for SQL; help with 'h' or '?'; clear with 'c'.
Why This Guide Stands Out
Comprehensive: All DDL point-wise, table integrations; 2025 with ethics (data integrity via constraints), analyzed for DB design.
Data Types and Constraints
Data Types (Table 8.1) : CHAR(n) fixed (padded spaces), VARCHAR(n) variable (up to 65k), INT (4 bytes, -2^31 to 2^31-1), FLOAT (decimals), DATE ('YYYY-MM-DD').Constraints (Table 8.2) : NOT NULL (no missing), UNIQUE (distinct), DEFAULT (if no value), PRIMARY KEY (unique ID), FOREIGN KEY (refers to another PK).Think & Reflect : Fixed CHAR for Aadhaar; INT variants (BIGINT for larger).Activity : Explore other types (TEXT, DECIMAL).Expanded : Evidence: Storage efficiency; debates: VARCHAR vs CHAR performance; real: DATE for attendance.
SQL for Data Definition (DDL)
CREATE DATABASE : CREATE DATABASE StudentAttendance; then USE StudentAttendance;; SHOW TABLES; checks empty.CREATE TABLE : Syntax with attributes/datatypes/constraints; ex: STUDENT table (RollNumber INT PRIMARY KEY, etc.).DESCRIBE/DESC : View structure (fields, types, keys); ex: DESC STUDENT shows PRI for PK.ALTER TABLE : ADD/MODIFY/DROP; ex: ADD PRIMARY KEY, FOREIGN KEY (references must match type/size).Examples : STUDENT (PK RollNumber, FK GUID to GUARDIAN); ATTENDANCE (composite PK Date+RollNumber).Activity : Create GUARDIAN/ATTENDANCE without constraints, then ALTER.Think & Reflect : PRIMARY = NOT NULL + UNIQUE; FK in STUDENT/ATTENDANCE, none in GUARDIAN.Expanded : Evidence: Case-sensitivity (Linux yes, Windows no); debates: Constraints timing (pre/post create).
Exam Activities
Install MySQL (Act 8.1); compare Base (Act 8.1); create tables (Act 8.4); SHOW DATABASES (Act 8.3).
Summary Key Points
SQL: Query lang for RDBMS; Types: CHAR/VARCHAR/INT/DATE; Constraints: NOT NULL/PRIMARY/FOREIGN; DDL: CREATE/USE/DESC/ALTER.
Impact: Efficient DB mgmt; challenges: Syntax rules, constraint matching.
Project & Group Ideas
Group: Build Student DB with queries; individual: ALTER script for constraints.
Debate: Fixed vs variable types efficiency.
Ethical role-play: Data integrity with FKs.
Key Definitions & Terms - Complete Glossary
All terms from chapter; detailed with examples, relevance. Expanded: 30+ terms grouped by subtopic; added advanced like "Composite Key", "Referential Integrity" for depth/easy flashcards. Table overflow fixed with word-break.
Structured Query Language (SQL)
Popular query lang for RDBMS. Ex: MySQL commands. Relevance: Data manipulation.
Relational Database Management System (RDBMS)
Systems for relations (tables). Ex: MySQL, Oracle. Relevance: Linking/querying.
CHAR(n)
Fixed-length string (0-255). Ex: Aadhaar (CHAR(12)). Relevance: Padded spaces.
VARCHAR(n)
Variable-length string (0-65k). Ex: Names (VARCHAR(20)). Relevance: Space-efficient.
INT
Integer (4 bytes, -2^31 to 2^31-1). Ex: RollNumber. Relevance: Numeric ops.
DATE
Date ('YYYY-MM-DD'). Ex: SDateofBirth. Relevance: Range 1000-9999.
NOT NULL
No missing values. Ex: SName. Relevance: Data completeness.
PRIMARY KEY
Unique row ID. Ex: RollNumber. Relevance: No duplicates/NULL.
FOREIGN KEY
Refers to another PK. Ex: GUID in STUDENT. Relevance: Relations.
UNIQUE
Distinct values. Ex: GPhone. Relevance: No repeats.
DEFAULT
Value if none provided. Ex: Status 'P'. Relevance: Fallback.
CREATE DATABASE
Make new DB. Ex: StudentAttendance. Relevance: DDL start.
USE
Select DB. Ex: USE StudentAttendance. Relevance: Active context.
SHOW TABLES
List tables. Ex: Empty set initially. Relevance: Verify.
CREATE TABLE
Define table schema. Ex: STUDENT with types. Relevance: Attributes/constraints.
DESCRIBE
View structure. Ex: DESC STUDENT (PRI key). Relevance: Inspect.
ALTER TABLE
Modify schema. Ex: ADD PRIMARY KEY. Relevance: Post-create changes.
Composite Key
Multi-column PK. Ex: AttendanceDate + RollNumber. Relevance: Advanced (2025).
Referential Integrity
FK matches PK. Ex: GUID refs GUARDIAN. Relevance: Data consistency.
FLOAT
Decimal numbers (4 bytes). Ex: GPA. Relevance: Precision.
BIGINT
Large integer (8 bytes). Ex: IDs > INT range. Relevance: Scalability.
mysql> Prompt
MySQL ready shell. Ex: Enter commands. Relevance: Interface.
-> Prompt
Multiline continuation. Ex: Long CREATE. Relevance: Syntax.
Data Definition Language (DDL)
Schema commands. Ex: CREATE/ALTER. Relevance: Structure.
Attribute
Column in table. Ex: RollNumber. Relevance: Schema part.
Relation
Table. Ex: STUDENT. Relevance: RDBMS term.
Degree
Number of columns. Ex: N in CREATE. Relevance: Structure.
NULL
Missing/unknown. Ex: Optional fields. Relevance: Constraints avoid.
Case Insensitive
SQL ignores case. Ex: NAME = name. Relevance: Flexibility.
Semicolon (;)
Statement end. Ex: CREATE ... ;. Relevance: Execution.
Query OK
Success message. Ex: After CREATE. Relevance: Feedback.
Empty Set
No results. Ex: SHOW TABLES initially. Relevance: Verify empty.
Referencing Table
Has FK. Ex: STUDENT. Relevance: Child table.
Referenced Table
Has PK. Ex: GUARDIAN. Relevance: Parent table.
Tip: Group by DDL/Types; examples for recall. Depth: Debates (e.g., CHAR vs VARCHAR). Errors: Forget ;. Interlinks: To Ch7 RDBMS. Advanced: JSON type. Real-Life: Attendance DB. Graphs: Type storage. Coherent: Evidence → Interpretation. For easy learning: Flashcard per term with example.
Text Book Questions & Answers - NCERT Exercises
Direct from chapter exercises (assumed based on content). Answers based on chapter, point-wise for exams.
Short Answer Questions
1. What is SQL? Why is it called a query language?
Answer:
SQL: Structured Query Language for RDBMS like MySQL.
Called query lang: Access/retrieve data; also defines/manipulates.
2. Differentiate between CHAR and VARCHAR.
Answer:
CHAR(n): Fixed length, padded spaces; ex: CHAR(10) for 'city' adds 6 spaces.
VARCHAR(n): Variable, exact length; ex: VARCHAR(30) for 'city' uses 4 chars.
3. List common SQL constraints with examples.
Answer:
NOT NULL: No missing (SName); UNIQUE: Distinct (GPhone); PRIMARY KEY: Unique ID (RollNumber); FOREIGN KEY: Ref PK (GUID).
Medium Answer Questions
4. Explain CREATE DATABASE and CREATE TABLE syntax.
Answer:
CREATE DATABASE: CREATE DATABASE dbname; ex: StudentAttendance.
CREATE TABLE: CREATE TABLE tablename(attr1 type constraint, ...); ex: STUDENT (RollNumber INT PRIMARY KEY).
5. How to add PRIMARY and FOREIGN KEY using ALTER?
Answer:
PRIMARY: ALTER TABLE table ADD PRIMARY KEY(col); ex: GUARDIAN(GUID).
FOREIGN: ALTER TABLE table ADD FOREIGN KEY(col) REFERENCES ref_table(ref_col); ex: STUDENT(GUID) REFERENCES GUARDIAN(GUID).
Long Answer Questions
6. Describe DESCRIBE command output for STUDENT table.
Answer:
Columns: Field (attr), Type (e.g., int/varchar(20)), Null (YES/NO), Key (PRI), Default, Extra.
Ex: RollNumber | int | NO | PRI | NULL | ; shows PK.
7. Why constraints ensure data reliability? Give examples from StudentAttendance.
Answer:
Restrictions for accuracy: NOT NULL prevents missing names; UNIQUE avoids duplicate phones; PK unique IDs; FK links tables (GUID to GUARDIAN).
Ex: Composite PK in ATTENDANCE prevents duplicate entries.
8. Write SQL to create GUARDIAN table with constraints.
Answer:
CREATE TABLE GUARDIAN(GUID CHAR(12) PRIMARY KEY, GName VARCHAR(20) NOT NULL, GPhone CHAR(10) UNIQUE, GAddress VARCHAR(30) NOT NULL);
9. Which command views all databases? How to check tables in current DB?
Answer:
SHOW DATABASES; Tables: SHOW TABLES; (Empty set if new).
10. What rules for writing SQL in MySQL? Explain multiline.
Answer:
Case-insensitive; end with ;. Multiline: No ; after first line, -> prompt, ; at end.
11. For StudentAttendance, identify PK/FK in each table.
Answer:
STUDENT: PK RollNumber, FK GUID; GUARDIAN: PK GUID; ATTENDANCE: Composite PK (Date, RollNumber), FK RollNumber.
12. How ALTER adds UNIQUE to GPhone?
Answer:
ALTER TABLE GUARDIAN ADD UNIQUE(GPhone); Ensures distinct phones.
Tip: Practice syntax (Q4/8); tables (Q11). Full marks: Code examples, explanations.
Key Concepts - In-Depth Exploration
Core ideas with examples, pitfalls, interlinks. Expanded: All concepts with steps/examples/pitfalls for easy learning. Depth: Debates, analysis. Table overflow fixed.
SQL Case Insensitivity
Steps: Write NAME or name - same. Ex: CREATE. Pitfall: OS case (Linux). Interlink: Rules. Depth: Flexibility.
Data Type Selection
Steps: 1. Expected data, 2. Size/ops. Ex: INT for RollNumber. Pitfall: Wrong size overflow. Interlink: Constraints. Depth: Efficiency.
Constraint Application
Steps: PK=NOT NULL+UNIQUE; FK match type. Ex: GUID CHAR(12). Pitfall: Mismatch errors. Interlink: ALTER. Depth: Integrity.
CREATE TABLE Schema
Steps: 1. Attr/type, 2. Constraints, 3. ; end. Ex: STUDENT. Pitfall: Forget comma. Interlink: DESCRIBE. Depth: Degree N.
FOREIGN KEY Rules
Steps: Ref table exists, types match. Ex: STUDENT to GUARDIAN. Pitfall: Size diff. Interlink: Referential. Depth: Relations.
Composite PK
Steps: ADD PRIMARY KEY(col1, col2). Ex: ATTENDANCE. Pitfall: Duplicates allowed otherwise. Interlink: ALTER. Depth: Multi-unique.
MySQL Prompts
Steps: mysql> ready, -> continue. Ex: Multiline CREATE. Pitfall: Early ; error. Interlink: Rules. Depth: Interface.
DESCRIBE Output
Steps: Field/Type/Null/Key/Default/Extra. Ex: PRI for PK. Pitfall: Ignore Key col. Interlink: Verify. Depth: Inspection.
ALTER Flexibility
Steps: ADD/MODIFY/DROP. Ex: Post-create PK. Pitfall: Data loss in DROP. Interlink: DDL. Depth: Evolution.
NULL Handling
Steps: Default allow, NOT NULL prevent. Ex: Optional GUID. Pitfall: PK can't NULL. Interlink: Constraints. Depth: Unknown data.
Database Selection
Steps: CREATE then USE. Ex: StudentAttendance. Pitfall: Wrong DB queries fail. Interlink: SHOW. Depth: Multi-DB mgmt.
Semicolon Termination
Steps: End every stmt. Ex: Query OK. Pitfall: No ; hangs. Interlink: Multiline. Depth: Execution.
Referential Integrity
Steps: FK enforces links. Ex: Delete orphan. Pitfall: Broken refs. Interlink: FK. Depth: Consistency.
Advanced: Integrity checks, type debates. Pitfalls: Syntax. Interlinks: To Ch7. Real: DB design. Depth: 13 concepts details. Examples: Code. Graphs: Type comparisons. Errors: Constraint order. Tips: Steps evidence; compare tables (Types/Constraints).
Historical Perspectives - Detailed Guide
Evolution of SQL; expanded with points; links to pioneers/debates. Added Codd's model, MySQL origins.
Relational Model (1970)
E.F. Codd: Logical/physical boundary (quote). Basis for RDBMS. Depth: Sharp boundary.
SQL Invention (1970s)
IBM SEQUEL (1974), renamed SQL. Standardized ANSI 1986. Depth: Query evolution.
MySQL Release (1995)
Swedish devs: Open-source RDBMS. Oracle acquisition 2010. Depth: Popularity boom.
Constraints Evolution (1980s)
PK/FK in standards. Integrity rules. Depth: Reliability focus.
DDL Standardization (1990s)
CREATE/ALTER in SQL-92. Portable across RDBMS. Depth: Schema mgmt.
Modern MySQL (2025)
JSON, window functions. Cloud integration. Depth: Big Data era.
Tip: Link to milestones. Depth: Reflexive evolution. Examples: Codd. Graphs: Timeline. Advanced: Post-2025 NoSQL hybrids. Easy: Bullets impacts.
Solved Examples - From Text with Simple Explanations
Expanded with evidence, calcs; focus on syntax, analysis. Added type selection, ALTER sequence.
Example 1: CREATE DATABASE & USE
Simple Explanation: Start DB.
Step 1: CREATE DATABASE StudentAttendance;
Step 2: USE StudentAttendance;
Step 3: SHOW TABLES; (Empty set)
Simple Way: Make → Switch → Check.
Example 2: CREATE TABLE STUDENT
Simple Explanation: Define schema.
Step 1: Identify types (INT/VARCHAR/DATE/CHAR).
Step 2: CREATE TABLE STUDENT(RollNumber INT PRIMARY KEY, SName VARCHAR(20) NOT NULL, ...);
Step 3: Query OK, 0 rows.
Simple Way: Columns → Types → Constraints.
Example 3: DESCRIBE STUDENT
Simple Explanation: Inspect structure.
Step 1: DESC STUDENT;
Step 2: Table: Field/Type/Null/Key (PRI for RollNumber).
Step 3: 4 rows in set.
Simple Way: DESC → Read keys/nulls.
Example 4: ALTER ADD PRIMARY KEY
Simple Explanation: Post-create PK.
Step 1: ALTER TABLE GUARDIAN ADD PRIMARY KEY(GUID);
Step 2: For composite: ADD PRIMARY KEY(Date, RollNumber);
Step 3: Query OK.
Simple Way: ALTER → ADD → KEY.
Example 5: ALTER ADD FOREIGN KEY
Simple Explanation: Link tables.
Step 1: Ensure ref table/PK exists.
Step 2: ALTER TABLE STUDENT ADD FOREIGN KEY(GUID) REFERENCES GUARDIAN(GUID);
Step 3: Types match (CHAR(12)).
Simple Way: ALTER → FOREIGN → REFERENCES.
Example 6: Multiline CREATE
Simple Explanation: Long statements.
Step 1: Enter first line (no ;).
Step 2: -> prompt continues.
Step 3: ; at end, Enter.
Simple Way: Line by line → ; finish.
Tip: Practice self-run; troubleshoot (e.g., type mismatch). Added for DDL, rules.
Interactive Quiz - Master SQL
10 MCQs in full sentences; 80%+ goal. Covers types, constraints, DDL.
Start Quiz
Quick Revision Notes & Mnemonics
Concise, easy-to-learn summaries for all subtopics. Structured in tables for quick scan: Key points, examples, mnemonics. Covers types, constraints, DDL. Bold key terms; short phrases for fast reading. Overflow fixed.
Subtopic
Key Points
Examples
Mnemonics/Tips
SQL Basics SQL : English-like, case-insens, ; end.RDBMS : MySQL etc. for relations.Multiline: -> prompt. MySQL shell (Fig 8.1); StudentAttendance.
SIC (SQL Insensitive Case). Tip: "Semicolon In Commands" – Always end.
Data Types CHAR (n): Fixed, padded.VARCHAR (n): Variable.INT /FLOAT/DATE: Numeric/date.CHAR(12) GUID; VARCHAR(20) SName (Table 8.1).
CVID (CHAR VARCHAR INT DATE). Tip: "Fixed Variable Numbers Dates" – Choose by need.
Constraints NOT NULL : Required.PRIMARY KEY : Unique ID.FOREIGN KEY : Ref PK; UNIQUE distinct.PK RollNumber; FK GUID (Table 8.2).
NPFU (Not Primary Foreign Unique). Tip: "No Primary For Unique" – Integrity layers.
DDL Commands CREATE DB/TABLE : New schema.USE/SHOW : Select/list.DESC : Structure view.CREATE TABLE STUDENT; DESC (Table 8.3-5).
CUD S (Create Use Desc Show). Tip: "Create Use Describe Show" – Build to check.
ALTER Table ADD PK/FK/UNIQUE.Rules: Match types, ref exists. Composite: Multi-col PK. ALTER ADD PRIMARY KEY(GUID); FOREIGN (Ex 8.1).
APF (Add Primary Foreign). Tip: "Alter Post-Create Fixes" – Modify safely.
Overall Tip: Use SIC-CVID-NPFU-CUD S-APF for full scan (5 mins). Flashcards: Front (term), Back (points + mnemonic). Print table for wall revision. Covers 100% chapter – easy for exams!
Key Terms & Processes - All Key
Expanded table 30+ rows; quick ref. Added advanced (e.g., Composite Key, Referential Integrity). Overflow fixed with word-break/overflow-wrap.
Term/Process Description Example Usage
Structured Query Language Query lang for RDBMS MySQL DDL/DML RDBMS Relation mgmt system Oracle Linking CHAR(n) Fixed string CHAR(12) GUID Padded VARCHAR(n) Variable string VARCHAR(20) SName Efficient INT Integer 4 bytes RollNumber Numeric DATE YYYY-MM-DD SDateofBirth Calendar NOT NULL No missing values SName Required PRIMARY KEY Unique row ID RollNumber Index FOREIGN KEY Ref to PK GUID in STUDENT Link UNIQUE Distinct values GPhone No dups DEFAULT Fallback value Status 'P' Optional CREATE DATABASE New DB StudentAttendance Init USE Select DB USE StudentAttendance Context SHOW TABLES List tables Empty set Verify CREATE TABLE Define schema STUDENT attrs Build DESCRIBE View structure DESC STUDENT Inspect ALTER TABLE Modify schema ADD KEY Update Composite Key Multi-col PK Date+RollNumber Advanced Referential Integrity FK consistency GUID match 2025 FLOAT Decimal 4 bytes GPA Precision BIGINT Large int 8 bytes Large IDs Scale mysql> Prompt Shell ready Enter cmds Interface -> Prompt Continue line Multiline Syntax Data Definition Language Schema cmds CREATE DDL Attribute Column RollNumber Schema Relation Table STUDENT RDBMS Degree Col count N attrs Structure NULL Missing data Optional Allow Case Insensitive Ignore case NAME=name Flex Semicolon Stmt end ; after Exec Query OK Success After CREATE Feedback Empty Set No results SHOW initial Empty Referencing Table Has FK STUDENT Child Referenced Table Has PK GUARDIAN Parent
Tip: Examples memory; sort subtopic. Easy: Table scan. Added 10 rows depth.
Processes Step-by-Step
Step-by-step breakdowns of core processes. Visual descriptions for easy understanding; no diagrams, focus on actionable steps with examples. Overflow fixed in tables.
Process 1: Install & Start MySQL
Step 1: Download from dev.mysql.com.
Step 2: Install, start service.
Step 3: mysql> prompt appears.
Step 4: Rules: ; end, case-insens.
Step 5: Help with ?.
Visual: Download → Install → Prompt.
Process 2: CREATE & USE Database
Step 1: CREATE DATABASE dbname;
Step 2: USE dbname;
Step 3: SHOW TABLES; (empty).
Step 4: SHOW DATABASES; verifies.
Step 5: Proceed to tables.
Visual: CREATE → USE → SHOW.
Process 3: CREATE Table with Types
Step 1: Plan attrs/types (e.g., INT/VARCHAR).
Step 2: Write CREATE TABLE (attr type, ...);
Step 3: Multiline if long ( -> ).
Step 4: ; end, Query OK.
Step 5: DESC to check.
Visual: Plan → Write → End → Verify.
Process 4: ALTER Add Constraints
Step 1: CREATE without, then ALTER.
Step 2: ADD PRIMARY KEY(col);
Step 3: For FK: ADD FOREIGN KEY(col) REFERENCES table(col);
Step 4: Match types/sizes.
Step 5: DESC verifies PRI/foreign.
Visual: Base → ADD PK → ADD FK → Check.
Process 5: Multiline Statement
Step 1: Start line1 (no ;).
Step 2: Enter → -> prompt.
Step 3: Continue lines.
Step 4: Last line + ; + Enter.
Step 5: Executes fully.
Visual: Line1 → -> Line2 → ; Done.
Process 6: Verify Structure
Step 1: DESC table;
Step 2: Read columns: Type/Key/Null.
Step 3: SHOW TABLES; lists.
Step 4: Query OK/Empty set feedback.
Step 5: Adjust with ALTER if needed.
Visual: DESC → Analyze → Adjust.
Tip: Follow steps like recipe; apply to ex (8.1). Easy: Number + example per step.
CBSE Class 11 kits Marks booster + cheatsheet: key concepts in 2 lines each, common traps 25 marks: Unit II, Ch 4–8 23 marks: Unit I, Ch 1–3 Common traps, corrected Conic table and standard values Graphs plotted from the book's own tables Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 23-mark block: Ch 1–4 17-mark block: Ch 5–7 Common traps, corrected 7 chapters: every solved-example result Every unit and dimension, listed Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 20-mark block: Ch 8–12 10-mark block: Oscillations and Waves Common traps, corrected 7 chapters: every solved-example result Sound, standing waves and beats covered Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 9 marks each: Atom and Thermodynamics Constants and formulas, with page numbers Common traps, corrected Periodic trends from the real data pH, buffers and solubility product Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 10 marks: Hydrocarbons Every reaction with reagent and condition Common traps that cost marks, listed IUPAC naming rules Oxidation-number rules and balancing Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 18 marks: Unit V, breathing to hormones 15 marks each: Units I and III Common traps, corrected Five kingdoms classification table Physiological numbers, with page numbers Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 44 marks: Unit 2, recording to depreciation Journal formats and special purpose books Traps from all seven chapters Bank reconciliation adjustments Depreciation formulas, book's worked figures Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each 12 exam traps, listed Five calculations the paper keeps asking Each adjustment: one entry, two effects Both formats: trading and P&L, balance sheet Yogita illustration solved line by line Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 20 marks: finance and MSME units 20 marks: internal and international trade Five comparison tables, insurance to retail Case cues for each chapter Common traps, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 15 marks: Ch 1–4, data to diagrams 7 chapters: every formula, worked numbers Common mistakes, corrected Book exercise answers included Part C project route Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 14 marks: Production and Costs, Unit 6 8 marks: Market Equilibrium, Unit 7 Common traps, corrected PPF, TU–MU, MRS and cost table drawn Demand and supply schedules from the book Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 20 marks: Empires section 20 marks: Changing Cultural Traditions 15 marks: Paths to Modernisation, Japan 5 marks: map work on the book's maps Common traps, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 8 marks: Climate unit, Ch 7–10 5 marks: map work, covered 4 marks: ocean data as charts, Unit V Heat budget and five air layers as charts Common traps, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 12 marks: Climate, Vegetation (Unit III) Full CBSE map-work list, chapter by chapter Indus, Ganga, Brahmaputra river systems Monsoon mechanism, onset and four seasons Common traps, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each 4 marks: Map Scale, conversions worked 4 marks: Latitude, Longitude and Time 4 marks: Topographical Maps, contours 5 marks: practical file and viva Conical and Mercator's construction steps Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 8 marks together: Citizenship, Nationalism 6 marks each: Social Justice, Secularism 8 chapters: thinkers and a timeline Liberty, equality, justice side by side Common traps, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each 12 marks: Executive to Judiciary Constitution-making timeline Institution-by-institution comparisons 6 marks: elections, FPTP, PR, reserved seats Fundamental Rights and Directive Principles Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 10 marks each: Units 1 and 2 20 marks: project work, covered Tables: groups, stratification, marriage Every thinker and concept of Chapters 1–4 Common traps, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 12 marks each: Units 7, 9 and 10 7 thinkers: dates, works, examples Four Indian sociologists, in tables Ideal type, bureaucracy, division of labour Common traps, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each 11 marks each: Units I and III 9 marks: Learning, Unit V 8 marks each: Perception and Memory Every school with its founder Comparisons examiners ask for Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 8 marks: note-making and summary 5 poems compared, cross-text themes Common traps, corrected Poetic devices with short quotes Grammar each chapter teaches Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 4-, 3- and 6-mark answers: how to write them Plot timeline for every text Common traps, corrected Every character, with evidence Cross-text themes, side by side Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps Poetic forms and rhyme schemes Devices with short quotes Common traps, corrected Essay arguments, essay by essay Words each chapter teaches Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each 16 writers placed on one timeline 60- and 40-word answer frames 8 काव्य पाठ: प्रतीक and काव्य-सौंदर्य Lines worth remembering, with page refs 12 common mistakes, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each 10 marks (2 × 5): answer frames 5-mark answers in about 60 words 4 lessons: argument, events, characters Lines worth remembering, by page 12 common mistakes, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each 16 writers placed on one timeline 40-word and व्याख्या answer frames 8 काव्य पाठ: प्रतीक, उपमान, काव्य-सौंदर्य Lines worth remembering, with page refs 12 common mistakes, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each 5-mark, 100-word answer frames 9 exercise questions: आवारा मसीहा 7 exercise questions: हुसैन की कहानी Life events linked to the works 12 common mistakes, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each 20 marks: grammar, from text words Sandhi, pratyaya and lakar examples Anvaya and bhavartha answer method Source text and author for every lesson 10 common errors, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each 20 marks: grammar, भाग ग, from the text 10 marks: history of literature Sandhi, samasa, pratyaya, upapada examples Source text and author for every lesson Common errors, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each Author, genre and characters per lesson Couplets explained: Insha and Fani ghazals Grammar for Section A Letter and advertisement formats 10 common mistakes, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each 38 marks: the answer frame 13 genres, each introduced 18 writers and poets: dates and works Literary devices (صنعتیں) and key words Common mistakes, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each 10 marks: literary forms, covered 5 geets, each with its poet Nazm defined, with its four kinds Answer points for the book's questions Common mistakes, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 15 marks: Unit 3, society, law and ethics 10 marks: Unit 1, number-system conversions Common traps that cost marks, listed Truth tables for Boolean logic String, list and dictionary methods Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 25 marks: Python, lists, NumPy (Unit 2) 10 marks: Computer System (Unit 1) Common traps, corrected Every list and dictionary method, with output SQL queries re-run on the book's tables Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 23 marks: Unit II 15 marks: Unit III, health and hygiene Common traps, corrected Five food groups, RDA and the pyramid Nine fibres and the burning test Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each 15 marks each: Childhood and Adulthood units RDAs and diet quantities by age Vaccine ages Budget steps and investment principles Stain-removal methods Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each 15 marks each: the two theory units What to write when asked to appreciate Bharhut, Sanchi and the cave sites Temple architecture: how a temple is built Bronzes and Indo-Islamic buildings Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 20 marks each: Units II and III Enzyme kinetics and bioenergetics Common traps, corrected Mendel-to-operon genetics Tables and numbers, each with its page Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each, common traps 15 marks: language and literature 14 marks: the nine darśanas Common traps, corrected 13 marks: astronomy in India 4 chapters, each with answer frames Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each Frames for news, interview and review Inverted pyramid and the six ककार Play-writing frame Translation rules, with solved examples Common mistakes, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each 50 marks: games and sports strand 25 marks: health and fitness strand Eight team games, side by side Fitness tests, norms and formulas Yoga asanas for wellness Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each 22 श्रुतियाँ and 10 थाट, defined बिहाग, भीमपलासी, भैरवी with बंदिश notation तीनताल, एकताल, चौताल: ठाह, दुगुन, चौगुन तानसेन, भातखंडे, पलुस्कर profiled 12 common mistakes, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each वादी-संवादी, पकड़ and बंदिश for each राग तीनताल, एकताल, चौताल: ठाह, दुगुन, चौगुन तानसेन, भातखंडे, पलुस्कर profiled Four classes of instruments, तानपुरा, सितार 12 common mistakes, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Marks booster + cheatsheet: key concepts in 2 lines each 6 marks each: all five units ठाह, दुगुन, तिगुन, चौगुन written out 14 artists with dates कुदऊ सिंह and नाना पानसे: two lives 14 common mistakes, corrected Page 1 free about 8 min read , Full kit about 55 min read ₹159
Read page 1 free Get the kit Get the kit One payment · instant PDF · ₹159 View details Get alerts for CBSE Class 11 Annual Assessment
Dates, results and cutoffs, by email when they are announced. Free.
Google, Apple, or a code to your phone or email. It is saved to your account.
This chapter is part of the CBSE Class 11 Annual Assessment Board Examination Explore every chapter — summary, notes, extra questions & MCQ quizzes Preparing for CBSE Class 11 Annual Assessment? Students also sit JEE is set on the Class 11 and 12 Physics, Chemistry and Maths syllabus; students prepare for boards and JEE together.
Tests are played signed in — sign in (free, 10 seconds) so your attempts, rank and XP are saved to you #1
Discovering Tut: the Saga Continues
Start here
#2
#3
Constitution: Why and How?
#4
#5
#6
#7
#8
Methods of Enquiry in Psychology
#9
#10
An Empire Across Three Continents
#11
#12
The Summer of the Beautiful White Horse
#13
#14
#15
We're Not Afraid to Die... if We Can All Be Together
#16
#17
Election and Representation
#18
Political Theory: An Introduction
#19
#20
Biological Classification
#21
Motion in a Straight Line
#22
Accountancy (Class 11) Practice Quiz | CBSE Class 11 Annual Assessment
#23
Sets and Venn Operations Fundamentals — Free CBSE Class 11 Annual Assessment Quiz
#24
#25
#26
#27
Rights in the Indian Constitution
#28
#29
#30
#31
#32
Changing Cultural Traditions
#33
#34
#35
#36
#37
Private, Public and Global Enterprises
#38
Depreciation, Provisions and Reserves
#39
Introduction to Accounting
#40
Cell Cycle and Cell Division
#41
#42
Anatomy of Flowering Plants
#43
Organic Chemistry – Some Basic Principles and Techniques
#44
#45
#46
#47
#48
#49
#50
#51
#52
#53
#54
#55
The Ailing Planet: the Green Movement's Role
#56
#57
#58
#59
Sensory, Attentional and Perceptual Processes
#60
#61
#62
Introducing Western Sociologists
#63
#64
Social Change and Social Order in Rural and Urban Society
#65
Social Structure, Stratification and Social Processes in Society
#66
Doing Sociology: Research Methods
#67
Culture and Socialisation
#68
Understanding Social Institutions
#69
Terms, Concepts and Their Use in Sociology
#70
#71
The Philosophy of the Constitution
#72
Constitution as a Living Document
#73
#74
#75
#76
#77
#78
#79
#80
#81
#82
Natural Hazards and Disasters
#83
#84
#85
#86
Structure and Physiography
#87
Biodiversity and Conservation
#88
#89
#90
World Climate and Climate Change
#91
Atmospheric Circulation and Weather Systems
#92
Solar Radiation, Heat Balance and Temperature
#93
Composition and Structure of Atmosphere
#94
Landforms and their Evolution
#95
#96
Distribution of Oceans and Continents
#97
#98
The Origin and Evolution of the Earth
#99
Geography as a Discipline
#100
Displacing Indigenous Peoples
#101
#102
Comparative Development Experiences of India and its Neighbours
#103
Environment and Sustainable Development
#104
Employment: Growth, Informalisation and Other Issues
#105
#106
Human Capital Formation in India
#107
Liberalisation, Privatisation and Globalisation: An Appraisal
#108
Indian Economy on the Eve of Independence
#109
#110
#111
#112
Measures of Central Tendency
#113
#114
#115
#116
#117
MSME and Business Entrepreneurship
#118
Sources of Business Finance
#119
#120
Social Responsibilities of Business and Business Ethics
#121
Emerging Modes of Business
#122
#123
Forms of Business Organisation
#124
Business, Trade and Commerce
#125
Financial Statements - II
#126
#127
Trial Balance and Rectification of Errors
#128
Bank Reconciliation Statement
#129
Recording of Transactions - II
#130
Recording of Transactions - I
#131
Theory Base of Accounting
#132
#133
#134
#135
Introduction to Three Dimensional Geometry
#136
#137
#138
#139
#140
Permutations and Combinations
#141
#142
Complex Numbers and Quadratic Equations
#143
#144
#145
Chemical Coordination and Integration
#146
Neural Control and Coordination
#147
#148
Excretory Products and their Elimination
#149
Body Fluids and Circulation
#150
Breathing and Exchange of Gases
#151
Plant Growth and Development
#152
#153
Photosynthesis in Higher Plants
#154
#155
Structural Organisation in Animals
#156
Morphology of Flowering Plants
#157
#158
#159
Chemical Bonding and Molecular Structure
#160
Classification of Elements and Periodicity in Properties
#161
Some Basic Concepts of Chemistry
#162
#163
#164
#165
#166
Thermal Properties of Matter
#167
Mechanical Properties of Fluids
#168
Mechanical Properties of Solids
#169
#170
Systems of Particles and Rotational Motion
#171
#172
#173
Business Studies (Class 11) Practice Quiz | CBSE Class 11 Annual Assessment
#174
Economics (Class 11) Practice Quiz | CBSE Class 11 Annual Assessment
#175
Humanities Subjects Practice Quiz | CBSE Class 11 Annual Assessment
#176
Motion in a Straight Line Practice Quiz | CBSE Class 11 Annual Assessment
#177
Thermodynamic Processes and Laws Advanced Challenge | CBSE Class 11 Annual Assessment
More on CBSE Class 11 Annual Assessment20 guides Tuples and Dictionaries – NCERT Class 11 Computer Science Chapter 10 – Tuple Operations and Dictionary Handling in Python Strings – NCERT Class 11 Computer Science Chapter 8 – String Operations, Traversal, and Methods in Python Getting Started with Python – NCERT Class 11 Computer Science Chapter 5 – Basics, Data Types, Operators, and Debugging Functions – NCERT Class 11 Computer Science Chapter 7 – Defining, Calling, and Understanding Functions in Python Complete Summary and Solutions for Emerging Trends – NCERT Class XI Informatics Practices, Chapter 2 – Explanation, Questions, Answers Mathematical Modelling – NCERT Class 11 Mathematics Appendix 2 – Concepts, Importance, and Applications in Real-world Problems Complete Summary and Solutions for Database Concepts – NCERT Class XI Informatics Practices, Chapter 7 – Explanation, Questions, Answers Encoding Schemes and Number System – NCERT Class 11 Computer Science Chapter 2 – ASCII, ISCII, UNICODE, Binary, Octal, Decimal, Hexadecimal Complete Summary and Solutions for Brief Overview of Python – NCERT Class XI Informatics Practices, Chapter 3 – Explanation, Questions, Answers Complete Summary and Solutions for Computer System – NCERT Class XI Informatics Practices, Chapter 1 – Explanation, Questions, Answers Introduction to Problem Solving – NCERT Class 11 Computer Science Chapter 4 – Algorithms, Flowcharts, Pseudocode, and Control Structures Flow of Control – NCERT Class 11 Computer Science Chapter 6 – Conditional and Looping Constructs in Python Alerts and Updates for CBSE Class 11 Annual Assessment Complete Summary and Solutions for Adventure Sports – Health and Physical Education Textbook for Class XI, Chapter 11 – Explanation, Questions, Answers Complete Summary and Solutions for Tournaments and Competitions – Health and Physical Education Textbook for Class XI, Chapter 10 – Explanation, Questions, Answers Complete Summary and Solutions for Measurement and Evaluation – Health and Physical Education Textbook for Class XI, Chapter 9 – Explanation, Questions, Answers Complete Summary and Solutions for Health Related Physical Fitness – Health and Physical Education Textbook for Class XI, Chapter 8 – Explanation, Questions, Answers Complete Summary and Solutions for Safety and Security – Health and Physical Education Textbook for Class XI, Chapter 7 – Explanation, Questions, Answers Complete Summary and Solutions for Yoga and Its Relevance in the Modern Times – Health and Physical Education Textbook for Class XI, Chapter 6 – Explanation, Questions, Answers Complete Summary and Solutions for Team Games – Health and Physical Education Textbook for Class XI, Chapter 5 – Explanation, Questions, Answers Notebook backup + AI Save your notes. Revise with AI. Learn more → Share this article
