Database

Normal Form

https://www.geeksforgeeks.org/database-normalization-normal-forms/

• 1NF: each column must be single-valued attribute. (one to many)
• 2NF: a relation must be in first normal form and relation must not contain any partial dependency. (table have PK1, PK2, B, C, and C depend on B, this is partial dependency)
• 3NF

SQL

• DDL (Data Definition Language): create, drop, alter
• DML (Data Manipulation Language): select, insert, update, delete
• DCL (Data Control Language): commit, rollback, grant, revoke