Unit 2 Practicals | Database Management System Class 10

Unit 2 Practical Sheet

Database Management System

Create, insert, query and change data by typing your own SQL and seeing the result immediately.

SQLTablesKeysMySQLSQLite

← Back to Syllabus

These practicals are for simple doing and checking. Students should create a table, enter data, run SQL and see the result right away.

Do first

1. Open MySQL, PostgreSQL or SQLite.
2. Create one small table.
3. Insert two or three rows.
4. Run one SELECT query and read the result.

Do in class

1. See how a database stores rows and columns using a real table.
2. Type the teacher's SQL statement and run it.
3. Change one value and see what happens.
4. Write the query, the result and one short observation in your notebook.

Evaluation

1. Quizzes and tests on DBMS concepts and SQL syntax.
2. Peer evaluation of query writing and result checking.
3. Presentation of a working database and sample queries.

1

Mini challenge simple class task

Create a table for students with name, class and roll number. Insert three students and find only the names that start with a letter.

2

Step-by-step tasks practice by typing SQL

Task 1 — Install MySQL / SQLite

1. Install MySQL (or use SQLite for quick practice). For MySQL use official installer or Homebrew: brew install mysql.
2. Start the server and login: mysql -u root -p.

Task 2 — Create database & table

1. Run the SQL below to create a database and one table.

CREATE DATABASE school; USE school; CREATE TABLE students ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100), dob DATE );

1. Verify with SHOW TABLES; and DESCRIBE students;.

Task 3 — Insert & query data

INSERT INTO students (name, dob) VALUES ('Asha','2010-05-10'); SELECT id, name FROM students WHERE name LIKE 'A%';

Task 4 — Keys & relationships

1. Create a marks table with student_id as FOREIGN KEY referencing students(id).
2. Insert sample marks and run a JOIN query to show student names and marks.

Task 5 — DDL & DML practice

1. Use ALTER TABLE to add a new column class INT.
2. Practice UPDATE and DELETE safely using WHERE.

3

Student output what to submit

Notebook

1. Write each SQL statement before running it.
2. Copy the result below the statement.

Record

1. Save screenshots or pasted output for CREATE, INSERT, SELECT, UPDATE and DELETE.
2. Add one line about what happened.

Unit 2 practical sheet designed for hands-on SQL practice.