Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database Management System (DBMS) - Coggle Diagram
Database Management System (DBMS)
Software package designed to manipulate database
Database Definition Language(DDL)
Syntax
DROP
DROP TABLE <table_name>
RENAME
RENAME <OldTableName> TO <NewTableName>
ALTER
ALTER TABLE <table_name> ADD (<NewColumnName> <Data_Type>(<size>),......n)
DROP
ALTER TABLE <table_name> DROP COLUMN <column_name>
CREATE
CREATE TABLE Student (Reg_no varchar2(10), Name char(30), DOB date, Address varchar2(50));
A syntax for creating and modifying database objects such as tables, indexes, and users.
Database Manipulation Language(DML)
Syntax
DELETE
DELETE dataset.Inventory
WHERE quantity = 0
UPDATE
UPDATE target_name [alias]
SET update_item [, update_item]*
[FROM from_clause]
WHERE condition
INSERT
INSERT dataset.NewArrivals (product, quantity, warehouse)
VALUES('top load washer', 100, 'warehouse #1'),
('dryer', 200, 'warehouse #2')
a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database.
Function
set up on specific data handling concepts, as the practice of administrating a database evolves
Example