Database.

Database.

1. DBMS

   • DDL
     • Tables.
       • CREATE TABLE *TABLE_NAME*
     • ALTER
       • ALTER TABLE *TABLE_NAME* ADD *ATTRIBUTE* (TYPE OF DATA)
     • DROP
       • ALTER TABLE table_name DROP INDEX index_name
     • PRIMARY KEY
       • primary key(ATRIBUTE)
     • FOREIGN KEY
       • foreign key (ATTRIBUTE) references SOURCE_TABLE(SOURCE_ATTRIBUTE)
     • NULL VALUES
       • ATTRIBUTE_NAME TYPE OF DATANOT NULL