Task data, relationships, and reports

Protect relationships with keys and constraints, then join and count task records deliberately.

SQL tables, keys, and constraints

Create related people/tasks tables and observe primary, unique, foreign-key, CHECK and NOT NULL rules.

Compare inner/left joins, count child IDs, and retain people with zero matching tasks.