RATAN TATA MAHARASHTRA STATE SKILLS
UNIVERSITY
School of Science Engineering and Technology Skills
Department of Engineering
Assignment 3
● PROBLEM STATEMENT: TO IMPLEMENT DML COMMANDS OF SQL TO
SUITABLE EXAMPLE
● TOOLS: MySQL Workbench 8.0 CE version.
● THEORY:
1. What is DML in SQL?
→DML (Data Manipulation Language) commands are used to manage and manipulate the data stored
in database tables. Using DML commands such as INSERT, UPDATE, DELETE, and SELECT, we
can add new records, modify existing records, remove records, and retrieve data from a database.
These commands work on the records of a table, not on its structure.
2. What are DML commands?
→The main DML commands are:
INSERT – to add new data, UPDATE – to modify existing data, DELETE – to remove data
SELECT – to display data.
● INSERT Command: INSERT is used to add new rows (records) into a table.
Syntax:INSERT INTO table_name VALUES (value1, value2, value3, ...);
● UPDATE Command: UPDATE is used to change existing data in a table.
Syntax: UPDATE table_name
SET column_name = new_value
WHERE condition;
● DELETE Command: DELETE is used to remove records from a table.
Syntax: DELETE FROM table_name
WHERE condition;
TASK – 1
● Problem Statement:
-To insert at least five records into the Employee table using the INSERT command.
-To display all information of employees from the Employee table using the SELECT command.
RATAN TATA MAHARASHTRA STATE SKILLS
UNIVERSITY
School of Science Engineering and Technology Skills
Department of Engineering
problem Statement:
To display all records of employees who belong to the “Mechanical” department.
TASK – 3
● Problem Statement:
To update the city of the employee whose Emp_no is 4 as “nagpur” using the UPDATE
command.
TASK – 4
● Problem Statement:
To delete the email ID of the employee named “” using the DELETE/UPDATE
command.
RATAN TATA MAHARASHTRA STATE SKILLS
UNIVERSITY
School of Science Engineering and Technology Skills
Department of Engineering
Problem Statement:
To delete the E_ph_no of the employee whose Emp_no is 1 without deleting the
entire record.
● Conclusion: In this experiment, the Data Manipulation Language (DML) commands of SQL
were successfully implemented. Records were inserted into the Employee table, employee details
were displayed, specific records were retrieved using conditions, existing data was updated, and
unwanted data was deleted. This practical helped in understanding how INSERT, SELECT,
UPDATE, and DELETE commands are used to manage and manipulate data in a database
efficiently.
RATAN TATA MAHARASHTRA STATE SKILLS
UNIVERSITY
School of Science Engineering and Technology Skills
Department of Engineering
RATAN TATA MAHARASHTRA STATE SKILLS
UNIVERSITY
School of Science Engineering and Technology Skills
Department of Engineering
TASK – 5