Assignment 1
DATABASE MANAGEMENT SYSTEM
A database management system (DBMS) is system software for creating and managing databases.The most prevalent type of data management platform, the DBMS essentially serves as an interface between databases and users or application programs, ensuring that data is consistently organized and remains easily accessible.);
Example
CREATE TABLE DEPT (
DEPT_ID INT NOT NULL, 
DEPT_NAME VARCHAR (20) NOT NULL, 
PRIMARY KEY (DEPT_ID)
);
5-DROP statement: Drop command helps to delete the object from the database.DDL (Data Definition Language)
o	DDL or Data Definition Language consists of the SQL commands that can be used to define the database schema.DML (Data Manipulation Language)
o	The SQL commands deal with the manipulation of data present in the database belonging to DML or Data Manipulation Language and this includes most of the SQL statements.Syntax
Select * from Table_Name;
or
SELECT column name
 FROM table name
 WHERE column name = value;

8-uptade 
SQL Update command is helpful to update the existing data in a table.Syntax
UPDATE table name 
SET "COLUMN 2 NAME" = "NEW VALUE" 
WHERE "COLUMN 1 NAME" = "VALUE";

9-DELETE
SQL Delete command helps to delete the records from a database table. syntax
DELETE FROM "TABLE NAME" 
WHERE "COLUMN NAME" = "VALUE"
10-alter
Alter command is helpful to change or modify the structure of the database or its object.2.3.