Database modification in a Database Management System (DBMS) involves making changes to the data stored in the database. There are several types of modifications that can be performed in a DBMS, including insertion, updating, and deletion of records. Here's an overview of each:
INSERT INTO Employees (EmployeeID, FirstName, LastName, Salary) VALUES (101, 'John', 'Doe', 50000);
Updating:
UPDATE Employees SET Salary = 55000 WHERE EmployeeID = 101;
Deletion:
DELETE FROM Employees WHERE EmployeeID = 101;