Database Query using SQL Notes (English + Simple Hindi)

English

Database: An organized collection of interrelated data.

DBMS (Database Management System): Software to create, manage, and manipulate databases (e.g., MySQL, Oracle).

RDBMS: Relational DBMS stores data in tables (relations) linked by keys.

SQL (Structured Query Language): Standard language for communicating with RDBMS. Used to define, manipulate, and query data.

Key terms: Table/Relation, Row/Tuple, Column/Attribute, Degree (no. of columns), Cardinality (no. of rows).

English

Common SQL data types used in Class XI:

• INT / INTEGER – whole numbers
• DECIMAL(p,s) – exact numeric with precision p, scale s
• CHAR(n) – fixed-length character string
• VARCHAR(n) – variable-length character string
• DATE – date (YYYY-MM-DD)
• BOOLEAN – TRUE or FALSE

English

CREATE TABLE defines a new table with column names, data types, and constraints.

English

• PRIMARY KEY: Unique + NOT NULL identifier.
• FOREIGN KEY: Links to PRIMARY KEY of another table, enforces referential integrity.
• NOT NULL: Column cannot be empty.
• UNIQUE: All values must be distinct.
• DEFAULT: Sets a default value if none provided.
• CHECK: Validates condition on data.

English

ALTER TABLE is used to add, modify, or delete columns and constraints in an existing table.

English

DROP TABLE permanently removes the table structure and all its data.

TRUNCATE deletes all rows but keeps the table structure (faster, can't be rolled back in some DBs).

English

INSERT INTO adds new rows to a table. You can specify columns or rely on their order.

English

UPDATE modifies existing rows. DELETE removes rows. Always use WHERE clause carefully!

English

The most important SQL command. Retrieves data from one or more tables. Syntax:

SELECT [DISTINCT] column1, column2... FROM table [WHERE condition] [ORDER BY ...];

English

Filters rows using conditions. Operators: =, <>, <, >, <=, >=, BETWEEN, IN, LIKE, IS NULL, AND, OR, NOT.

English

ORDER BY sorts the result set. Default ascending (ASC), DESC for descending.

English

Operate on a set of rows, return a single value: COUNT(), SUM(), AVG(), MAX(), MIN().

English

GROUP BY groups rows with same values. HAVING filters groups (like WHERE for groups).

English

Cartesian Product: every row of table1 with every row of table2 (no join condition).

Equi-Join / Inner Join: match rows where common column values are equal.

Natural Join: automatically joins on columns with same name and domain.

English

TCL (Transaction Control): COMMIT saves, ROLLBACK undoes, SAVEPOINT sets a marker.

Views: Virtual tables based on a SELECT query. CREATE VIEW view_name AS SELECT ...;

English

SQL provides several built-in numeric functions to perform mathematical operations directly inside queries. The three most commonly used in the curriculum are POWER(), ROUND(), and MOD(). These functions can be used in SELECT, WHERE, ORDER BY, and even with UPDATE statements.

• POWER(base, exponent) – returns base^exponent. Both arguments are numeric; the exponent can be negative or fractional.
• ROUND(number, decimal_places) – rounds a number to the specified number of decimal places. If decimal_places is negative, it rounds to the left of the decimal point (tens, hundreds, …).
• MOD(dividend, divisor) – returns the remainder after dividing dividend by divisor. It behaves like the % operator in many languages.

All three functions can be nested or combined with other expressions.

Real-world Use Cases

• POWER: Calculating compound interest (P*(1+r/100)ⁿ), area/volume formulas, scientific computations.
• ROUND: Formatting output for reports (making currency values look clean), adjusting sensor data, removing unnecessary decimal places.
• MOD: Finding even/odd rows, grouping items into batches, checking divisibility, distributing tasks in round‑robin fashion.

English

SQL provides powerful string manipulation functions that let you change case, extract parts of a string, find substrings, and clean up unwanted spaces – all inside your queries. These are extremely useful for data cleaning, reporting, and formatting output.

• UPPER(text) / UCASE(text) – Converts all letters to uppercase.
• LOWER(text) / LCASE(text) – Converts all letters to lowercase.
• MID(text, start, length) / SUBSTRING(text, start, length) / SUBSTR(text, start, length) – Extracts a portion of the string. start is usually 1‑based (first character = 1).
• LENGTH(text) – Returns the number of characters (or bytes, depending on DBMS) in the string.
• LEFT(text, n) – Returns the first n characters.
• RIGHT(text, n) – Returns the last n characters.
• INSTR(text, substring) – Returns the position of the first occurrence of substring within text. Returns 0 if not found (MySQL) or 0/error depending on DBMS.
• LTRIM(text) – Removes leading (left) spaces.
• RTRIM(text) – Removes trailing (right) spaces.
• TRIM(text) – Removes both leading and trailing spaces (equivalent to LTRIM(RTRIM(text))).

Note: In many SQL dialects (MySQL, MariaDB) SUBSTRING and MID are identical. Some systems also support SUBSTR. The start position often begins at 1, not 0.

Real-world Use Cases

• UPPER/LOWER: Standardising email addresses or usernames (e.g., storing all emails in lowercase).
• MID/SUBSTRING: Extracting area codes from phone numbers, extracting initials from names, truncating long text for previews.
• LENGTH: Validating input length (e.g., password must be >= 8 characters).
• LEFT/RIGHT: Getting file extensions (RIGHT(filename, 3)), separating first name from full name.
• INSTR: Splitting data based on a delimiter (like '@' in email or comma in address).
• TRIM/LTRIM/RTRIM: Cleaning user input or imported data where extra spaces cause mismatches.

English

SQL provides built‑in date functions to work with date and time values. They help you extract specific parts (year, month, day) from a date, get the current system date/time, and format dates for reports.

• NOW() – Returns the current date and time (system clock).
• DATE(expr) – Extracts only the date portion from a datetime expression (leaves out the time).
• MONTH(date) – Returns the month number (1 to 12) from a date.
• MONTHNAME(date) – Returns the full month name (e.g., 'January', 'February').
• YEAR(date) – Returns the four‑digit year.
• DAY(date) – Returns the day of the month (1 to 31).
• DAYNAME(date) – Returns the weekday name (e.g., 'Monday', 'Tuesday').

All these functions can be used in SELECT, WHERE, GROUP BY, etc. They accept dates stored in DATE or DATETIME columns, or date literals in 'YYYY-MM-DD' format.

Real-world Use Cases

• NOW() / DATE(): Storing registration timestamps, generating daily reports, filtering records for "today".
• YEAR() / MONTH() / DAY(): Grouping sales data by year or month, calculating age from date of birth, sorting by fiscal year.
• MONTHNAME() / DAYNAME(): Creating human‑readable reports (e.g., "Sales on Monday are highest"), displaying month names on dashboards.

All these functions are read‑only – they don't change stored data, only affect query output. They are heavily used in WHERE and GROUP BY clauses.

English

Aggregate functions perform a calculation on a set of rows and return a single value. They are extremely useful for summarizing data – finding totals, averages, extremes, and counts. These functions are often used with GROUP BY but can also be used on the entire table.

• MAX(column) – Returns the maximum value in the column.
• MIN(column) – Returns the minimum value in the column.
• AVG(column) – Returns the average (mean) of all values. Works on numeric columns only.
• SUM(column) – Returns the total sum of all values in a numeric column.
• COUNT(column) – Returns the number of non‑NULL values in the column.
• COUNT(*) – Returns the total number of rows in the table (including rows with NULLs).

All functions except COUNT(*) ignore NULL values.

Important Differences

• COUNT(column) counts only non‑NULL entries; COUNT(*) counts every row regardless of NULLs.
• SUM() and AVG() work only on numeric data; using them on text columns will cause an error.
• All aggregate functions can be combined with GROUP BY to calculate statistics per group.

English

GROUP BY, HAVING and ORDER BY are three powerful clauses used to organise, filter, and sort the output of SELECT queries. They often appear together and must be written in a specific order.

Correct clause order:

SELECT … FROM … WHERE … GROUP BY … HAVING … ORDER BY …

• GROUP BY – Groups rows that have the same values in specified columns. Always used with aggregate functions (like COUNT, SUM, AVG, MAX, MIN).
• HAVING – Filters the groups formed by GROUP BY. It is like WHERE but works on groups, not individual rows. Aggregate functions can be used in HAVING.
• ORDER BY – Sorts the final result set in ascending (ASC) or descending (DESC) order. It can sort by one or more columns.

Key Differences: WHERE vs HAVING

English

In a relational database, data is often split across multiple tables to avoid duplication. When you need to fetch combined information from two (or more) tables, you use a JOIN. The most common type is the Equi‑Join – a join where the matching condition uses the equality operator (=), typically linking a Foreign Key in one table to the Primary Key in another table.

There are two ways to write an equi‑join in SQL:

• Implicit Join (old style): List all table names in the FROM clause, then specify the equality condition in the WHERE clause.
• Explicit Join (ANSI style): Use the JOIN ... ON keyword. This is more readable and separates join conditions from filtering conditions.

Without a join condition, the database performs a Cartesian Product (every row of table1 combined with every row of table2), which is rarely useful.

Equi‑Join vs Other Joins

• Natural Join: Automatically matches columns with the same name and domain. No ON clause needed, but can be dangerous if unexpected matching columns exist.
• Left/Right Outer Join: Returns all rows from one table even if no match in the other (fills with NULLs). Not a pure equi‑join.
• Cartesian Product: Join without any condition – just cross product of all rows.

The explicit JOIN ON syntax is recommended because it clearly separates the join logic from the filtering logic (WHERE).

English

A library in Python is a collection of pre‑written code (functions, classes, modules) that you can reuse in your programs. Libraries save time and effort – instead of writing everything from scratch, you simply import a library and use its features.

Key points:

• Python comes with a rich Standard Library – modules for math, date/time, file handling, etc. that are available as soon as you install Python.
• Thousands of third‑party libraries can be installed using pip (Python's package manager), e.g. NumPy, Pandas, Matplotlib.
• You import a library with the import statement, after which you can use its contents.
• Common ways to import: import math, from math import sqrt, import numpy as np.

Commonly Used Built‑in Libraries

• math – mathematical functions (sqrt, sin, cos, pi, e, ceil, floor).
• random – generate random numbers, shuffle lists, pick random items.
• statistics – mean, median, mode, standard deviation.
• datetime – work with dates and times.
• os – interact with the operating system (file paths, directories).
• string – common string operations and constants.

Installing Third‑party Libraries

Outside the standard library, you often need extra libraries. You install them using pip (Python package installer) from the terminal/command prompt.

Example: pip install matplotlib or python -m pip install pandas.

After installation, import them just like built‑in libraries.

English

Pandas and Matplotlib are two of the most popular Python libraries for data analysis and visualization.

• Pandas: A powerful library for working with structured data (tables). It provides two main data structures – Series (1D) and DataFrame (2D) – and hundreds of functions to read, clean, transform, and analyse data.
• Matplotlib: A plotting library that creates static, animated, and interactive visualizations. Its pyplot module makes it easy to generate line charts, bar graphs, histograms, scatter plots, and more.

Together they are the backbone of data science in Python: Pandas prepares the data, and Matplotlib visualizes it.

Pandas Basics

Series: A one‑dimensional labelled array (like a column in a spreadsheet).

DataFrame: A two‑dimensional table with rows and columns (like a spreadsheet or SQL table).

Matplotlib Basics

The pyplot module (usually imported as plt) provides functions to create figures step by step: plot(), bar(), scatter(), hist(), pie(). You can then label axes, add a title, and display or save the chart.

Real-world Workflow

A typical data analysis task: read data with Pandas → clean and summarize → create a plot with Matplotlib to communicate insights.

Example: Read a CSV of exam results, calculate city‑wise average marks, then plot them as a bar chart.

English

Pandas provides two fundamental data structures that are used for data manipulation and analysis:

• Series: A one‑dimensional labelled array that can hold data of any type (integers, strings, floats, Python objects, etc.). It is similar to a column in an Excel sheet or a dictionary with ordered keys.
• DataFrame: A two‑dimensional labelled data structure with columns of potentially different types. It is like a spreadsheet, a SQL table, or a dictionary of Series objects. It is the most widely used Pandas object.

Both Series and DataFrames are built on top of NumPy arrays and provide a rich set of attributes and methods for data handling.

Series – Creation & Attributes

A Series can be created from a list, array, dictionary, or scalar value. The index parameter assigns labels to each element (defaults to 0,1,2…).

Important attributes: values, index, dtype, size, ndim, name.

DataFrame – Creation & Attributes

A DataFrame can be created from a dictionary of lists/arrays, a list of dictionaries, a 2D NumPy array, or by reading external files (CSV, Excel, etc.).

Important attributes: shape, dtypes, columns, index, values, size, ndim (always 2), info(), describe(), head(), tail().

Series vs DataFrame: Key Differences

Real-world Relationship

Think of a DataFrame as a collection of Series objects sharing the same index. Each column in a DataFrame is a Series. Operations like selecting a column (df['column']) return a Series. You can also create a Series from a DataFrame row using .iloc[] or .loc[].

English

A Pandas Series is a one‑dimensional labelled array. It can be created from various data sources. The three most important ways are:

• From ndarray (NumPy array) – If you have a NumPy array, pass it directly to pd.Series(). The index will be automatically generated (0, 1, 2, …) unless you supply a custom one.
• From dictionary – The keys of the dictionary become the index labels, and the values become the Series data. The order of elements follows the order of insertion (Python 3.7+).
• From scalar value – When you pass a single scalar value, you must also provide an index. The scalar value is repeated for each entry in the index. This is useful for creating a Series of constants.

In all cases, you can control the index with the index parameter, set a name, and specify a dtype if needed.

1. Creation from ndarray (NumPy array)

First import NumPy and Pandas. Create a NumPy array using np.array(), then pass it to pd.Series().

2. Creation from Dictionary

Pass a Python dictionary directly to pd.Series(). The keys become the index, values become the data. If you provide an index argument, the Series will be reindexed to match that index (missing keys result in NaN).

3. Creation from Scalar Value

A scalar is a single value (number, string, boolean). To create a Series, you must provide an index. The scalar will be broadcast to every entry. This is handy for initialising a constant column.

Quick Comparison

English

Once you create a Pandas Series, you can perform many operations directly – just like you would with a single column of data. This section covers mathematical operations (vectorized arithmetic), head() & tail() to quickly inspect data, and selection, indexing & slicing to extract elements by label or position.

1. Mathematical Operations

Pandas Series supports vectorized operations – you can add, subtract, multiply, divide, and apply functions to every element at once without loops. When two Series are involved, operations align by index (missing values become NaN).

• Scalar operations: s + 5, s * 2, s ** 2 (square), s / 10
• Series‑Series operations: s1 + s2, s1 * s2 (matching indexes are added/multiplied)
• Mathematical functions: np.sqrt(s), np.log(s), s.abs(), s.round(2)
• Statistical methods: s.sum(), s.mean(), s.max(), s.min(), s.std()

2. head() and tail() Functions

These are quick‑inspection methods to view the first or last few rows of a Series (or DataFrame). By default they return 5 rows. They don't change the original data.

3. Selection, Indexing & Slicing

You can access elements in a Series using label‑based indexing (.loc[]), position‑based indexing (.iloc[]), or the common [] operator which can mix both but may be ambiguous.

• By label: s['a'], s[['a','c']], slice s['a':'c'] (both inclusive with labels).
• By position: s.iloc[0], s.iloc[[0,2]], slice s.iloc[0:3] (excludes stop).
• Boolean indexing: s[s > 80] returns values where condition is True.
• Using .loc: s.loc['b'] explicitly label‑based.

Note: Slicing with [] on a Series can behave differently: when the index is integer‑based it's position‑based, otherwise label‑based. Using .loc and .iloc removes confusion.

English

A DataFrame is a two‑dimensional labelled data structure. Two common ways to create one are:

• From a dictionary of Series: Each key becomes a column name, and the corresponding Series provides the data for that column. All Series are aligned by their index labels – missing values are filled with NaN.
• From a list of dictionaries: Each dictionary in the list represents one row. Keys become column names, and if a key is missing in a particular row, that cell gets NaN.

Both methods let you explicitly set the index and columns parameters if needed.

1. Creating DataFrame from Dictionary of Series

When you pass a dictionary of Series to pd.DataFrame(), each Series becomes a column. The index of the resulting DataFrame is the union of all individual Series indexes. Alignment happens automatically: wherever a Series lacks a value, NaN is inserted.

You can also provide an explicit index to select a specific set of row labels, or columns to order/select columns.

2. Creating DataFrame from List of Dictionaries

Each dictionary in the list becomes one row. Keys are automatically converted to column names. If a key is missing in a particular dictionary, the cell is set to NaN.

The order of rows in the DataFrame follows the order of dictionaries in the list. You can also supply an index to label the rows explicitly.

Quick Comparison

English

Once you have a Pandas DataFrame, you need to know how to read data from external files (CSV, text), display it effectively, iterate through it if necessary, and perform essential row/column operations – adding, selecting, deleting, and renaming. This section covers all these core skills.

• Text/CSV files – Use pd.read_csv() or pd.read_table() to load data.
• Display – Use head(), tail(), info(), and just printing the DataFrame.
• Iteration – Usually you don’t need loops in Pandas, but when required, iterrows() and itertuples() are the tools.
• Row/Column operations – adding new columns/rows, selecting subsets, dropping unwanted data, and renaming labels.

1. Reading Text/CSV Files

pd.read_csv() is the most common way. For text files with different separators (e.g., tab), use pd.read_table() or pass sep='\t' to read_csv(). Useful parameters:

• filepath – path to the file
• sep – delimiter (default comma for CSV)
• header – row number for column names (default 0)
• index_col – column(s) to use as row index
• nrows – number of rows to read
• skiprows – rows to skip at the start

2. Displaying Data

To inspect a DataFrame quickly:

• df.head(n) – first n rows (default 5)
• df.tail(n) – last n rows
• print(df) – show entire DataFrame (careful with large data)
• df.info() – summary of columns, types, non‑null counts
• df.describe() – statistical summary for numeric columns

3. Iteration Over Data

Pandas is designed for vectorized operations – avoid loops when possible. But when necessary:

• for index, row in df.iterrows(): – yields index and Series for each row (slow, copies data).
• for row in df.itertuples(): – yields namedtuples, faster and more memory efficient.
• Iterate over columns: for col_name, series in df.iteritems(): (or just for col in df.columns).

4. Operations on Rows & Columns

You can add, select, delete, and rename rows and columns easily.

English

When working with DataFrames (and Series), two essential skills are quickly inspecting the data using head() and tail(), and precisely extracting rows or columns using label‑based indexing. These tools help you explore data and select exactly what you need without writing complicated loops.

• head(n) – returns the first n rows (default 5). Great for seeing the structure and sample data.
• tail(n) – returns the last n rows. Useful for checking the end of a file or most recent entries.
• Label‑based indexing – using df.loc[row_labels, column_labels] or the direct df[column_label] / df[[col1, col2]] to select data by index and column names instead of numeric positions.

These operations never modify the original DataFrame; they return a view or copy that you can assign to a new variable or use directly.

head() and tail() – Quick Data Glance

Both head() and tail() work exactly the same for DataFrames and Series. They take a single argument n (default 5) and return that many rows from the top or bottom.

Label‑based Indexing

Label‑based indexing uses the actual index labels (row names) and column names to retrieve data. The primary tool is .loc[], but the simpler [] operator also works for selecting columns.

• Single column – df['column_name'] returns a Series.
• Multiple columns – df[['col1','col2']] returns a DataFrame.
• Rows by label – df.loc['row_label'] (single row as Series) or df.loc[['r1','r2']] (multiple rows).
• Rows and columns – df.loc[['r1','r2'], ['col1','col2']].
• Slice with labels – df.loc['r1':'r3'] (inclusive of both ends).
• Boolean indexing with labels – df.loc[df['Marks'] > 85, ['Name','Marks']].

Note: .loc[] expects labels. If you want integer positions, use .iloc[] instead.

English

Two essential skills in data analysis are filtering rows using Boolean indexing and moving data seamlessly between CSV files and Pandas DataFrames. Boolean indexing lets you select rows based on conditions; import/export handles persistence and data exchange.

• Boolean Indexing – using a series of True/False values to select rows. You write a condition like df['Marks'] > 80 and pass it inside df[...] or df.loc[...]. Multiple conditions can be combined with & (and), | (or), ~ (not).
• Importing CSV – use pd.read_csv('file.csv') with many parameters (sep, header, index_col, usecols, nrows, skiprows, etc.).
• Exporting to CSV – use df.to_csv('file.csv', index=False). Common parameters: index, header, columns, sep.

These operations are used together daily: load a CSV, filter rows with Boolean indexing, perform calculations, and save the result back to a new CSV.

Boolean Indexing – Detailed Guide

Boolean indexing creates a mask of True/False values corresponding to each row. Only rows where the mask is True are returned. The condition can involve one or multiple columns. Use & for AND, | for OR, and ~ for NOT. Always use parentheses around each condition when combining them, due to operator precedence.

Importing/Exporting Data between CSV and DataFrames

Pandas provides robust functions to read from and write to CSV files, the most common data interchange format.

English

Data visualization means representing data in graphical or pictorial form (charts, plots, graphs). The main purpose of plotting is to understand data quickly, spot patterns, trends, and outliers that are not obvious from raw numbers.

• Quick Insight – A picture is worth a thousand numbers. You instantly see highs, lows, and clusters.
• Pattern & Trend Detection – Line charts reveal increase/decrease over time, scatter plots show correlation.
• Comparison – Bar charts compare categories side by side.
• Distribution Understanding – Histograms show how data is spread, where most values lie.
• Communication – Visuals are easier to present and explain to others than tables of figures.
• Decision Making – Clear visuals help in taking data‑driven decisions faster.

In Python, we use Matplotlib (and libraries built on it like Seaborn) to create publication‑quality plots with just a few lines of code.

English

Matplotlib’s pyplot module (imported as plt) provides simple functions to create a wide variety of plots. In this section, we cover the three most fundamental types:

• Line Plot – plt.plot(). Shows trends over a continuous range (e.g., time series).
• Bar Graph – plt.bar(). Compares discrete categories with rectangular bars.
• Histogram – plt.hist(). Displays the frequency distribution of a numerical dataset.

After creating any plot, you can save it to a file (PNG, PDF, SVG, etc.) using plt.savefig('filename') before calling plt.show(). Saving after show() may result in a blank file.

1. Line Plot / रेखा ग्राफ

Purpose: Show trends, changes over time, or continuous data. Data points are connected by straight lines.

Key parameters: plt.plot(x, y, color, linestyle, marker, linewidth, label).

2. Bar Graph / बार ग्राफ

Purpose: Compare quantities across categories. Each category has a bar whose height represents the value.

Key parameters: plt.bar(x, height, color, width, edgecolor, label).

For horizontal bars use plt.barh(). For grouped/stacked bars, call bar() multiple times.

3. Histogram / हिस्टोग्राम

Purpose: Understand the distribution of a numerical dataset. The range of values is divided into equal bins, and the height of each bar shows how many data points fall into that bin.

Key parameters: plt.hist(data, bins, color, edgecolor, alpha, cumulative).

bins controls the number of intervals; more bins → finer detail.

Saving Plots – Important Notes

• Always call plt.savefig() before plt.show(); otherwise the figure is emptied.
• Common parameters: dpi (resolution), bbox_inches='tight' (removes extra whitespace), transparent=True (transparent background).
• Supported formats: '.png', '.jpg', '.pdf', '.svg'.

English

A raw plot conveys data, but to make it understandable and professional you must add labels, a title, and a legend. Matplotlib provides simple functions for each, which can be customized with font sizes, colors, and positions.

• Labels: plt.xlabel('text') and plt.ylabel('text') add descriptions to the X and Y axes. Use parameters like fontsize, color, fontweight.
• Title: plt.title('text') sets the main title of the plot. You can also set loc to left, center, or right.
• Legend: First, provide a label argument inside the plotting function (plot(), bar(), etc.). Then call plt.legend(). Customize with loc (location like 'upper left'), title, fontsize, frameon.

These additions turn a bare plot into a clear, self‑explanatory visual that can be presented directly.

Legend Best Practices

• Always give a descriptive label inside the plotting call, otherwise nothing appears in the legend.
• Common legend locations: 'best', 'upper right', 'upper left', 'lower left', 'lower right', 'center'.
• To hide the legend frame, use frameon=False.
• To remove the legend entirely, simply omit label arguments or do not call plt.legend().

English

Computer Network: A computer network is a collection of interconnected devices (computers, servers, printers, etc.) that can communicate and share resources (data, files, internet, printers). The connection can be wired (Ethernet cables, fiber optics) or wireless (Wi‑Fi, Bluetooth, satellite).

Need for Networking:

• Resource Sharing – share printers, scanners, storage, and internet connections.
• Data Sharing – exchange files and information easily.
• Communication – email, video conferencing, instant messaging.
• Centralised Management – software updates, security policies from one place.
• Cost Efficiency – reduces hardware duplication.

Types of Networks (by scale):

• PAN (Personal Area Network) – very small area (few metres), e.g., Bluetooth connection between phone and laptop.
• LAN (Local Area Network) – within a building or campus (room, office, school). High speed, privately owned.
• MAN (Metropolitan Area Network) – covers a city or large campus. Larger than LAN, smaller than WAN.
• WAN (Wide Area Network) – spans countries or continents. The Internet is the largest WAN. Uses leased lines, satellites.

Basic Components: Nodes (devices), communication links (cables/wireless), switches, routers, protocols (rules like TCP/IP).

English

Computer networks are classified by their geographical spread and purpose. The four primary types are:

• PAN – Personal Area Network
• LAN – Local Area Network
• MAN – Metropolitan Area Network
• WAN – Wide Area Network

As the area grows, the technology, speed, cost, and management complexity change.

1. PAN (Personal Area Network)

Smallest network, range up to ~10 metres. Used for communication among personal devices like smartphone, laptop, tablet, smartwatch. Technologies: Bluetooth, Infrared, USB cable.

Example: Connecting wireless earphones to a mobile phone.

Features: Very low cost, low power, limited to one user.

2. LAN (Local Area Network)

Confined to a small area – a room, building, or campus (up to a few kilometres). Connects computers, printers, and servers within an organisation. High data transfer rate (100 Mbps to 10 Gbps). Uses Ethernet cables (UTP, fiber) or Wi‑Fi.

Example: Computer lab in a school, office network.

Features: Privately owned, low latency, easy to set up and manage.

3. MAN (Metropolitan Area Network)

Spans a city or a large town (up to ~50 km). Larger than LAN but smaller than WAN. Often connects multiple LANs together, e.g., different branches of an organisation within the same city. Uses fiber optics, microwave links, or leased lines.

Example: Cable TV network in a city, city‑wide Wi‑Fi (like free public Wi‑Fi zones).

Features: Medium cost, moderate speed, managed by a corporation or government body.

4. WAN (Wide Area Network)

Covers a very large geographical area – countries, continents, or the whole globe. The Internet is the largest WAN. Connects LANs and MANs across long distances. Uses leased telecommunication lines, fiber optics, satellites, and undersea cables. Data rates are lower compared to LAN due to distance and infrastructure.

Example: Internet, a multinational company connecting offices in India, USA, and Europe.

Features: Expensive, complex management, public or private ownership, slower than LAN (relative to the distance).

Comparison at a Glance

English

Network devices are hardware components that connect computers, manage traffic, extend signals, and connect different networks. Each device works at a specific layer of the network and performs a unique function.

• Modem – converts digital data to analog signals and vice versa, enabling internet access over telephone or cable lines.
• Hub – a basic device that broadcasts data to all ports; works at the physical layer.
• Switch – an intelligent device that sends data only to the specific destination port; works at the data link layer.
• Repeater – amplifies or regenerates a weak signal to extend the transmission distance.
• Router – connects different networks (e.g., LAN to the internet) and forwards data based on IP addresses.
• Gateway – a device or software that connects two dissimilar networks using different protocols, translating between them.

Detailed Definitions

• Modem (Modulator‑Demodulator): Converts digital signals from a computer to analog signals for transmission over telephone lines, and vice versa. Essential for DSL/cable internet connections.
• Hub: A multiport repeater that broadcasts incoming data to all connected devices. Because of shared bandwidth and lack of intelligence, it is rarely used now.
• Switch: Reads the MAC address of incoming frames and forwards them only to the intended port. Supports full‑duplex communication, making networks faster and collision‑free.
• Repeater: Receives a signal, cleans it, regenerates it at the original strength, and retransmits. Used to overcome cable length limitations (e.g., Ethernet ~100m).
• Router: Operates at the network layer (Layer 3). Determines the best path for data packets based on IP addresses. Connects LANs to the internet and often includes firewall features.
• Gateway: A node that connects two networks with different transmission protocols. It can be hardware, software, or a combination. It translates data formats, addresses, and protocols. The "default gateway" in a home network is usually the router.

Quick Comparison

English

Network topology refers to the physical or logical arrangement of devices (nodes) and connections (links) in a computer network. The topology affects performance, fault tolerance, cost, and scalability. The four fundamental topologies are:

• Star – all nodes connect to a central device (hub/switch).
• Bus – all nodes share a single communication line (backbone).
• Tree – hierarchical combination of star and bus topologies; root node branches out.
• Mesh – every node is connected to every other node (full mesh) or partially connected.

1. Star Topology

All nodes are connected to a central device (usually a switch or hub). The central device manages and relays data. If one cable fails, only that node is affected; if the central device fails, the whole network goes down.

Advantages: Easy to install, add/remove nodes, fault isolation simple.

Disadvantages: Central device dependency, requires more cable than bus.

2. Bus Topology

All devices are connected to a single central cable (backbone). Data travels in both directions. Terminators at both ends prevent signal reflection.

Advantages: Simple, cheap, uses least cable, easy to expand (just tap into the backbone).

Disadvantages: If the backbone fails, entire network goes down. Only one device can transmit at a time (collisions). Difficult to troubleshoot.

3. Tree Topology

A hierarchical structure where a root node connects to one or more nodes, which may further branch out. It is a combination of star and bus topologies. Often used in large organisations and WANs.

Advantages: Scalable, hierarchical management, easy to extend and isolate faults in branches.

Disadvantages: Highly dependent on root and backbone links, complex wiring, maintenance cost high.

4. Mesh Topology

Every device is connected to every other device (full mesh) or at least to several other devices (partial mesh). Provides maximum redundancy and reliability.

Advantages: Extremely reliable, data can take multiple paths, no single point of failure (full mesh). Ideal for critical networks.

Disadvantages: Very expensive (huge amount of cabling), complex to install and manage.

Quick Comparison

English

Internet: A global network of billions of computers and other electronic devices. With the Internet, you can access information, communicate with anyone in the world, and do much more. The Internet is the infrastructure, while the World Wide Web (WWW) is a collection of web pages and websites that run on top of the Internet.

Key elements:

• URL (Uniform Resource Locator) – the unique address of a resource on the Web (e.g., a webpage, image, or file).
• WWW (World Wide Web) – a system of interlinked hypertext documents accessed via the Internet using a browser.

Applications of the Internet:

• Web – Browsing websites, search engines, e‑commerce, online learning.
• Email – Electronic mail; sending and receiving messages and attachments.
• Chat – Real‑time text messaging (e.g., WhatsApp, Telegram, Slack).
• VoIP (Voice over IP) – Voice and video calls over the Internet (e.g., Skype, Zoom, WhatsApp call).

All these applications use different protocols – rules that define how data is transmitted and received.

WWW (World Wide Web)

The Web is a collection of interconnected documents and resources, linked by hyperlinks. Created by Tim Berners‑Lee in 1989. Uses HTTP/HTTPS protocol. Accessed via a web browser (Chrome, Firefox, Edge). Each page is written in HTML and identified by a URL.

Email

Electronic mail. Uses store‑and‑forward model. Protocols: SMTP for sending, POP3 or IMAP for receiving. Address format: username@domain.com. You can attach files (images, documents) and send to multiple recipients.

Chat (Instant Messaging)

Real‑time text communication between two or more people. Can include file sharing, emojis, audio messages. Examples: WhatsApp, Telegram, Facebook Messenger, Slack. Often uses proprietary protocols.

VoIP (Voice over Internet Protocol)

Technology that lets you make voice calls using a broadband Internet connection instead of a regular phone line. Converts voice into digital packets. Supports video calls too. Examples: Skype, Zoom, Google Meet, WhatsApp audio/video calls.

English

Webpage: A single document on the World Wide Web, written in HTML, that can contain text, images, videos, links, etc. It is displayed in a web browser and identified by a unique URL (e.g., https://www.example.com/about.html).

Website: A collection of related webpages grouped together under a single domain name (e.g., www.example.com). A website may consist of a single page (single‑page website) or thousands of interconnected pages, all sharing a common theme or purpose.

Key Difference:

• A webpage is like a single page of a book.
• A website is the entire book.

Together, webpages form a website. When you visit a website, you navigate through its webpages using hyperlinks.

Quick Comparison

Static vs Dynamic Web Page

Static Web Page: A fixed page that displays the same content to every user. It is written in plain HTML and CSS. Content changes only when the developer manually edits the file. No interaction with a database. Fast loading, simple to create.

Dynamic Web Page: Content changes based on user interaction, time, or other parameters. Built using server‑side scripting languages (PHP, Python, ASP.NET) and a database. Examples: social media feeds, e‑commerce sites, webmail. Slower than static due to processing, but highly interactive and personalised.

Key Differences

Web Server

A web server is a computer program (or hardware device) that stores, processes, and delivers webpages to clients (browsers) via HTTP/HTTPS. When you type a URL, the browser sends a request to the web server; the server finds the requested file (or generates it dynamically) and sends it back as a response. Popular web server software: Apache, Nginx, Microsoft IIS, LiteSpeed.

The term "web server" can refer to the software (like Apache) or the physical machine that runs the software. Usually, a web server also handles security (SSL/TLS), logging, and load balancing.

Hosting of a Website

Web hosting is a service that allows individuals and organisations to make their website accessible on the Internet. A hosting provider allocates space on a web server where website files (HTML, CSS, images, scripts) are stored. The server is connected to the Internet 24/7, so people can visit the site anytime.

Types of hosting:

• Shared Hosting – Many websites share a single server. Cheapest; suitable for small sites.
• VPS (Virtual Private Server) – A physical server is divided into virtual compartments. Each VPS has dedicated resources, more control.
• Dedicated Hosting – An entire physical server rented exclusively for one website/client. High performance, full control, expensive.
• Cloud Hosting – Uses a network of virtual servers; scalable, pay‑as‑you‑go, high reliability (e.g., AWS, Google Cloud).

Domain Name: The human‑friendly address (e.g., www.example.com) that points to the hosting server’s IP address via DNS.

Uploading a Website: After creating website files, you upload them to the hosting server using FTP (File Transfer Protocol) or a file manager provided by the host. Once uploaded, the site becomes live.

English

Web Browser: A software application used to access, retrieve, and display content from the World Wide Web. When you type a URL or click a link, the browser sends a request to the web server, receives the HTML/CSS/JavaScript files, and renders (displays) them as a readable webpage. Browsers translate code into the visual pages we interact with.

Functions of a browser:

• Fetch web pages from servers using HTTP/HTTPS.
• Render HTML, CSS, and JavaScript into a visual layout.
• Manage bookmarks, browsing history, passwords, and downloads.
• Support tabs, private/incognito mode, extensions, and developer tools.
• Enforce security features like SSL certificate checks and pop‑up blocking.

How a browser works (simplified): User enters URL → Browser looks up IP via DNS → Sends HTTP request → Server responds with HTML → Browser parses HTML, fetches linked resources (CSS, JS, images) → Builds the DOM tree and CSSOM → Renders the page on screen.

Commonly Used Browsers

English

Beyond just displaying webpages, modern browsers offer a wide range of settings to control privacy, security, and appearance, support for extensions/add‑ons/plug‑ins to add functionality, and mechanisms like cookies to remember your preferences and sessions. Understanding these features helps you browse safely and efficiently.

Browser Settings

Every browser has a Settings or Preferences menu where you can customize how the browser works. Common settings include:

• Privacy & Security: Clear browsing history, manage passwords, block third‑party cookies, enable "Do Not Track", control camera/microphone permissions.
• Appearance: Change themes, font size, home page, show/hide bookmarks bar.
• Default Search Engine: Choose between Google, Bing, Yahoo, DuckDuckGo, etc.
• Downloads: Set default download location, ask where to save each file.
• Startup: Open a specific page or set of pages, or continue where you left off.
• Sync: Sign in to your browser account to sync bookmarks, passwords, history, and settings across multiple devices.

Most browsers also offer Incognito/Private mode: browsing activity is not stored locally (history, cookies, form data are deleted after closing the window).

Add‑ons, Extensions & Plug‑ins

These are small software components that add specific capabilities to a browser. Though often used interchangeably, there is a subtle difference:

• Add‑on / Extension: A general term for any piece that adds functionality to the browser (e.g., ad blockers, grammar checkers, password managers). They are typically built using web technologies (HTML, CSS, JavaScript) and run in a sandboxed environment.
• Plug‑in: A more specific term for software that processes web content that the browser doesn’t natively support. Examples: Adobe Flash Player (now obsolete), Java applet plug‑in, PDF viewer plug‑in. Plug‑ins are loaded by the browser to handle specific file types or media. Most modern browsers have phased out traditional plug‑ins in favour of HTML5 and extensions.

You can install add‑ons/extensions from the browser’s official web store (Chrome Web Store, Firefox Add‑ons, etc.). Always check permissions before installing, as some may have access to your data.

Cookies

Cookies are small text files stored on your computer by websites you visit. They remember information about you and your preferences. Cookies are sent back to the server with every request, allowing the server to recognize you.

Types of cookies:

• Session Cookies: Temporary, deleted when you close the browser. Used to maintain login sessions or shopping carts.
• Persistent Cookies: Remain on your device for a set period (or until manually deleted). Used to remember login info, language preferences, or for tracking across sites.
• First‑party Cookies: Set by the website you are visiting. Generally considered safe.
• Third‑party Cookies: Set by other domains (e.g., advertisers) embedded in the website. Often used for cross‑site tracking and targeted advertising.

Uses: Session management (keeping you logged in), personalisation (language, theme), tracking (analytics, ads).

Managing Cookies: You can view, delete, or block cookies from browser settings. Blocking all cookies may break some websites that rely on them for login or shopping cart functionality. Most modern browsers are phasing out third‑party cookies for privacy reasons.

English

Digital Footprint is the trail of data you leave behind when you use the internet. Every website visit, social media post, online purchase, search query, and even "like" creates a record. This record can be permanent and contributes to your online identity.

Types of Digital Footprints:

• Active Digital Footprint: Data you deliberately share – social media posts, filled forms, emails, comments, uploaded photos, blog articles.
• Passive Digital Footprint: Data collected without your explicit knowledge – browsing history, IP address, location data, cookies tracking your activity across sites, time spent on pages.

Why it matters: Your digital footprint can affect your reputation, college admissions, job prospects, and even personal safety. Employers often check social media profiles before hiring. Once online, information can be copied, shared, and archived – sometimes forever.

Impacts on society: Digital footprints fuel targeted advertising, influence political campaigns, enable cyberstalking, and contribute to identity theft. On the positive side, they help personalise user experience, facilitate e‑commerce recommendations, and assist in criminal investigations.

Managing Your Digital Footprint

• Think before you post: once something is online, it can be difficult or impossible to remove completely.
• Use privacy settings on social media to control who can see your content.
• Regularly search your own name to see what information is publicly available.
• Clear cookies and browsing history periodically.
• Use strong, unique passwords and enable two‑factor authentication to protect your accounts.
• Read terms and privacy policies before signing up for a service.

English

Net Etiquettes (Netiquette): Set of rules for acceptable and respectful behaviour while communicating over the internet. It covers email, social media, chat, forums, and video calls. Good netiquette creates a positive digital environment.

Data Protection: Practices and laws designed to safeguard personal and sensitive information from unauthorised access, misuse, disclosure, or destruction. It includes technical measures, policies, and legal frameworks.

Why Netiquette Matters

Following netiquette reduces misunderstandings, prevents cyberbullying, maintains professional reputation, and fosters healthy online communities. Violations can lead to being banned from platforms, legal consequences, or social backlash.

Data Protection Principles

Data protection is guided by principles like lawfulness, fairness, transparency, purpose limitation, data minimisation, accuracy, storage limitation, integrity, and confidentiality. In India, the Digital Personal Data Protection Act 2023 governs how personal data is collected and processed, giving individuals rights over their data.

English

Intellectual Property (IP) refers to creations of the mind – inventions, literary and artistic works, designs, symbols, names, and images used in commerce. Intellectual Property Rights (IPR) are the legal rights granted to creators and owners to protect their creations from unauthorised use, allowing them to benefit from their work.

Why IPR is important:

• Encourages innovation by rewarding creators.
• Protects the economic and moral rights of the creator.
• Prevents others from copying, selling, or using the work without permission.
• Promotes fair competition and economic growth.
• In the digital age, it is critical to prevent software piracy, content theft, and plagiarism.

IPR and the Digital World

In the software and internet context:

• Open Source Licenses – Grant rights to use, modify, share code freely (e.g., GNU GPL, MIT, Apache). Creators still retain copyright but allow usage under defined terms.
• Plagiarism – Using someone else’s work without credit violates copyright and is an ethical offence.
• Software Piracy – Unauthorised copying, distribution, or use of software. It is illegal and punishable under copyright law.
• Creative Commons (CC) – A set of free licences that let creators specify how others may use their work (attribution, non‑commercial, share‑alike, etc.).
• Fair Use / Fair Dealing – Permits limited use of copyrighted material without permission for purposes like education, research, criticism, or news reporting.

English

In the digital world, it’s crucial to understand plagiarism (using others’ work without credit), copyright (legal protection for original works), and licensing (permissions for use). These concepts protect creators’ rights and guide ethical use of content and software.

Plagiarism

Plagiarism means presenting someone else’s work, ideas, or words as your own without proper acknowledgment. It is an ethical and academic offence, and often a copyright violation.

Types of plagiarism:

• Direct plagiarism: Copying text word‑for‑word without quotation marks or citation.
• Self‑plagiarism: Reusing your own previously published work without permission or citation.
• Mosaic plagiarism: Patching together phrases from different sources without proper citation.
• Accidental plagiarism: Forgetting to cite sources or misquoting.
• Source‑based plagiarism: Citing a non‑existent or incorrect source; making up data.

Consequences: Loss of credibility, legal action, academic penalties (failing grades, expulsion), and damage to reputation.

How to avoid: Always cite sources, use quotation marks for direct quotes, paraphrase properly, keep track of references, use plagiarism‑checking tools.

Copyright

Copyright is a legal right that gives the creator of an original work exclusive control over its use and distribution. It applies to literary, artistic, musical, dramatic works, software, and more.

Key points:

• Automatically granted as soon as the work is created and fixed in a tangible form (no registration required, though registration helps in legal disputes).
• Protects expression of ideas, not the ideas themselves.
• Rights: reproduce, distribute, perform, display, create derivative works.
• Duration in India: Author’s lifetime + 60 years for most works.
• Fair Use / Fair Dealing: Allows limited use without permission for purposes like criticism, comment, news reporting, teaching, scholarship, research.
• Violation (infringement) can lead to civil and criminal penalties.

Licensing

A license is a permission granted by the copyright holder to use a work in specific ways. It defines what you can and cannot do with the software, content, or creative work.

Software Licenses:

• Proprietary License: The software is owned by a company; source code is not shared. Users purchase a right to use under strict conditions (e.g., Microsoft Windows, Adobe Photoshop).
• Open Source License: Source code is freely available; can be used, modified, and shared. Different types exist:
  • GPL (General Public License): Copyleft – derivative works must also be open‑source under GPL.
  • MIT License: Permissive – allows reuse, including in proprietary software, with very few restrictions.
  • Apache License: Like MIT but also grants patent rights and requires changes to be documented.
• Freeware: Free to use but source code is not available (e.g., Adobe Acrobat Reader, Skype).
• Shareware: Distributed for free on a trial basis; payment required for continued use or full features.
• Creative Commons (CC): Licenses for creative works (text, images, music) that specify conditions like Attribution (BY), Non‑Commercial (NC), No Derivatives (ND), Share‑Alike (SA). Example: CC BY‑NC means you can share/adapt for non‑commercial use with attribution.
• Public Domain (CC0): The creator waives all rights; anyone can use the work for any purpose without permission.

English

Free and Open Source Software (FOSS) refers to software that is both free (as in freedom, not necessarily price) and open source. Users are free to run, study, modify, and share the software. The source code is publicly available, encouraging collaboration and transparency.

The Four Essential Freedoms (Free Software Foundation):

• Freedom 0: Run the program for any purpose.
• Freedom 1: Study how the program works and change it (requires source code).
• Freedom 2: Redistribute copies to help others.
• Freedom 3: Distribute modified versions to the community.

"Free" vs "Open Source": "Free software" emphasises the ethical aspect – users should have control. "Open source" focuses on the practical benefits – collaborative development, better quality. Both terms refer to essentially the same set of licenses (GPL, MIT, Apache, etc.).

Examples: Linux (OS), Apache (web server), MySQL (database), LibreOffice (office suite), GIMP (image editor), VLC Media Player, Python, Firefox.

Benefits of FOSS

• Cost Savings: No licensing fees, especially important for schools, governments, startups.
• Transparency & Security: Anyone can inspect the code for vulnerabilities or backdoors.
• Customisation: Users can modify software to fit their exact needs.
• Community Support: Large volunteer communities often provide rapid fixes and improvements.
• Vendor Independence: No lock‑in to a single company’s roadmap or pricing.
• Educational Value: Students can learn from real‑world code, contributing to projects.

English

Cybercrime refers to illegal activities carried out using computers, networks, or the internet. These crimes can target individuals, organisations, or governments. With increasing digitisation, understanding cybercrime, its types, and the legal framework is essential for digital safety.

Key topics covered here:

• Cybercrime – definition, categories, examples.
• Cyber Laws – legal provisions, IT Act 2000 (India).
• Hacking – unauthorised access, ethical vs unethical.
• Phishing – fraudulent attempts to steal information.
• Cyber Bullying – online harassment and its impact.

Cyber Laws (with focus on India)

Cyber law governs legal issues related to the internet, digital transactions, and cybercrimes. In India, the primary legislation is the Information Technology Act, 2000 (IT Act), amended in 2008. It defines offences and penalties for cybercrimes.

Key sections:

• Section 43: Penalty for unauthorised access, downloading, virus introduction, damage to computer systems (civil liability).
• Section 66: Hacking with dishonest intent – imprisonment up to 3 years and fine.
• Section 66C: Identity theft – imprisonment up to 3 years.
• Section 66D: Cheating by personation using computer – imprisonment up to 3 years.
• Section 67: Publishing/transmitting obscene material electronically.
• Section 67A: Publishing sexually explicit content – imprisonment up to 5 years.
• Section 67B: Child pornography – stringent punishment.

Other relevant laws include the Indian Penal Code (IPC), Data Protection Act (DPDP 2023), and Consumer Protection Act for e‑commerce.

Hacking

Hacking is the act of gaining unauthorised access to a computer system or network. Not all hacking is illegal – it depends on intent and authorisation.

• Ethical Hacking (White Hat): Authorised professionals who test systems to find vulnerabilities and fix them. They work with permission to improve security. Example: penetration testers.
• Unethical Hacking (Black Hat): Malicious hackers who exploit vulnerabilities for personal gain, theft, or damage. Illegal.
• Grey Hat: Hackers who may break laws or ethical standards but without malicious intent (e.g., finding a vulnerability and disclosing it publicly without permission).

Common hacking techniques: Password cracking, keyloggers, denial of service (DoS), SQL injection, social engineering, exploiting software bugs.

Prevention: Use strong passwords, keep software updated, use firewalls and antivirus, avoid suspicious links, enable two‑factor authentication.

Phishing

Phishing is a social engineering attack where fraudsters impersonate legitimate organisations (banks, e‑commerce sites, social media) to trick victims into revealing sensitive information like usernames, passwords, credit card numbers, or OTPs.

Common forms:

• Email Phishing: Fake emails that appear to be from trusted sources, often with urgent calls to action ("Your account will be blocked!").
• Spear Phishing: Targeted phishing aimed at a specific individual or organisation, using personalised information to appear genuine.
• Smishing: Phishing via SMS messages.
• Vishing: Phishing via voice calls (fake bank calls asking for OTP).
• Clone Phishing: A legitimate previously delivered email is cloned, and attachments/links are replaced with malicious ones.

Signs of phishing: Generic greetings, spelling errors, mismatched URLs, requests for sensitive data, suspicious attachments.

Prevention: Never click on links in unsolicited emails, verify the sender’s email address, use spam filters, look for HTTPS and padlock symbol, never share OTPs/passwords over phone.

Cyber Bullying

Cyber bullying is bullying that takes place over digital devices – social media, messaging apps, gaming platforms, or any online space. It includes sending, posting, or sharing negative, harmful, false, or mean content about someone else. It is repeated behaviour intended to scare, anger, or shame the target.

Forms of cyber bullying:

• Harassment: Repeatedly sending abusive or threatening messages.
• Denigration: Spreading rumours or posting embarrassing photos/videos to damage someone's reputation.
• Impersonation: Creating fake profiles pretending to be the victim and posting inappropriate content.
• Outing / Doxing: Sharing someone’s personal or private information (address, phone number) without consent.
• Exclusion: Deliberately excluding someone from an online group or conversation.
• Cyber stalking: Persistent following and monitoring of a person online that causes fear.

Impact: Anxiety, depression, low self‑esteem, academic decline, and in extreme cases, self‑harm or suicide. Victims often feel helpless because the bullying can happen 24/7 and reach them even at home.

Prevention & Response: Do not engage/respond, block the bully, save evidence (screenshots), report to platform authorities, talk to a trusted adult (parent/teacher), and if serious, file a complaint with cyber police under relevant laws (IT Act, IPC).

English

Information Technology Act, 2000 (IT Act) is India’s primary law dealing with cybercrime and electronic commerce. It was enacted on 17th October 2000 and amended in 2008 to include provisions for new forms of cyber offences.

Need for the IT Act: Before 2000, there were no specific laws to tackle online crimes, electronic contracts, or digital signatures. The IT Act provides legal recognition for electronic transactions, defines cyber offences, and prescribes penalties. It gives legal validity to e‑commerce, e‑governance, and digital records.

Objectives of the IT Act:

• Provide legal recognition to electronic records and digital signatures.
• Facilitate electronic filing of documents with government agencies.
• Define cyber offences and prescribe penalties.
• Amend related laws (IPC, Evidence Act, RBI Act) to align with the digital age.
• Promote e‑governance and secure electronic communication.

The Act extends to the whole of India and also applies to offences committed outside India if the computer/system involved is located in India.

IT (Amendment) Act, 2008

The original IT Act focused on e‑commerce and digital signatures. The 2008 amendment was a major update that introduced sections for new crimes like phishing, identity theft, cyber terrorism, child pornography, and video voyeurism. It also strengthened data protection requirements for companies, gave powers to the government to block websites for national security, and defined the role of intermediaries (like internet service providers and social media platforms) in managing user‑posted content.

The amendment also introduced Section 79 – "safe harbour" provision for intermediaries, which exempts them from liability for third‑party content if they follow due diligence. However, the government can still direct them to remove content under specific conditions.

English

E‑waste (Electronic Waste) refers to discarded electrical or electronic devices – old computers, mobile phones, TVs, printers, batteries, etc. As technology advances rapidly, the volume of e‑waste is growing dangerously. Improper disposal and informal recycling release toxic substances that harm the environment and human health.

Hazards of E‑waste

E‑waste contains many hazardous materials. When dumped in landfills or burned informally, these substances leak into air, water, and soil.

Consequences of Improper Handling

• Soil & Water Pollution: Heavy metals leach into groundwater, affecting agriculture and drinking water.
• Air Pollution: Burning e‑waste releases toxic fumes (dioxins, furans) that cause respiratory diseases and cancer.
• Health Risks for Workers: Informal recyclers (often children) are exposed to acids and poisons while extracting gold/copper, leading to chronic diseases.
• Bioaccumulation: Toxins enter the food chain through water and crops, affecting entire ecosystems.

E‑waste Management

Proper e‑waste management minimises environmental damage and recovers valuable materials. Key strategies:

Indian E‑Waste Rules at a Glance

The E‑Waste (Management) Rules, 2016 (effective from 2018, amended in 2022) mandate:

• Producers must meet annual collection and recycling targets (Extended Producer Responsibility).
• Consumers must channel e‑waste to authorised collection points – not scrap dealers.
• Central Pollution Control Board (CPCB) oversees registration and compliance.
• Dismantlers and recyclers must obtain authorisation and follow standard operating procedures.
• Penalties for non‑compliance and illegal dumping.

English

While technology has revolutionised our lives, prolonged and improper use of digital devices can lead to several health issues. Being aware of these risks and practising healthy habits is essential for everyone – especially students and professionals who spend long hours on screens.

Common health concerns include eye strain, posture problems, repetitive strain injuries, sleep disruption, mental health issues, and possible effects of electromagnetic radiation. Most of these can be prevented with simple, conscious changes in daily routine.

Healthy Technology Habits (Summary)

• Follow the 20‑20‑20 rule for eye health.
• Maintain good posture and take movement breaks.
• Stretch your hands, wrists, neck regularly.
• Limit screen time, especially before sleep.
• Keep volume at safe levels; protect your hearing.
• Use technology with purpose, not out of habit.
• Stay physically active and nurture offline relationships.
• Keep devices at a safe distance from the body when not in use.

Technology is a tool – it should enhance our life, not harm our health. Awareness and balance are the keys.