Class 10 · Unit 2
Database Management
& System
A simple, friendly guide to databases, tables, keys, and MySQL — written so the ideas feel
easy to remember.
🗂️ Database Basics
📋 Tables & Rows
🔑 Keys
🐬 MySQL
🧾 SQL Commands
⚙️ Practice Tasks
This unit explains databases in simple, everyday words so you can connect ideas to
real life. Read the examples first, then try the commands — learning by doing helps the concepts stick.
We'll keep things practical: short explanations, clear analogies, and tiny examples you can type yourself.
Focus on understanding what each command does rather than memorizing it.
Practice the small tasks listed under Practical Tasks — creating a table or inserting a row will make the
theory feel real and memorable.
A database is just an organized place to store data. Think of it like a digital
cupboard. Instead of keeping papers in a messy box, you keep information in neat drawers so you can find
it quickly.
A DBMS means Database Management System. It is the software that helps
you create, store, search, update, and protect the database. In easy words, the database is the storage,
and the DBMS is the helper that manages it.
💡 Easy analogy
A database is like a library shelf. The DBMS is the librarian who arranges the books, finds the right
one, and makes sure everything stays in order.
Database
A collection of related data stored in an organized way so it is easy to find
and use later.
DBMS
The software that helps you work with the database. It is like the manager of
the storage system.
Importance
It saves time, avoids confusion, reduces duplicate work, and helps data stay
safe and neat.
Application
Used in schools, banks, hospitals, shops, mobile apps, websites, and almost
any place that stores records.
Data is raw facts. It may not make sense by itself. For example, 98, 45, 67 are
just numbers.
Information is data that has been processed and now has meaning. For example, 98
marks in science tells you something useful.
Data
Raw numbers, names, dates, or symbols before they are organized.
Information
Data after it has been arranged so a person can understand and use it.
Database
A structured place where data is stored for later use.
DBMS
The software that helps manage the database properly.
Remember
Data becomes information only when it starts telling a clear story.
Most databases keep data in tables. A table looks like a spreadsheet. It has
rows and columns.
A row stores one complete record. A column stores one type of detail,
like name or age.
Table
A collection of related records, like a student list or a book list.
Row
One full record. In a student table, one row could be one student.
Column
One field or category of information, like name, class, or roll number.
💡 Easy analogy
If a table is a class register, each row is one student and each column is one detail about that
student.
A data type tells the database what kind of value it should store in a column. For
example, a name needs text, while age needs a number.
Keys help identify records and connect tables. They make the database organized and
safe.
Example table idea
StudentID | Name | Class | Age
1001 | Asha | 10 | 15
1002 | Ramesh | 10 | 16
Memory tip
Primary key = the main identity card. Foreign key = the link between two tables.
MySQL is a popular DBMS. It lets us create databases, make tables, add records, and
search information using SQL.
SQL means Structured Query Language. A query is just a question or
command you ask the database.
💡 Simple picture
If the database is a notebook full of records, SQL is the language you use to ask the notebook for the
exact page you want.
CREATE DATABASE school;
Makes a new database named school.
CREATE TABLE students (...);
Makes a new table for storing student records.
INSERT INTO students ...
Adds new data into the table.
SELECT * FROM students;
Shows the records stored in the table.
SQL commands are often grouped into two useful families:
Mini SQL example
CREATE TABLE students (
student_id INT,
name VARCHAR(50),
age INT
);
INSERT INTO students VALUES (1001, 'Asha', 15);
SELECT * FROM students;
Unit 2 is not only about reading. You should also practice using a real database tool like MySQL. The
more you do it, the less scary it becomes.
Install MySQL
Set up the database software on your computer so you can practice commands.
Create Database
Make a new database for a topic like students, books, or products.
Create Table
Build a table with proper column names and data types.
Keys and Relations
Try primary key and foreign key examples so table links make sense.
Queries
Practice SELECT, WHERE, LIKE, INSERT, UPDATE, and DELETE step by step.
Structure Changes
Use ALTER to change a table when you need to add or modify a column.
Quick study tip
First understand the meaning, then practice the SQL command, then repeat it from memory once. That is
the fastest way to learn.
🧠 Quick Quiz
Question 1
What is the difference between a database and a DBMS?
Database stores the data. DBMS helps manage, search, update, and protect that
data.
Question 2
What does a row mean in a table?
A row is one complete record, like one student’s full information.
Question 3
Which command is used to show data from a table?
SELECT is used to read or display data.
Question 4
Why is a primary key important?
It gives every record a unique identity so records do not get mixed up.
