One-Pager — DBMS & SQL (P2)

• Degree = columns; Cardinality = rows
• PK unique+NOT NULL; FK references PK
• 1NF atomic → 2NF no partial → 3NF no transitive
• ACID; JOIN combines tables
• DDL: CREATE/ALTER/DROP; DML: INSERT/UPDATE/DELETE/SELECT
• Aggregate: COUNT SUM AVG MIN MAX; HAVING filters groups

Practice: practice/topic-mcqs/09-dbms-sql.md