MySQL + SQL · Lesson 2
Data, Processing and Information
What is Data?
Data is raw, unorganized facts and figures that have no meaning on their own. Data can be numbers, text, symbols, images or sounds — but without context, it tells us nothing.
Examples of raw data:
45, Aarav, XII-A, 2025, 89, Khurja— these numbers and words alone mean nothing.- Temperature readings:
37, 38, 36, 40— raw figures without context. - Attendance:
P, A, P, P, A— just letters without meaning.
Data is the input to a system. It must be processed to become useful.
What is Information?
Information is processed, organized and meaningful data. When raw data is given context, structure and meaning, it becomes information that helps in decision-making.
Examples of information:
- "Aarav Sharma of Class XII-A scored 89 marks in Mathematics in 2025." — meaningful sentence.
- "Student Priya Verma has been absent 5 times this month." — actionable information for teacher.
- "Total fee collected in April 2025 is ₹2,45,000." — useful for school management.
Information is the output of a system after data is processed.
Data vs Information – Comparison
| Feature | Data | Information |
|---|---|---|
| Definition | Raw, unorganized facts | Processed, meaningful facts |
| Meaning | No meaning alone | Has clear meaning and context |
| Form | Numbers, text, symbols | Sentences, reports, charts |
| Use | Input to processing | Output used for decisions |
| Example | 89, Aarav, Math | Aarav scored 89 in Math |
| Dependency | Independent | Depends on data |
What is Data Processing?
Data Processing is the series of operations performed on raw data to convert it into meaningful information. A computer or database performs these operations — collecting, organizing, calculating, sorting and presenting data.
The basic Data Processing Cycle:
INPUT (Raw Data) → PROCESSING → OUTPUT (Information)
↑ |
|____________ STORAGE ________________|- Input: Collecting raw data (student marks entered in database).
- Processing: Calculating totals, averages, rankings.
- Output: Result sheet, report card, attendance summary.
- Storage: Saving processed data in database for future use.
Types of Data Processing
| Type | Meaning | Example |
|---|---|---|
| Batch Processing | Data collected over time, processed all at once | Monthly salary calculation, electricity bill generation |
| Real-Time Processing | Data processed immediately as it is entered | ATM transaction, railway seat booking |
| Online Processing | Processing done via internet connection continuously | Online exam portal, e-commerce order |
| Distributed Processing | Processing shared across multiple computers/servers | Large bank systems, cloud databases |
| Multi-Processing | Multiple processors work on data simultaneously | High-performance database servers |
Real Examples in School Context
-- Raw Data stored in database (just numbers and text)
CREATE TABLE marks (
roll_no INT,
name VARCHAR(60),
subject VARCHAR(40),
marks INT
);
INSERT INTO marks VALUES
(1, 'Aarav Sharma', 'Math', 89),
(1, 'Aarav Sharma', 'Science', 76),
(1, 'Aarav Sharma', 'English', 82),
(2, 'Priya Verma', 'Math', 91),
(2, 'Priya Verma', 'Science', 88),
(2, 'Priya Verma', 'English', 79);
-- Processing: Convert data into meaningful information
SELECT name,
SUM(marks) AS total_marks,
ROUND(AVG(marks), 2) AS percentage,
CASE WHEN AVG(marks) >= 90 THEN 'A+'
WHEN AVG(marks) >= 75 THEN 'A'
WHEN AVG(marks) >= 60 THEN 'B'
ELSE 'C' END AS grade
FROM marks
GROUP BY roll_no, name
ORDER BY total_marks DESC;
Output (Information — now meaningful!):
+--------------+-------------+------------+-------+
| name | total_marks | percentage | grade |
+--------------+-------------+------------+-------+
| Priya Verma | 258 | 86.00 | A |
| Aarav Sharma | 247 | 82.33 | A |
+--------------+-------------+------------+-------+
Raw marks (data) → processed → Result with grade (information)
+--------------+-------------+------------+-------+
| name | total_marks | percentage | grade |
+--------------+-------------+------------+-------+
| Priya Verma | 258 | 86.00 | A |
| Aarav Sharma | 247 | 82.33 | A |
+--------------+-------------+------------+-------+
Raw marks (data) → processed → Result with grade (information)
Common Mistakes
- Confusing data with information: "89" alone is data; "Aarav scored 89 in Math" is information.
- Storing information instead of data: In database, store raw fields (marks, subject) — not pre-made sentences.
- Skipping the processing step: Database stores data; SQL queries do the processing to give information.
- No data validation: Wrong data in = wrong information out. Always validate input data.
Practice Tasks
- Give 3 examples of Data and 3 examples of Information from your school or daily life.
- Create a
fee_collectiontable. Store raw data (student_id, amount, month). Write a SQL query to process it and find total fee collected per month (information). - Draw the Data Processing Cycle with arrows and label each step with a school example.
- Write a viva answer: "What is the difference between data and information?" in 3 lines.
Summary
- Data = Raw facts (input) — no meaning alone.
- Information = Processed data (output) — meaningful and useful.
- Data Processing = Converting data into information through operations.
- Processing types: Batch, Real-Time, Online, Distributed, Multi-Processing.
- In MySQL: Tables store data; SQL SELECT queries produce information.