ProSyllabus Journal

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 10 months agoNCERT · 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

Complete Summary and Solutions for Introduction to Structured Query Language (SQL) – NCERT Class XI Informatics Practices, Chapter 8 – Explanation, Questions, Answers

Introduction to Structured Query Language (SQL) - Class 11 Informatics Practices Chapter 8 Ultimate Study Guide 2025

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).

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.

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.

This article has been published in CBSE Class 11 Annual Assessment. Explore everything related to it here.

Recommended BooksSee All →

35% OFF

Bhagvad Gita – The Story Way for Students & Parents

₹194M.R.P. ₹299

Buy on Amazon

34% OFF

You Can – The Classic Guide to Self-Belief & Personal Growth

₹99M.R.P. ₹149

Buy on Amazon

Atomic Habits – Tiny Changes, Remarkable Results

₹521

Buy on Amazon

As an Amazon Associate, ProSyllabus earns from qualifying purchases. Prices shown are subject to change.

This chapter is part of the CBSE Class 11 Annual Assessment Board ExaminationExplore every chapter — summary, notes, extra questions & MCQ quizzes

Practice Quiz

Test your CBSE Class 11 Annual Assessment prep

Dual AI-verified questions Real exam pattern 1 free quiz every month, then ₹9 per quiz — or a monthly plan

What is Psychology?

Start here

Psychology 10 Qs · ~10 min