Database Modification

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:

• Insertion:
  • Purpose: Add new records to a table.
  • SQL Command: INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);
  • Example:

INSERT INTO Employees (EmployeeID, FirstName, LastName, Salary) VALUES (101, 'John', 'Doe', 50000);

Updating:

• Purpose: Modify existing records in a table.
• SQL Command: UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;
• Example:

UPDATE Employees SET Salary = 55000 WHERE EmployeeID = 101;

Deletion:

• Purpose: Remove records from a table.
• SQL Command: DELETE FROM table_name WHERE condition;
• Example:

DELETE FROM Employees WHERE EmployeeID = 101;