Lakhasly

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.

Assignment 1
DATABASE MANAGEMENT SYSTEM
A database management system (DBMS) is system software for creating and managing databases. A DBMS makes it possible for end users to create, protect, read, update, and delete data in a database. 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.

• SQL or Structured Query Language is a critical tool for data professionals. It is undoubtedly the most important language for getting a job in the field of data analysis or data sciences.

• SQL commands

1. DDL (Data Definition Language)
   • DDL or Data Definition Language consists of the SQL commands that can be used to define the database schema.
   • For example, CREATE: This command is used to create the database.


2. DML (Data Manipulation Language)
   • 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.
   • For example, INSERT: It is used to insert data into a table.


3. DCL (Data Control Language)
   • DCL deals with the rights, permissions, and other controls of the database system.
   • For example, GRANT: This command gives users access privileges to the database.
   • DDL
   1-CREATE DATABASE: This command is used to create a new
   database.
   Syntax
   CREATE DATABASE database name ;
   2-USE DATABASE: To use and activate a specific database in SQL
   syntax
   USE database name ;
   3-DROP DATABASE: to delete a database
   Syntax
   DROP DATABASE database name;
   4-CREATE TABLE:
   Syntax
   CREATE TABLE table name (
   column1 datatype,
   column2 datatype,
   column3 datatype,
   ....
   );
   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.
   Syntax:
   DROP TABLE table name;
   6- INSERT
   To add data inside a table.
   Example
   INSERT INTO table name;
   VALUES (1, 'CS’) 7-SELECT
   SQL SELECT a query on a table or tables to view the temporary table output from the database.

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.
Syntax
ALTER TABLE "TABLE NAME"
ADD CONSTRAINT "CONSTRAINT NAME" CHECK (CONSTRAINT VALUE);
Or
ALTER TABLE "TABLE NAME"
DROP CONSTRAINT "CONSTRAINT NAME";

الاسم/عمرو خالد صابر
الفرقة التانية
الكلية/ حاسبات ومعلومات