Tag: Tutorial

Back up databases regularly and practice restores.

Move data with dumps, CSV imports, and export tools.

Model parents with many children via a foreign key on the child.

Resolve M:N with a junction table of two foreign keys.

Keep relationships valid so child rows cannot orphan parent keys.

Configure ON DELETE / ON UPDATE actions on foreign keys.

Understand SQL injection as a risk and prevent it with safe query patterns.

Ensure atomic values and no repeating groups in 1NF.

Remove partial dependencies on composite keys for 2NF.

Remove transitive dependencies for 3NF.